Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 96 Vote(s) - 2.43 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Financials - Data Flow From SLA to GL
10-14-2010, 05:11 AM,
Oracle Financials - Data Flow From SLA to GL
1. What are the tables involved in the Transfer to GL and GL posting?
Download document

.pdf   Data Flow from SLA to GL.pdf (Size: 116.05 KB / Downloads: 1,502)

Subledger Tables

Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface Tables

Interface Tables

Journal Import (GLLEZL) then reads from the interface table and creates records in the GL Tables

GL Tables

GL Posting process then posts to the GL_BALANCES table.
What are the different methods to transfer Subledger journals to GL?
GL Transfer can be spawned during Online Accounting using the "Final Post" option for a specific document (Example: AP Invoice and AR Transaction).
Example: Navigation in Payables: Invoices/Entry/Invoices: Action: Create Accounting/Final Post. This spawns the GL Transfer, the Journal Import, Data Manager and the GL Posting processes. This request transfers ALL the final accounted data for that document. This method of transfer uses the interface table GL_INTERFACE to move the journals to the general ledger.

GL Transfer can also be spawned by the Create Accounting concurrent request when submitted with the "Transfer to GL" parameter set to Y.
Example: Navigation in Payables: Other/Request/Run: Create Accounting
This spawns the journal import and the data manager processes. The GL Posting process is spawned if the Post to GL parameter is set to Yes when submitting the Create Accounting. This request transfers all the final accounting created by the Create Accounting request that spawned it. This method uses the interface table XLA_GLT_.

GL Transfer can be submitted in standalone mode using the concurrent request "Transfer Journal Entries to GL".
Example: Navigation in Payables: Other/Request/Run: Transfer Journal Entries to GL
This spawns the Journal Import and the Data Manager programs. This request transfers all the final accounting that exists for the given ledger and end date. This method uses the interface table XLA_GLT_.
What columns indicate the Transfer Status of accounting data in subledger?
The XLA_AE_HEADERS table shows the transfer status of the accounting data, after successful transfer to the GL and Journal Import:
XLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is not null
XLA_AE_HEADERS.group_id is not null
For 11i data upgraded to R12, the transfer status can be determined using the following
XLA_AE_HEADERS.gl_transfer_status_code = Y
XLA_AE_HEADERS.gl_transfer_date is null
XLA_AE_HEADERS.group_id is null
XLA_AE_HEADERS.upg_batch_id is not null --> indicates 11i data

How many group_ids are created during the transfer process when there is a primary ledger and associated ALC/reporting ledger?
The primary ledger data and associated ALC/reporting ledger data goes into one group_id. Data from this one group_id can be split across multiple GL Batches based on other criteria, such as je_category/date/period. However, one GL Batch can only be associated to one group_id.
Thanks given by: Alloffgok , jhonka , cok3cl
08-13-2015, 05:53 PM,
RE: Oracle Financials - Data Flow From SLA to GL
You can also refer below notes on My Oracle Support
This document covers the following topics:
  • Understanding the AP-SLA-GL reconciliation

  • Reconciling the amounts and understanding the data flow between SLA and GL

  • Establishing a baseline for addressing 11i upgrade data related issues.

  • Reconciling R12 data and addressing R12 Trial Balance-GL issues

  • Understanding how UNDO Accounting can impact Reconciliation
R12 Mapping Between Subledger Tables, SLA and GL Tables (Doc ID 871622.1)
With the introduction of Subledger Accounting(SLA) it has become very difficult to find the relationship at table level between the subledgers and XLA Tables and General Ledger tables. We will examine the Table links of Accounting Data Flow as data moves from PO tables to RRSL to XLA Tables to GL Tables. We will present some relevant sql scripts to use in collecting subledger data, SLA data and GL data

SLA Data Flow and Table Links (Doc ID 802966.1)
This link will help .... How does the data flow from Inventory to General Ledger(GL)? What are the tables that are involved?
Thanks given by:
05-27-2019, 11:48 PM,
RE: Oracle Financials - Data Flow From SLA to GL
Thanks given by:
05-28-2019, 04:59 PM,
RE: Oracle Financials - Data Flow From SLA to GL
Thanks given by:
05-28-2019, 05:21 PM,
RE: Oracle Financials - Data Flow From SLA to GL
Thanks given by:
05-28-2019, 05:22 PM,
RE: Oracle Financials - Data Flow From SLA to GL
I can not download any files please explain how to download files
Thanks given by:
10-06-2020, 02:31 AM,
RE: Oracle Financials - Data Flow From SLA to GL
How do you download these docs?
Thanks given by:
11-30-2020, 06:46 PM,
RE: Oracle Financials - Data Flow From SLA to GL
Thank you
Thanks given by:
12-17-2020, 11:26 PM,
RE: Oracle Financials - Data Flow From SLA to GL
Thanks given by:

Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle HCM Cloud Interview Questions MM Ifan 1 50,148 06-06-2021, 12:16 AM
Last Post: zaidmd
  Oracle Implementation Project Plan admin 35 140,867 04-29-2021, 06:59 AM
Last Post: Cwahsayz
  Oracle ERP Implementation Project Schedule based on OUM Kashif Manzoor 7 25,544 03-31-2021, 11:45 PM
Last Post: haydara
  Oracle Inventory Module End User Training Material James Robert 1 29,378 08-27-2020, 08:59 PM
Last Post: shahid
  Oracle Inventory Miscellaneous Transactions Mark Donald 1 27,956 08-20-2020, 05:34 PM
Last Post: shahid
  Oracle Fusion Financials General Ledger Essentials M Irfan 5 92,133 08-20-2020, 05:32 PM
Last Post: shahid
  Oracle AIM - RD050 Business Requirement Documents admin 10 107,009 06-04-2020, 05:28 AM
Last Post: Shashi
  Oracle AIM - BR100 Documents admin 37 242,904 05-13-2020, 06:53 PM
Last Post: amjad.orafunctional
  AIM Vs OUM - Application Implementation Methodology vs Oracle Unified Methodology Kashif Manzoor 7 43,114 12-11-2019, 10:50 PM
Last Post: abuzeids
  Oracle E-business Suite Implementation Operational Analysis Questionnaire Kashif Manzoor 8 73,859 09-06-2019, 08:15 PM
Last Post: craigrfranklin

Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!