Search Results ce_intra_stmt_headers




Overview
Explore in AI Chat

Overview

CE_INTRA_STMT_HEADERS is the header-level table in the Oracle Cash Management (CE) module that stores bank statement information received from financial institutions for intra-day or standard statement processing. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the anchor for statement reconciliation, cash positioning, and bank account balancing workflows. Each row represents a single bank statement for a specific bank account, capturing control totals, balances, and reconciliation status that drive the Cash Management reconciliation and Bank Statement Import processes.

The ETRM metadata classifies this object heuristically as a Data Vault standalone structure. From a modeling perspective, this suggests the table functions primarily as a hub-like entity (identified by STATEMENT_HEADER_ID and BANK_ACCOUNT_ID) with embedded descriptive attributes, rather than participating in a densely linked satellite network. The only documented foreign key reference is to FND_DOCUMENT_SEQUENCES via DOC_SEQUENCE_ID, reinforcing its independent transactional nature within the CE schema.

Key Information Stored

The table contains 43 documented columns. The most significant include:

The ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns allow extensibility for client-specific data.

Common Use Cases and Queries

Typical scenarios include identifying unreconciled statements, validating control totals, and generating cash position reports. A common query retrieves statements for a bank account:

  • SELECT statement_header_id, statement_number, statement_date, control_end_balance FROM ce_intra_stmt_headers WHERE bank_account_id = :p_bank_account_id AND org_id = :p_org_id ORDER BY statement_date DESC;
  • Detecting incomplete statements: WHERE statement_complete_flag = 'N'
  • Reviewing auto-loaded batches: WHERE auto_loaded_flag = 'Y' AND gl_date BETWEEN :start_date AND :end_date

Because the table carries control totals, reconciliation reports compare CONTROL_TOTAL_DR/CR against aggregated line totals in CE_INTRA_STMT_LINES. Float analysis queries leverage ONE_DAY_FLOAT and TWO_DAY_FLOAT for treasury reporting.

Related Objects

The most significant related objects include:

  • CE_INTRA_STMT_LINES — the line-level detail table joined on STATEMENT_HEADER_ID, holding individual statement transactions.
  • CE_BANK_ACCOUNTS — joined on BANK_ACCOUNT_ID for account metadata.
  • FND_DOCUMENT_SEQUENCES — referenced via DOC_SEQUENCE_ID for document numbering.
  • CE_BANK_ACCT_USES_ALL and CE_BANK_BRANCHES_V — for account and branch context in reporting.
  • CE_STATEMENT_RECONCILES and CE_RECONCILED_TRANSACTIONS — linking reconciled statement lines to cash management transactions.
  • XX intrastatement interfaces such as CE_INTRA_STMT_HEADERS_INT (during import) feed this table through the Bank Statement Import concurrent program.

Together these objects support the complete bank statement reconciliation lifecycle within Cash Management.