My Oracle Support Banner

R12 Mapping Between Subledger Tables, SLA and GL Tables (Doc ID 871622.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Purchasing - Version 12.0 and later
Oracle 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

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