Search Results ce_archive_headers_inf_pk




Overview
Explore in AI Chat

Overview

CE_ARCH_INTERFACE_HEADERS_ALL is an archival table within the Oracle E-Business Suite Cash Management (CE) module. It stores archived copies of records originally held in CE_STATEMENT_HEADERS_INT_ALL, the bank statement interface header table that stages incoming bank statement data prior to validation, reconciliation, and posting. When statement interface records are purged from the active interface tables to control table growth and preserve performance, the header portion of those records is retained in CE_ARCH_INTERFACE_HEADERS_ALL for audit, historical traceability, and reference purposes.

The table is not implemented in every database; its presence depends on whether statement interface archiving has been configured and executed. Environments that never run the Cash Management statement interface archive and purge concurrent program will not contain this object. From a Data Vault modeling perspective, the heuristic classification is satellite-leaning. The table describes archived attributes of a bank statement header keyed by statement and bank account identifiers, which is characteristic of satellite behavior rather than an independent hub or an associative link. This classification is a modeling suggestion only; it reflects the foreign key topology documented for the object and not a formal Data Vault implementation.

Key Information Stored

The documented structure centers on the primary key constraint CE_ARCHIVE_HEADERS_INF_PK, which is composed of two columns:

  • STATEMENT_NUMBER — the bank statement number identifying the statement to which the archived header belongs; part of the composite primary key.
  • BANK_ACCOUNT_NUM — the bank account number associated with the statement; the second component of the composite primary key.

Together these two columns form the business key by which the statement header is uniquely identified. The primary key is a composite business key rather than a generated surrogate identifier; there is no documented single-column surrogate key. The table also carries a currency reference:

Additional descriptive attributes of the archived statement header are inherited from the CE_STATEMENT_HEADERS_INT_ALL structure at the time the archive was taken, but only the columns listed above are documented in the available metadata. Any query against this table should therefore rely on the documented key columns and the currency code as the reliable, documented access paths.

Common Use Cases and Queries

The primary use case is historical research: determining whether a bank statement was ever loaded into the Cash Management interface and, if so, when it was archived. A typical pattern joins the archived header to its archived lines to reconstruct the full statement:

  • Locating an archived statement by number and bank account: SELECT * FROM ce_arch_interface_headers_all WHERE statement_number = :stmt AND bank_account_num = :acct;
  • Reconstructing the header-and-line picture: SELECT h.statement_number, h.bank_account_num, h.currency_code, l.* FROM ce_arch_interface_headers_all h, ce_arch_interface_lines l WHERE h.statement_number = l.statement_number AND h.bank_account_num = l.bank_account_num;
  • Auditing archive volume by currency: SELECT currency_code, COUNT(*) FROM ce_arch_interface_headers_all GROUP BY currency_code;

Reporting use cases include reconciliation audits, currency exposure summaries across archived statements, and investigations into statements that failed to post and were subsequently purged from the live interface. Because the table holds archived rather than active data, it should not be used for operational reconciliation workflows.

Related Objects

The most significant related objects, drawn from the documented foreign key relationships, are:

  • CE_ARCH_INTERFACE_LINES — the archived statement line table, related through STATEMENT_NUMBER and BANK_ACCOUNT_NUM. It carries the detail rows belonging to each archived header and references this table through the same composite key.
  • FND_CURRENCIES — the Oracle Application Object Library currency definition table, referenced by CURRENCY_CODE. It supplies currency names, precision, and enabled status for reporting and validation.
  • CE_STATEMENT_HEADERS_INT_ALL — the live statement interface header table from which these records are archived. It is the source object for the archive process and the natural comparison point when distinguishing active from archived statements.
  • CE_STATEMENT_LINES_INT_ALL — the live statement interface line table corresponding to the archived line records.

The documented relationship topology shows CE_ARCH_INTERFACE_HEADERS_ALL as the parent in the archive pair, with CE_ARCH_INTERFACE_LINES acting as the dependent child and FND_CURRENCIES acting as the referenced lookup. This two-key parent plus lookup pattern is consistent with the satellite-leaning classification noted in the overview.