Brief Overview of Receipt Accounting The following is a brief overview of the Receipt Accounting flow for either Perpetual Accruals (Online) or Periodic Accruals (Period End). This overview does not contain information associated with Encumbrance […]
Oracle Fusion HCM Technical Overview & Security Maintenance
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_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? 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? 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 = […]
Enterprise Resource Planning and Integrations BlogSpot 