Oracle SLA Tables

Given below are the tables to be referred when an invoice has been created in Payables and accounted either online or using create accounting program.

1. select * from xla_transaction_entities where source_id_int_1=<invoice_id>

Few of the columns explained:
source_id_int_1 = invoice_id
entity_code='AP_INVOICES'
security_id_int_1=org_id
transaction_number=invoice number

get the entity_id from xla_transaction_entities

2. select * from xla_events where entity_id=<entity_id>

Few of the columns explained:
event_type_code can be 'INVOICE VALIDATED','CREDIT MEMO VALIDATED','PAYMENT CREATED' etc
event_status_code can be 'P' processed 'U' unprocessed etc
'P' when the accounting is done in 'Final' or 'Final Post' mode.
'U' when the accounting is done in 'Draft' mode.
process_status_code can 'D' for draft 'P' for processed etc

get the event_id from xla_events

3. select * from xla_ae_headers where event_id=<event_id>

gl_transfer_status_code will be 'Y' when accounting done in 'Final' mode, where accounting
entries are transferred to GL.
gl_transfer_status_code will be 'N' when accounting done in 'Draft' mode.

get ae_header_id from xla_ae_headers

4. select * from xla_ae_lines where ae_header_id=<ae_header_id>

5. select * from xla_distribution_link where ae_header_id=<ae_header_id>

source_distribution_id_num_1 will have the invoice distribution id