FAQ on Subledger or XLA to GL Transfer Process In 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?

a. Create Accounting
b. Transfer to GL (includes Journal Import)
c. Post to GL

To transfer the journals from SLA to GL, you will have to run create accounting program in final mode from respective Sub-ledger i.e. AR,AP,CM,FA,PO etc. This program looks after your SLA accounting rules and accordingly generates the entries and transfer them to GL.

If you want to see the journals first before transferring them to GL, you can run the same program in Draft mode before running in final mode.

If you have already run the create accounting but not transferred to GL, it is sufficient to run the "Transfer Journal Entries to General Ledger" concurrent request.

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

6. Does all subledger eg (AP,INV,AR) that transfer to GL will have to go through SLA by a must, or they can be transferred directly to GL?

It's must, all the Subledgers shall be routed through SLA which my be Seeded one or Customized

7. Is SLA only for the journal lines we have created rules for ?

No, its applicable for all lines.