Results for “ce_statement_headers_all”

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

Overview

CE_STATEMENT_HEADERS_ALL is the foundational table within the Oracle E-Business Suite Cash Management (CE) module that stores bank statement header information. It represents the top-level record for each bank statement loaded into or reconciled within EBS, serving as the parent entity for individual statement lines held in CE_STATEMENT_LINES. In Oracle EBS 12.1.1 and 12.2.2, this table is central to the bank reconciliation process, cash positioning, and cash forecasting workflows that the Cash Management module supports.

Each row in CE_STATEMENT_HEADERS_ALL corresponds to a single statement issued by a bank for a specific bank account over a defined statement period. The table captures the statement-level attributes—including the account to which it belongs, the statement number assigned by the bank, and the currency in which it is denominated—while the transactional detail resides in the child lines table. The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning, which suggests that this object is best modeled as a descriptive satellite attached to a bank account hub rather than as an independent hub or a pure link table. In practice, this reflects the table's dependency on AP_BANK_ACCOUNTS_ALL as the principal business parent.

Notably, the ETRM metadata records the implementation status as "Not implemented in this database," indicating that the excerpt describes the object definition rather than a live installation. The table is nonetheless a standard, shipped component of the Cash Management data model.

Key Information Stored

The table's documented structure centers on the following significant columns:

• STATEMENT_HEADER_ID — The surrogate primary key, enforced by the CE_STATEMENT_HEADERS_PK constraint. This system-generated identifier uniquely distinguishes each statement header and is the column referenced by child records.
• BANK_ACCOUNT_ID — Foreign key to AP_BANK_ACCOUNTS_ALL, identifying the internal bank account against which the statement was received. Together with STATEMENT_NUMBER, this column forms the unique business key CE_STATEMENT_HEADERS_UK1, ensuring that no two statements share the same number for a given account.
• STATEMENT_NUMBER — The statement identifier supplied by the bank. As part of the unique index, it is a principal business-key candidate and the primary means by which users and interfaces locate a specific statement.
• CURRENCY_CODE — Foreign key to FND_CURRENCIES, defining the currency in which the statement amounts are expressed. This governs currency validation and reconciliation matching.
• DOC_SEQUENCE_ID — Foreign key to FND_DOCUMENT_SEQUENCES, linking the statement to an Oracle document sequence for audit and numbering purposes.

The distinction between the surrogate key and the natural business key is important for integration: external loads should resolve BANK_ACCOUNT_ID and STATEMENT_NUMBER to detect duplicates, while internal joins should use STATEMENT_HEADER_ID for performance.

Common Use Cases and Queries

Typical usage includes loading bank statement data through the Bank Statement Open Interface (which populates this table and its lines), querying statements for reconciliation, and extracting statement-level balances for cash reporting. A representative query retrieving headers for a specific account might read:

• SELECT h.STATEMENT_HEADER_ID, h.STATEMENT_NUMBER, h.CURRENCY_CODE FROM CE_STATEMENT_HEADERS_ALL h WHERE h.BANK_ACCOUNT_ID = :bank_account_id ORDER BY h.STATEMENT_NUMBER;
• Joining to AP_BANK_ACCOUNTS_ALL to resolve the bank account name and number for a reconciliation report.
• Joining to CE_STATEMENT_LINES on STATEMENT_HEADER_ID to aggregate statement activity per header.
• Joining to FND_CURRENCIES to obtain currency descriptions for multi-currency statement reporting.

Related Objects

• CE_STATEMENT_LINES — The primary child table, joined via CE_STATEMENT_LINES.STATEMENT_HEADER_ID = CE_STATEMENT_HEADERS_ALL.STATEMENT_HEADER_ID. It holds the individual statement line transactions.
• AP_BANK_ACCOUNTS_ALL — Parent reference for BANK_ACCOUNT_ID; supplies bank account attributes.
• FND_CURRENCIES — Reference for CURRENCY_CODE, providing currency validation and descriptions.
• FND_DOCUMENT_SEQUENCES — Reference for DOC_SEQUENCE_ID, supporting document numbering and audit.