Search Results ax_sle_lines_arch_pk

Overview

AX_SLE_LINES_ARCH is the archival counterpart of AX_SLE_LINES within the AX - Global Accounting Engine (Global Accounting Engine / Subledger Accounting bridge) of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores accounting distribution rows that have been purged from the live AX_SLE_LINES table. Each row represents a single accounting line — debit, credit, or statistical — generated by the accounting engine for a source subledger transaction, retained here for audit, reconciliation, and historical reporting after the operational data has been removed.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. This is a modeling suggestion: the table behaves as a descriptive satellite hanging off a header key rather than as an independent hub or a pure associative link. Its grain is defined by the combination of journal sequence, header, and line number, so it answers "what were the distribution lines for this accounting entry" once the header identity is established.

Key Information Stored

The primary key AX_SLE_LINES_ARCH_PK is a composite surrogate composed of JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, and SLE_LINE_NUM. A separate unique index, AX_SLE_LINES_ARCH_U1, provides the business-key candidate: SET_OF_BOOKS_ID, JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, SLE_LINE_NUM. This confirms that accounting identity is scoped by ledger.

• JOURNAL_SEQUENCE_ID, SLE_HEADER_ID, SLE_LINE_NUM — the composite identity and grain of the accounting line.
• SET_OF_BOOKS_ID — the ledger (set of books) context, part of the unique business key.
• CODE_COMBINATION_ID — the accounting flexfield combination to which the line posts in GL.
• ACCOUNTED_DR / ACCOUNTED_CR — ledger-currency debit and credit amounts.
• ENTERED_DR / ENTERED_CR — transaction-currency debit and credit amounts.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — the currency and conversion attributes applied to the line.
• GL_POSTED_FLAG / GL_POSTED_DATE — whether and when the line was transferred and posted to General Ledger.
• GL_SL_LINK_ID, GL_TRANSFER_LINE_NUM — the linkage into the GL interface / subledger transfer process.
• SOURCE_ID, SOURCE_TABLE — the originating subledger document and its source table.
• APPLIED_FROM_DOC_ENTITY / APPLIED_FROM_DOC_ID and APPLIED_TO_DOC_ENTITY / APPLIED_TO_DOC_ID — the applied-to / applied-from document chain used in receipt and payment applications.
• THIRD_PARTY_ID, ORG_ID, APPLICATION_ID — party, operating unit, and application context.
• TAX_CODE_ID, TAX_LINK_ID, TAXABLE_ENTERED_DR, TAXABLE_ENTERED_CR, TAXABLE_ACCOUNTED_DR, TAXABLE_ACCOUNTED_CR — tax determination and taxable base amounts.
• LINE_TYPE, BALANCE_FLAG — classification of the line (for example actual versus budget) and its balancing role.
• REFERENCE_1 through REFERENCE_60, REFERENCE_NUM1-10, REFERENCE_DATE1-10 — the flexible descriptive reference block used to carry source context.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID — the standard WHO audit and concurrent program columns.

Common Use Cases and Queries

Because the table is archival, the most common queries start from a known header or journal identity and retrieve all associated lines, or aggregate amounts for historical audit and reconciliation. A typical pattern filters by header and ledger:

SELECT sle_line_num, code_combination_id, accounted_dr, accounted_cre FROM ax.ax_sle_lines_arch WHERE sle_header_id = :p_header_id AND set_of_books_id = :p_sob_id ORDER BY sle_line_num;

Other recurring scenarios include reconciling purged subledger distributions against GL balances; auditing tax lines via TAX_LINK_ID and TAX_CODE_ID; tracing applied transactions through APPLIED_FROM_DOC_ID / APPLIED_TO_DOC_ID; and reconstructing which lines were posted by checking GL_POSTED_FLAG and GL_POSTED_DATE. Reporting on SOURCE_TABLE and SOURCE_ID supports lineage analysis back to the originating subledger. Because the table can hold many rows per header, queries should always be filtered by SLE_HEADER_ID or JOURNAL_SEQUENCE_ID to use the PK efficiently.

Related Objects

• AX_SLE_HEADERS_ARCH — parent header archive; joined on JOURNAL_SEQUENCE_ID and SLE_HEADER_ID, matching the documented foreign key from AX_SLE_LINES_ARCH.JOURNAL_SEQUENCE_ID to AX_SLE_HEADERS_ARCH.
• AX_SLE_LINES — the live source table from which these rows are purged and archived.
• AX_SLE_HEADERS — the live header table that pairs with the current lines.
• GL_JE_LINES / GL_JE_HEADERS — General Ledger journal lines and batches produced from posted AX accounting, linked via GL_SL_LINK_ID and GL_TRANSFER_LINE_NUM.
• GL_CODE_COMBINATIONS — resolves CODE_COMBINATION_ID to accounting flexfield segments.
• GL_IMPORT_REFERENCES — correlates transferred subledger lines with GL journal entries.
• FND_CONCURRENT_PROGRAMS / FND_CONCURRENT_REQUESTS — resolves PROGRAM_ID, PROGRAM_APPLICATION_ID, and REQUEST_ID for the purge process that moved rows into this archive.