Search Results ce_arch_reconciliations_all




Overview
Explore in AI Chat

Overview

The CE_ARCH_RECONCILIATIONS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to serve as a historical archive for reconciliation records. It stores archived data from the CE_STATEMENT_RECONCILS_ALL table, which holds active reconciliation details between bank statement lines and internal transactions (such as payments, receipts, or journal entries). This archiving mechanism is critical for maintaining a complete audit trail and for performance management, allowing the system to preserve historical reconciliation data while keeping operational tables optimized for current processing.

Key Information Stored

The table's structure is defined by its composite primary key and its relationship to archived statement lines. The primary key consists of STATEMENT_LINE_ID, REFERENCE_TYPE, REFERENCE_ID, and CURRENT_RECORD_FLAG, ensuring a unique identifier for each archived reconciliation link. Important columns include STATEMENT_LINE_ID, which links to the archived bank statement line (CE_ARCH_LINES), and JE_HEADER_ID, which references the General Ledger journal entry header (GL_JE_HEADERS) if the reconciliation was against a journal. The REFERENCE_TYPE and REFERENCE_ID columns identify the type and specific identifier of the internal transaction (e.g., a payment, receipt, or journal batch) that was reconciled. The CURRENT_RECORD_FLAG is a critical indicator for managing the archival lifecycle of reconciliation records.

Common Use Cases and Queries

The primary use case is historical reporting and audit analysis of bank reconciliations performed in past periods. Financial auditors frequently query this table to verify the completeness and accuracy of the bank reconciliation process. A common SQL pattern involves joining to CE_ARCH_LINES to retrieve statement details and to GL_JE_HEADERS for journal information. For example, to find all archived reconciliations for a specific bank account and period, a query would filter on the statement header ID from CE_ARCH_LINES and the reconciliation date. Another critical use case is troubleshooting reconciliation discrepancies, where analysts compare archived records against current GL balances to identify timing differences or errors posted in closed periods.

Related Objects

  • CE_ARCH_LINES: This table holds the archived bank statement lines. The foreign key relationship is CE_ARCH_RECONCILIATIONS_ALL.STATEMENT_LINE_ID = CE_ARCH_LINES.STATEMENT_LINE_ID. This is the foundational link for retrieving the context of the archived statement line.
  • GL_JE_HEADERS: This General Ledger table stores journal entry header information. The foreign key relationship is CE_ARCH_RECONCILIATIONS_ALL.JE_HEADER_ID = GL_JE_HEADERS.JE_HEADER_ID. This link is populated when a reconciliation is made against a manual journal entry.
  • CE_STATEMENT_RECONCILS_ALL: As indicated in the documentation, this is the source table from which records are archived. While not listed as a formal foreign key in the provided metadata, it is the direct progenitor of the archived data.