Monday 21 January 2013

FAQ's on Subledger to GL Transfer R12

1. What are the important tables for sub-ledger accounting?
 xla_transaction_entities
 xla_events
 xla_ae_headers
 xla_ae_lines
 xla_distribution_links
 xla_control_balances

2. How the SLA events get generated?
 Through the SLA API's in the subledgers' code

3. What are the steps to transfer the data to GL from the subledgers?
 Submit Create Accounting / Transfer Journal Entries to GL.
 1. Create Accounting
 2. Tranfer to GL (includes Journal Import)
 3. Post to GL

4. Which process push the data into which tables?
 Create Accounting     - Subledger tables and xla_events  -> xla_ae_headers, xla_ae_lines and xla_distribution_links
 Transfer to GL              - xla_ae_headers and xla_ae_lines  -> gl_je_headers and gl_je_lines
 Post to GL                     - gl_je_headers and gl_je_lines    -> gl_balances
 Subledger Accounting Balances Update - xla_ae_headers and xla_ae_lines  -> xla_control_balances

5. What data will be there in xla_control_balances?
 Balances related to Third Party Control Accounts

No comments:

Post a Comment