Cloud GL to ESSBase Cubes – How to Ensure Successful GL Posting
Reference: Checklist to Ensure Successful Posting (Doc ID 2158295.1)
SubLedger Accounting
How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger
How does the XLA_DISTRIBUTION_LINKS table map to the Fixed Asset Subledger? For transactions like Additions, Adjustments, and Retirements etc. the mapping is: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = FA_ADJUSTMENTS.TRANSACTION_HEADER_ID XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = FA_ADJUSTMENTS.ADJUSTMENT_LINE_ID For Depreciation event transaction rows: XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_CHAR_4 = […]
XLA_DISTRIBUTION_LINKS
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 […]
Mapping between GL and XLA tables
How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at […]
GL_BALANCES
Summary GL_BALANCES contains actual, budget, and encumbrance balances for detail and summary accounts. This table stores ledger currency, foreign currency, and statistical balances for each accounting period that has ever been opened. ACTUAL_FLAG is either […]
AP Intercompany Accounting and XLA
AP Intercompany Accounting and XLA_DISTRIBUTION_LINKS table Question: When I enter intercompany invoice or make an Intercompany payment in R12 EBS, i could see the corresponding sub ledger accounting entries in the “View Journal entries” screen. […]
What are the different methods to transfer Sub ledger journals to GL
What are the different methods to transfer Sub ledger journals to GL? a) ONLINE MODE GL Transfer can be spawned during Online Accounting using the “Final Post” option for a specific document (Example: AP Invoice and […]
What are the tables involved in the Transfer to GL and GL posting
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 R12
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 […]
ACCOUNTING_ENTRY_STATUS_CODE Column In XLA_AE_HEADERS Table R12
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. […]
Enterprise Resource Planning and Integrations BlogSpot 