Results for “ce_intra_stmt_headers”

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

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:

• STATEMENT_HEADER_ID — the surrogate primary key uniquely identifying each statement header. It is the first column of unique index CE_INTRA_STMT_HEADERS_U1 (with ORG_ID).
• BANK_ACCOUNT_ID — the bank account to which the statement belongs; a business-key candidate via U2 (with STATEMENT_NUMBER and ORG_ID).
• STATEMENT_NUMBER — the institution-assigned statement identifier.
• STATEMENT_DATE and GL_DATE — the statement date and the accounting date used for GL posting.
• CONTROL_BEGIN_BALANCE, CONTROL_END_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR — control totals used to validate imported statement lines against the bank's reported figures.
• CONTROL_DR_LINE_COUNT, CONTROL_CR_LINE_COUNT — expected counts of debit and credit lines for reconciliation validation.
• CURRENCY_CODE — the statement currency.
• AUTO_LOADED_FLAG and STATEMENT_COMPLETE_FLAG — processing status indicators distinguishing auto-loaded versus manually entered statements and complete versus open statements.
• DOC_SEQUENCE_ID and DOC_SEQUENCE_VALUE — audit/document sequencing for the statement, with DOC_SEQUENCE_ID referencing FND_DOCUMENT_SEQUENCES.
• ORG_ID — the operating unit, critical for multi-org security and partition pruning.
• CASHFLOW_BALANCE, INT_CALC_BALANCE, ONE_DAY_FLOAT, TWO_DAY_FLOAT — calculated balances and float amounts used in cash positioning.
• CHECK_DIGITS — validation digits for the bank account.

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.