R12 Mapping Between Subledger Tables, SLA and GL Tables
(Doc ID 871622.1)
Last updated on MAY 06, 2024
Applies to:
Oracle Purchasing - Version 12.0 and laterOracle Inventory Management - Version 12.0.0 and later
Oracle Cost Management - Version 12.0.0 and later
Information in this document applies to any platform.
Oracle Inventory Management - Version: 12.0.0 to 12.1.1
Oracle Cost Management - Version: 12.0 to 12.1.1
Information in this document applies to any platform.
Purpose
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
Scope
This paper will benefit Customers,Consultants and Oracle Support Engineers
Details
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
| Purpose |
| Scope |
| Details |
| SOURCE PO TABLE |
| XLA_TABLES |
| GL_TABLES |
| DATA COLLECTION SQL SCRIPTS |
| Still Have Questions? |
| References |