Search Results ax_sle_lines_n1

Overview

AX.AX_SLE_LINES is the core subledger accounting entry lines table within the Oracle E-Business Suite Subledger Accounting (SLA) architecture, owned by the AX schema and registered as FND Design Data object AX.AX_SLE_LINES. It stores individual accounting entry lines, where each row represents a single debit or credit within an accounting entry. Lines are grouped under a parent accounting entry header, and together the header and its lines form a complete accounting entry. All lines grouped under a given header are balanced in the functional currency, meaning total debits equal total credits. The table is physically stored in the APPS_TS_TX_DATA tablespace with PCT Free of 10, and in ETRM 12.2.2 the documented physical schema contains 127 columns.

From a data modeling perspective, the metadata supports a heuristic Data Vault classification of link. This is consistent with the table's role: it associates accounting headers, code combinations, third parties, and source transactions while carrying descriptive and monetary attributes. It should be treated as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The physical primary key AX_SLE_LINES_PK is composed of JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, and SLE_LINE_NUM. Separately, the unique index AX_SLE_LINES_U1 — the index referenced in the user's search for "ax_sle_lines_u1" — is defined on SET_OF_BOOKS_ID, JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, and SLE_LINE_NUM, and represents the strongest business-key candidate documented for this table.

• JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, SLE_LINE_NUM — the composite identifying key linking each line to its parent header and ordering it within the entry.
• SET_OF_BOOKS_ID — identifies the ledger (set of books) to which the entry belongs; part of the unique index AX_SLE_LINES_U1.
• CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, identifying the accounting flexfield combination for the line.
• ACCOUNTED_DR / ACCOUNTED_CR — debit and credit amounts in the ledger's functional currency, the basis for balancing.
• ENTERED_DR / ENTERED_CR — debit and credit amounts in the entered (transaction) currency.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency and conversion attributes applied when the entered currency differs from the functional currency.
• BALANCE_FLAG — set to 'Y' when the row has contributed to a balance; otherwise NULL or N. Only lines whose account code combination carries the control account qualifier may be flagged 'Y'.
• GL_POSTED_FLAG, GL_POSTED_DATE — indicate whether the line has been transferred and posted to General Ledger.
• GL_TRANSFER_LINE_NUM, GL_SL_LINK_ID — reconcile SLA lines to their corresponding GL journal lines.
• THIRD_PARTY_ID / SUB_ID — identify the party (supplier, customer, or other) and sub-entity associated with the line.
• SOURCE_TABLE, SOURCE_ID — point back to the originating subledger transaction.
• LINE_TYPE — identifies the nature of the line, supporting tax and applied-document processing (TAX_CODE_ID, APPLIED_FROM_DOC_ID, APPLIED_TO_DOC_ID).

Common Use Cases and Queries

Typical uses include subledger-to-GL reconciliation, unposted journal analysis, balance contribution reporting, and tax line extraction.

• Retrieving all lines for a header: SELECT * FROM AX.AX_SLE_LINES WHERE SLE_HEADER_ID = :p_header AND JOURNAL_SEQUENCE_ID = :p_seq ORDER BY SLE_LINE_NUM;
• Verifying balance for a header: compare SUM(ACCOUNTED_DR) against SUM(ACCOUNTED_CR) grouped by SLE_HEADER_ID.
• Identifying unposted lines: filter on GL_POSTED_FLAG = 'N' using index AX_SLE_LINES_N3 (JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, GL_POSTED_FLAG).
• Balance reporting: filter on BALANCE_FLAG = 'Y' with index AX_SLE_LINES_N1.
• Account-level analysis: join to GL_CODE_COMBINATIONS via CODE_COMBINATION_ID, supported by index AX_SLE_LINES_N5.

Related Objects

• AX.AX_SLE_HEADERS — parent table joined on JOURNAL_SEQUENCE_ID and SLE_HEADER_ID; defines the accounting entry header.
• GL.GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID to derive account segment values.
• GL.GL_JE_LINES / GL_JE_HEADERS — target of GL transfer; reconciled via GL_SL_LINK_ID and GL_TRANSFER_LINE_NUM.
• XLA_* views and APIs — Subledger Accounting programmatic interfaces that populate and query SLA lines.
• AX.AX_SLE_LINES indexes (AX_SLE_LINES_U1 through N8) — performance-critical access paths for balance, posting, party, and source-based queries.