Results for “current_record_flag”

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

Overview

CE_ARCH_RECONCILIATIONS_ALL is an archive table in the Cash Management (CE) module of Oracle E-Business Suite, owned by the CE schema. It stores archived reconciliation records that were originally held in CE_STATEMENT_RECONCILIATIONS_ALL. Its purpose is to preserve the historical reconciliation linkage between bank statement lines (and their archived counterparts) and the accounting entries generated during the reconciliation process, allowing reconciliation history to survive the archiving and purge operations applied to active statement data.

From a heuristic Data Vault modeling perspective, this table is best classified as a link. It resolves a many-to-many style association between archived statement lines and journal entries — specifically, which GL journal header reconciled against which statement line, and under what reference type. The composite primary key reinforces this classification, since a link is defined by the combination of its referenced business keys rather than by descriptive attributes.

Key Information Stored

Although 20 columns are documented, the following carry the significant business meaning:

• STATEMENT_LINE_ID — Identifier of the associated archived statement line. Also the leading component of the primary key.
• REFERENCE_TYPE — Classifies the nature of the reconciled reference (for example, journal entry versus other reference categories).
• REFERENCE_ID — The identifier of the referenced entity; combined with REFERENCE_TYPE it defines the "other side" of the link.
• JE_HEADER_ID — Foreign key to GL_JE_HEADERS, identifying the journal entry header reconciled to the statement line.
• LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the legal entity context of the reconciliation.
• CURRENT_RECORD_FLAG — Indicates whether the row represents the current effective reconciliation record; a component of the primary key.
• REFERENCE_STATUS and STATUS_FLAG — Status indicators for the reconciliation and the referenced item.
• ACTION_FLAG — Denotes the action applied during reconciliation (for example, created, updated, or reversed).
• AUTO_RECONCILED_FLAG — Distinguishes automatic from manual reconciliation.
• AMOUNT — Reconciled amount associated with the link.
• ORG_ID — Operating unit identifier, supporting multi-org reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context capturing the archival run that produced the row.

The surrogate/business composite key is documented as CE_ARCH_RECONCILIATIONS_PK, defined across STATEMENT_LINE_ID, REFERENCE_TYPE, REFERENCE_ID, and CURRENT_RECORD_FLAG. No separate unique index is documented, so the primary key itself serves as the business-key candidate for identifying a unique reconciliation link.

Common Use Cases and Queries

Typical uses include reconciliation history reporting, audit sampling of historical reconciliations, and reconstructing the journal-to-statement-line relationship after the active data has been archived.

• History for a statement line: SELECT je_header_id, reference_type, reference_id, amount, auto_reconciled_flag FROM ce_arch_reconciliations_all WHERE statement_line_id = :line_id AND current_record_flag = 'Y';
• Journal-centric audit: joining to GL_JE_HEADERS on JE_HEADER_ID to trace which statement lines a journal entry reconciled.
• Legal-entity rollups: grouping by LEGAL_ENTITY_ID and ORG_ID to report reconciliation volumes.
• Archival traceability: filtering on REQUEST_ID or PROGRAM_ID to identify rows produced by a specific archive run.

Most queries should filter CURRENT_RECORD_FLAG = 'Y' to avoid superseded rows, because the primary key deliberately permits multiple records per reference by carrying the current-record indicator.

Related Objects

• CE_ARCH_LINES — Referenced on STATEMENT_LINE_ID; the parent archived statement line.
• GL_JE_HEADERS — Referenced on JE_HEADER_ID; the reconciled journal entry header.
• FV_LEGAL_ENTITIES — Referenced on LEGAL_ENTITY_ID; the legal entity owning the reconciliation.
• CE_STATEMENT_RECONCILS_ALL — The active source table whose rows are archived here.
• CE_ARCH_RECONCILIATIONS_PK / CE_ARCH_RECONCILIATIONS_ALL — The primary-key constraint enforcing row uniqueness.

Together these objects form the archival counterpart to the live Cash Management reconciliation model, preserving referential integrity between archived statement lines, journal entries, and legal entities.