Results for “xla_ae_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XLA_AE_LINES is the core line-level table of Oracle Subledger Accounting (XLA), the module responsible for generating and storing accounting entries for all subledgers in Oracle E-Business Suite. Owned by the XLA schema, the table holds the individual debit, credit, and statistical journal entry lines produced by the Subledger Accounting program each time a subledger transaction is accounted. The table maintains a one-to-many relationship with subledger journal entry headers, meaning that a single accounting event header can generate multiple distribution lines, one per accounting rule output, balancing segment, or offset. This structure underpins the Create Accounting process and feeds the transfer of journal entries to the General Ledger.

Under the heuristic Data Vault classification mined from its foreign key structure, XLA_AE_LINES is treated as a standalone object. In Data Vault modeling terms, it behaves primarily as a satellite or detail table capturing transactional line measures, with its linkage to header and reference data handled through foreign keys rather than a pure hub or link pattern. Practitioners adopting Data Vault methodology may therefore model this table as a satellite attached to a header hub, preserving the descriptive and financial attributes it carries.

Key Information Stored

The table contains 73 documented columns, of which a functional subset drives most reporting and integration. The primary key is XLA_AE_LINES_PK, defined on the composite of AE_HEADER_ID and AE_LINE_NUM. A unique index, XLA_AE_LINES_U1, extends this to (AE_HEADER_ID, AE_LINE_NUM, APPLICATION_ID) and serves as a business-key candidate.

• AE_HEADER_ID and AE_LINE_NUM — the surrogate composite key linking each line to its journal entry header and sequencing lines within it.
• APPLICATION_ID — identifies the source application that created the accounting line.
• CODE_COMBINATION_ID and SUBSTITUTED_CCID — the accounting flexfield combination and any substituted account used for the line.
• ENTERED_DR and ENTERED_CR — the entered debit and credit amounts in the transaction currency.
• ACCOUNTED_DR and ACCOUNTED_CR — the accounted debit and credit amounts in the ledger currency.
• CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, and CURRENCY_CONVERSION_TYPE — currency and conversion details when a rate is applied.
• ACCOUNTING_CLASS_CODE and ACCOUNTING_DATE — the accounting class of the line and the date it is recognized.
• LEDGER_ID — the ledger to which the line is posted.
• STATISTICAL_AMOUNT — statistical (non-monetary) quantities.
• GL_TRANSFER_MODE_CODE and GL_SL_LINK_ID — control the transfer of the line to GL and link it to the GL journal.
• SOURCE_TABLE and SOURCE_ID — trace the line back to its originating subledger transaction.

Common Use Cases and Queries

XLA_AE_LINES is central to subledger-to-GL reconciliation, journal line reporting, and drill-back from GL to source transactions. Analysts commonly join it to the header table XLA_AE_HEADERS on AE_HEADER_ID to reconstruct full journal entries, and filter by GL_TRANSFER_MODE_CODE to isolate lines pending or completed for transfer. A typical reconciliation query sums accounted debits and credits by ledger and accounting date:

• SELECT AE_HEADER_ID, SUM(ACCOUNTED_DR), SUM(ACCOUNTED_CR) FROM XLA_AE_LINES GROUP BY AE_HEADER_ID.
• Join to XLA_AE_HEADERS to retrieve journal entry names, statuses, and source identifiers.
• Filter on ACCOUNTING_CLASS_CODE or ACCOUNTING_DATE for period-end analysis.
• Use SOURCE_TABLE and SOURCE_ID to drill back to the originating subledger document.

Related Objects

The most significant related objects, based on the documented foreign key and primary key relationships, include:

• XLA_AE_HEADERS — parent header table; joins on AE_HEADER_ID.
• XLA_UPG_BATCHES — referenced by UPG_BATCH_ID during upgrade processing.
• GL_ENCUMBRANCE_TYPES — referenced by ENCUMBRANCE_TYPE_ID.
• GL_CODE_COMBINATIONS — supplies account details for CODE_COMBINATION_ID.
• GL_JE_LINES — the General Ledger destination of transferred subledger lines; linked via GL_SL_LINK_ID.
• XLA_DISTRIBUTION_LINKS — connects accounting lines to their originating distributions.
• XLA_EVENTS — the accounting events underlying the generated lines.