My Oracle Support Banner

Mapping Between PO Tables And General Ledger Tables (Doc ID 461103.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Purchasing - Version 11.5.10 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.
***Checked relevance on 08-JUL-2013***

Goal

Would like to get the underlying Purchasing details from GL_JE_LINES and GL_IMPORT_REFERENCES.

Example: For a Purchasing Source - we can find all journal lines from GL_JE_LINES. We would like
to know how these journal map to Purchasing tables so that we can see more details.

We need the mappings from GL tables to GL_JE_LINES and GL_IMPORT_REFERENCES to PO (Oracle
Purchasing) tables. All transactions from Purchasing are transferred to GL in summary mode.

Solution

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
Goal
Solution


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