Search Results ce_statement_headers

Overview

The CE_STATEMENT_HEADERS view is a critical data object within Oracle E-Business Suite Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary interface for accessing consolidated bank statement header information. This view is built upon the underlying table CE_STATEMENT_HEADERS_ALL, applying a security filter based on the operating unit (ORG_ID) derived from the user's session context. Its core role is to provide a secure, multi-org access layer to the master data for electronic or manually entered bank statements, which form the foundation for the bank reconciliation process.

Key Information Stored

The view exposes a comprehensive set of columns that define a bank statement's metadata and control totals. Essential identifiers include STATEMENT_HEADER_ID, BANK_ACCOUNT_ID, and STATEMENT_NUMBER. Key financial control columns are CONTROL_BEGIN_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR, and CONTROL_END_BALANCE, which are used to validate statement integrity. Operational flags such as STATEMENT_COMPLETE_FLAG and AUTO_LOADED_FLAG indicate the statement's processing status and origin. The view also stores reconciliation-relevant balances like CASHFLOW_BALANCE and INT_CALC_BALANCE, document sequencing details (DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE), and standard Oracle EBS columns for creation, update, and descriptive flexfields (ATTRIBUTE1-15).

Common Use Cases and Queries

This view is central to reporting and integration tasks. A common use case is generating a list of pending statements for reconciliation by filtering on STATEMENT_COMPLETE_FLAG. Analysts frequently query it to verify control totals against detailed statement lines from CE_STATEMENT_LINES. A typical query retrieves statement summaries for a specific bank account:

• SELECT statement_number, statement_date, control_begin_balance, control_end_balance FROM ce_statement_headers WHERE bank_account_id = 1001 AND statement_date > SYSDATE - 30 ORDER BY statement_date DESC;

The view is also integral to custom data extracts for month-end close reporting and auditing, providing the header context for all bank statement transactions within a user's authorized operating units.

Related Objects

The CE_STATEMENT_HEADERS view has a direct and fundamental relationship with several other Cash Management objects. Its base table is CE_STATEMENT_HEADERS_ALL. The detailed transaction lines for each header are stored in and accessed via CE_STATEMENT_LINES. The bank account master information is referenced through the CE_BANK_ACCOUNTS table via the BANK_ACCOUNT_ID column. For reconciliation, the CE_RECONCILIATIONS_ALL table links to statement headers. This view is also a primary source for the standard Oracle Cash Management reconciliation reports and the Bank Statement Details interface.