Sub Ledger Transactions ID's which links to SOURCE_ID_INT_1 in XLA_TRANSACTION_ENTITIES Table in GL

 

All Sub Ledger Transactions whether AP or AR goes to General Ledger XLA Tables after submission accounting event.
Below are the links thorough which you can find the data of Sub-Ledger in XLA Tables.

Table: XLA_TRANSACTION_ENTITIES

SOURCE_ID_INT_1 = INVOICE_ID (AP Invoice from AP_INVOICES_ALL)

SOURCE_ID_INT_1 = CHECK_ID (AP Payment from AP_CHECKS_ALL)

SOURCE_ID_INT_1 = CUSTOMER_TRX_ID (AR Invoice from RA_CUSTOMER_TRX_ALL)

SOURCE_ID_INT_1 = CASH_RECEIPT_ID (AR Receipt from AR_CASH_RECEIPTS_ALL)

Here from XLA_TRANSACTION_ENTITIES you can note "ENTITY_ID" and find the events in "XLA_EVENTS"

#oracleebs #oracler12 #xlatables #generalledger #ap #ar #sql #query #apinvoice #appayment #artransaction #arreceipt #xlatransactionentities #xlaevents