Why XLA_DISTRIBUTION_LINKS table cannot be used while reconciling to GL This table contains the link between transactions and subledger journal entry lines. Provide more accurate information as how GL lines or XLA_AE_LINES are derived from […]
What are the tables involved in the Transfer to GL and GL posting? Subledger Tables XLA_AE_HEADERS XLA_AE_LINES XLA_DISTRIBUTION_LINKS a) Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface […]
EVENT_STATUS_CODE and PROCESS_STATUS_CODE in XLA_EVENTS Table – EVENT_STATUS_CODE – PROCESS_STATUS_CODE Note: If an event has event_status_code = P and process_status_code = F but is still in xla_ae_headers with GL_Transfer = No, then the event has […]
What Does “ACCOUNTING_ENTRY_STATUS_CODE” Column Represent In “XLA_AE_HEADERS” Table? The Column represents Accounting Status of a Transaction Event. The following describes the Values and their Descriptions: 1. If ACCOUNTING_ENTRY_STATUS_CODE = ‘F’ then event is accounted successfully. 2. […]
What are the setup options that determines if transfer to GL is in detail or summarized mode There are two variables that determine how the data is transferred to GL from the subledger tables XLA_AE_HEADERS […]
What columns in XLA_AE_HEADERS indicate the Transfer Status of accounting data in subledger? The XLA_AE_HEADERS table shows the transfer status of the accounting data, after successful transfer to the GL and Journal Import: XLA_AE_HEADERS.gl_transfer_status_code = […]
The Link between GL to SLA and reference columns in GL_IMPORT_REFERENCES Since there is always a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the subledgers. GL_IMPORT_REFERENCES.gl_sl_link_id => XLA_AE_LINES.gl_sl_link_id GL_JE_BATCHES.group_id => […]
Data flow between AR and SLA Queries to retrieve data from XLA tables for a given AR transaction Q1) Get the customer_trx_id for the transaction number SELECT * FROM ra_customer_trx_all WHERE trx_number = &trx_number; Q2) […]
AR Transaction to SLA Link R12 Important columns in the RA_CUST_TRX_LINE_GL_DIST table include: CUST_TRX_LINE_GL_DIST_ID column CODE_COMBINATION_ID column CUSTOMER_TRX_LINE_ID column ACCOUNT_CLASS column AMOUNT column The RA_CUST_TRX_LINE_GL_DIST table stores the accounting distribution for invoice, debit memo, and […]
AR Adjustments to SLA Link R12 Accounting Data Model – Adjustments •Where postable <> ‘N’ •Status should be ‘A’ •Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=ADJ) •Debit & credit amounts should match •Adjustments Status = ‘W’ (Waiting […]
Enterprise Resource Planning and Integrations BlogSpot 