Search Results ce_archive_headers_uk1

Overview

The CE_ARCH_HEADERS_ALL table is a core data repository within the Oracle E-Business Suite Cash Management (CE) module. It functions as the archival store for bank statement header records that have been purged from the primary transaction table, CE_STATEMENT_HEADERS_ALL. This archiving mechanism is critical for maintaining database performance by managing the growth of active transaction tables, while preserving a complete, auditable history of all bank statements that have been loaded and reconciled within the system. Its role is to ensure historical financial data integrity and compliance, even after operational data has been moved from the primary processing tables.

Key Information Stored

As an archive table, CE_ARCH_HEADERS_ALL mirrors the structure of its source table, storing essential metadata for each bank statement. The primary identifier is the STATEMENT_HEADER_ID, which is the unique key for the archived record. Critical business columns include BANK_ACCOUNT_ID, which links to the specific bank account in AP_BANK_ACCOUNTS_ALL, and the STATEMENT_NUMBER, which together form a unique constraint (CE_ARCHIVE_HEADERS_UK1) for a given account. The table also stores the CURRENCY_CODE for the statement and a DOC_SEQUENCE_ID reference if document sequencing was applied, linking to FND_DOCUMENT_SEQUENCES. Other typical columns would include statement dates, opening and closing balances, and creation information, forming a complete snapshot of the original statement header.

Common Use Cases and Queries

The primary use case for this table is historical reporting and audit inquiries on bank statements that are no longer in the active CE_STATEMENT_HEADERS_ALL table. This is essential for long-term financial analysis, dispute resolution, and period-end audits spanning multiple years. A common query pattern involves joining to the archived lines table (CE_ARCH_LINES) and bank account details to reconstruct a full historical statement. For example:

• SELECT arch_h.statement_number, arch_h.statement_date, arch_l.trx_code, arch_l.amount FROM ce_arch_headers_all arch_h JOIN ce_arch_lines arch_l ON arch_h.statement_header_id = arch_l.statement_header_id WHERE arch_h.bank_account_id = :p_bank_acct_id AND arch_h.statement_date BETWEEN :p_date_from AND :p_date_to;

Another critical use is verifying the uniqueness of statement numbers per bank account across the entire application history, leveraging the unique key constraint.

Related Objects

CE_ARCH_HEADERS_ALL is centrally connected within the Cash Management data model. Its documented relationships, as per the provided ETRM metadata, are as follows:

• Referenced Foreign Keys: This table references three key master tables:
  • CE_ARCH_HEADERS_ALL.BANK_ACCOUNT_ID → AP_BANK_ACCOUNTS_ALL
  • CE_ARCH_HEADERS_ALL.CURRENCY_CODE → FND_CURRENCIES
  • CE_ARCH_HEADERS_ALL.DOC_SEQUENCE_ID → FND_DOCUMENT_SEQUENCES
• Referencing Foreign Key: It is the parent table for archived statement lines:
  • CE_ARCH_LINES.STATEMENT_HEADER_ID → CE_ARCH_HEADERS_ALL
• Source Table: Its data is directly sourced from the active transaction table CE_STATEMENT_HEADERS_ALL during archival processes.