Search Results ax_sle_headers_arch_pk

Overview

AX_SLE_HEADERS_ARCH is an archival table in the AX (Global Accounting Engine) schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores header-level Subledger Accounting (SLE) accounting entries that have been purged from the operational AX_SLE_HEADERS table. Each row represents a single accounting event header — the parent record that groups the debit and credit distribution lines created by the Global Accounting Engine for a source transaction. Archival preserves the audit trail of transferred and posted accounting while keeping the live table at a manageable size.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. The composite primary key (JOURNAL_SEQUENCE_ID, SLE_HEADER_ID) plus a foreign key to AX_EVENTS and extensive descriptive and audit attributes make AX_SLE_HEADERS_ARCH behave like a satellite attached to an event hub, rather than a pure hub or link. This is a modeling suggestion only; the physical design follows standard EBS denormalized conventions.

Key Information Stored

The physical schema documents 47 columns. The most significant are:

• JOURNAL_SEQUENCE_ID and SLE_HEADER_ID — the composite surrogate primary key (AX_SLE_HEADERS_ARCH_PK) identifying each archived accounting header.
• EVENT_ID — foreign key to AX_EVENTS, linking the header to its originating accounting event.
• SET_OF_BOOKS_ID, APPLICATION_ID, ORG_ID — ledger and application/operating unit context. SET_OF_BOOKS_ID participates in the unique business key AX_SLE_HEADERS_ARCH_U1 (SET_OF_BOOKS_ID, JOURNAL_SEQUENCE_ID, SLE_HEADER_ID).
• EFFECTIVE_DATE, TRANSACTION_DATE, PERIOD_NAME — accounting date, source transaction date, and the GL period affected.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE — currency and conversion details for foreign-currency entries.
• DOC_SEQUENCE_ID, DOC_SEQUENCE_NUMBER — document sequencing (FK to FND_DOCUMENT_SEQUENCES) for statutory numbering.
• LEGAL_SEQUENCE_ID, LEGAL_SEQUENCE_VALUE, ACCOUNTING_SEQUENCE_ID — sequence identifiers used for legal and accounting numbering.
• GL_TRANSFER_FLAG, GL_TRANSFER_DATE, GL_TRANSFER_RUN_ID, GL_CATEGORY — status and audit of the transfer of these entries to the General Ledger.
• REFERENCE_1..5, REFERENCE_NUM1..5, REFERENCE_DATE1..5, DESCRIPTION — flexibly populated reference attributes carried from the source transaction.

Standard WHO/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID) are also present, allowing the concurrent program that performed the purge to be identified.

Common Use Cases and Queries

This table is primarily used for audit and reconciliation after live accounting data has been purged. Typical scenarios include reconstructing historical subledger entries, verifying GL transfers that predate the live table, and legal or tax reporting that requires retention of accounting detail.

A representative query joining headers to their archived lines:

• SELECT h.journal_sequence_id, h.sle_header_id, h.period_name, h.gl_transfer_flag, l.* FROM ax.ax_sle_headers_arch h, ax.ax_sle_lines_arch l WHERE h.journal_sequence_id = l.journal_sequence_id AND h.sle_header_id = l.sle_header_id;

To locate an archived header from its accounting event: join on EVENT_ID to AX_EVENTS. To analyze transfer status by period: aggregate on PERIOD_NAME and GL_TRANSFER_FLAG. Reporting on document sequencing can join DOC_SEQUENCE_ID to FND_DOCUMENT_SEQUENCES.

Related Objects

• AX_SLE_HEADERS — the operational source table from which rows are purged into this archive.
• AX_SLE_LINES_ARCH — child table; references AX_SLE_HEADERS_ARCH via JOURNAL_SEQUENCE_ID and SLE_HEADER_ID (AX_SLE_LINES_ARCH.JOURNAL_SEQUENCE_ID → AX_SLE_HEADERS_ARCH).
• AX_EVENTS — parent event table; AX_SLE_HEADERS_ARCH.EVENT_ID → AX_EVENTS.
• FND_DOCUMENT_SEQUENCES — referenced through DOC_SEQUENCE_ID.
• AX_SLE_LINES — the live line table corresponding to archived lines.
• GL_JE_HEADERS / GL_JE_LINES — General Ledger entries ultimately created from these subledger records.

Access to this object should be treated as read-only audit data; the AX schema is owned by the Global Accounting Engine and is not intended for direct DML.