Search Results ce_statement_headers_uk1

Overview

The CE_STATEMENT_HEADERS_ALL table is a core data repository within the Oracle E-Business Suite Cash Management (CE) module for versions 12.1.1 and 12.2.2. It serves as the primary table for storing header-level information for imported bank statements. This object is fundamental to the bank statement reconciliation process, acting as the parent container for individual statement lines. Each record represents a single, complete bank statement file or manual entry, providing the contextual metadata necessary for processing and matching transactions against the organization's internal cash records. Its multi-org structure, indicated by the `_ALL` suffix, allows it to store data for multiple operating units.

Key Information Stored

The table's structure is designed to capture essential bank statement metadata. The primary identifier is the system-generated `STATEMENT_HEADER_ID`. Critical business columns include `BANK_ACCOUNT_ID`, which links to the specific bank account in AP_BANK_ACCOUNTS_ALL, and the `STATEMENT_NUMBER`, a unique identifier often provided by the bank. Together, these two columns form a unique key (CE_STATEMENT_HEADERS_UK1). Other significant columns are `CURRENCY_CODE`, linking to FND_CURRENCIES, which defines the statement's transaction currency, and `DOC_SEQUENCE_ID`, linking to FND_DOCUMENT_SEQUENCES, which manages internal document numbering. Additional typical attributes would include statement date, opening balance, closing balance, and creation information.

Common Use Cases and Queries

The primary use case is the querying and reporting of bank statement history for audit, reconciliation, and cash positioning analysis. A common operational query involves fetching statement headers for a specific bank account to review unreconciled activity. For example:

• SELECT statement_number, statement_date, opening_balance, closing_balance FROM ce_statement_headers_all WHERE bank_account_id = :p_bank_acct_id ORDER BY statement_date DESC;

Another critical scenario is identifying statements that have been imported but not yet fully reconciled, often by joining with the CE_STATEMENT_LINES table to aggregate the reconciliation status of child lines. Technical interfaces and data migrations also interact with this table when loading historical statement data or integrating with third-party treasury systems.

Related Objects

CE_STATEMENT_HEADERS_ALL maintains defined relationships with several key EBS objects, as documented in its foreign key constraints. It is the central hub in the statement reconciliation hierarchy.

• AP_BANK_ACCOUNTS_ALL: Linked via `BANK_ACCOUNT_ID`. This joins the statement to its specific bank account definition.
• FND_CURRENCIES: Linked via `CURRENCY_CODE`. This validates the statement's currency.
• FND_DOCUMENT_SEQUENCES: Linked via `DOC_SEQUENCE_ID`. This manages document numbering for the statement.
• CE_STATEMENT_LINES: Child table linked via `STATEMENT_HEADER_ID`. This is a critical one-to-many relationship where each header contains multiple transaction lines.