Subledger or XLA To GL Transfer Process in R12 (Doc ID 1325133.1) PDF
Subledger or XLA To GL Transfer Process in R12 (Doc ID 1325133.1) PDF
Subledger or XLA To GL Transfer Process in R12 (Doc ID 1325133.1) PDF
In this Document
Purpose
Questions and Answers
1. What are the important tables for sub-ledger accounting?
2. How the SLA events get generated?
3. What are the steps to transfer the data to GL from the subledgers?
4. Which process push the data into which tables?
5. What data will be there in xla_control_balances?
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?
7. Is SLA only for the journal lines we have created rules for ?
8. Where to find more FAQs on Transfer to GL process in R12?
References
APPLIES TO:
PURPOSE
This document will provide answers to some frequently asked questions about the GL Transfer process.
Please note that the FAQs are applicable to ALL subledgers unless specifically mentioned.
xla_transaction_entities
xla_events
xla_ae_headers
xla_ae_lines
xla_distribution_links
xla_control_balances
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
1 of 2 29/03/2016 10:40 PM
Document 1325133.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-sta...
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
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 ?
REFERENCES
2 of 2 29/03/2016 10:40 PM