Search Results table - ce.ce_statement_headers




The CE.CE_STATEMENT_HEADERS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Cash Management module, serving as the primary repository for bank statement header information. This table stores metadata and control attributes for bank statements that are imported, manually entered, or automatically generated within the system. It acts as a parent table to CE_STATEMENT_LINES, which contains the detailed transaction records associated with each statement.

Key Attributes and Structure

The CE_STATEMENT_HEADERS table includes the following key columns:
  • STATEMENT_HEADER_ID: Primary key identifier for each statement.
  • BANK_ACCOUNT_ID: References CE_BANK_ACCOUNTS to link statements to specific bank accounts.
  • STATEMENT_NUMBER: Unique identifier assigned to the bank statement.
  • STATEMENT_DATE: The date of the bank statement.
  • GL_DATE: General Ledger date associated with the statement for accounting purposes.
  • CURRENCY_CODE: Currency of the bank account (references FND_CURRENCIES).
  • STATEMENT_BALANCE: Closing balance as per the bank statement.
  • STATUS (e.g., 'NEW', 'RECONCILED', 'EXPORTED'): Tracks the reconciliation lifecycle.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Functional Role in Cash Management

This table supports:
  1. Bank Statement Import: When statements are imported via APIs or the Bank Statement Open Interface (CE_STATEMENTS_INT), header data is inserted into this table.
  2. Reconciliation: The STATUS column drives reconciliation workflows, ensuring only valid statements are processed.
  3. Reporting: Serves as the foundation for cash position and bank reconciliation reports.
  4. Integration: Links to subledger accounting (XLA) and General Ledger (GL) for posting.

Technical Considerations

  • Indexes: Key indexes include CE_STATEMENT_HEADERS_N1 (on BANK_ACCOUNT_ID) and CE_STATEMENT_HEADERS_U1 (unique on STATEMENT_HEADER_ID).
  • Foreign Keys: Enforces referential integrity with CE_BANK_ACCOUNTS, FND_CURRENCIES, and GL_PERIODS.
  • API Dependencies: The CE_STATEMENTS_PKG PL/SQL package manages DML operations.

Version-Specific Notes

In Oracle EBS 12.2.2, enhancements to the Cash Management module may introduce additional columns or constraints, but the core structure remains consistent with 12.1.1. The table is part of the CE schema, which is installed during the Financials suite provisioning.

Common Customizations

Extensions often include:
  • Custom status values to support additional reconciliation workflows.
  • Triggers to enforce business rules during statement approval.
  • Views joining with CE_STATEMENT_LINES for analytical reporting.
This table is fundamental to Oracle Cash Management's ability to automate bank reconciliation and provide accurate cash visibility, reducing manual effort and improving financial controls.