Transactions to GL: Tables Step by Step

Transactions to GL: Tables step by step

Oracle EBS GL tables are populated in this approach:


Step 1: Data will be in XLA_EVENTS, XLA_AE_HEADERS, XLA_AE_LINES

Check xla_ae_headers table if the transactions are transfered to GL successfully.

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 version:

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 (this indicates the upgraded data from 11i)

In case of errors, refer to xla_accounting_errors table.

Step 2: Query GL_IMPORT_REFERENCES table. It has reference to gl_sl_link_id column in xla_ae_lines table.

Step 3: In this stage you can query GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LNES tables.

You may find this link helpful: http://www.orafaq.com/node/2242