My Oracle Support Banner

R12: FAQ on Transfer to GL in R12 (Doc ID 876190.1)

Last updated on JULY 04, 2023

Applies to:

Oracle General Ledger - Version 12.0.4 to 12.1 [Release 12.0 to 12.1]
Oracle Payables - Version 12.0.4 to 12.1.0 [Release 12.0 to 12.1]
Oracle Assets - Version 12.0.4 and later
Oracle Receivables - Version 12.0.4 to 12.1 [Release 12.0 to 12.1]
Oracle Cost Management - Version 12.0.4 to 12.1 [Release 12 to 12.1]
Information in this document applies to any platform.


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.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 1. What are the tables involved in the Transfer to GL and GL posting?
 2. What are the different methods to transfer Subledger journals to GL?
 3. What columns indicate the Transfer Status of accounting data in subledger?
 4. What is the setup option that determines the level of detail in the accounting lines created for a specific transaction in XLA_AE_LINES?
 5. What is the setup option that determines if transfer to GL is in detail or summarised mode?
 6. What are the different combinations of the two setup options that determine if transfer to GL is in summary or detail and the corresponding outcome?
 7. What columns associate GL data back to the SLA data?
 8. Why are reference columns in GL_IMPORT_REFERENCES not populated by the R12 Transfer to GL process, which is unlike 11i?
 9. What is the default value for the Transfer to GL in the seeded journal line types (JLT)?
 10. If a customer's business requires a different setup than the default, can the seeded JLT be updated?
 11. How many group_ids are created during the transfer process when there is a primary ledger and associated ALC/reporting ledger?
 12. How many group_ids are created during transfer process when there is a primary ledger and a secondary ledger?
 13. Is there a setup to prevent spawning the Journal Import on instances where a third party (e.g., Peoplesoft) GL is used?
 14. Is there a diagnostics script available to detect issues with transfer process?
 15. When is data inserted into the XLA_TRIAL_BALANCES table?
 16. Why are the original encumbrance entries not transferred to GL before the reversal encumbrance journals?
 17. Journals are Transferred to the GL but cannot be drilled down on?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.