Search Results statement_complete_flag




Overview
Explore in AI Chat

Overview

The CE_ARCH_HEADERS view is a critical data object within the Oracle E-Business Suite Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. It provides a secure, multi-organization (Multi-Org) filtered view of archived bank statement headers. The view selects data from the underlying table CE_ARCH_HEADERS_ALL but applies a security predicate based on the ORG_ID and the user's session client information (USERENV('CLIENT_INFO')). This ensures users can only access archived statement data relevant to their operating unit. The view's primary role is to support the reporting and auditing of historical bank statement reconciliations, serving as the authoritative source for header-level information of statements that have been processed and archived within the system.

Key Information Stored

The view contains columns essential for identifying, tracking, and controlling archived bank statements. Key columns include the unique STATEMENT_HEADER_ID and the associated BANK_ACCOUNT_ID. Statement identification is managed via STATEMENT_NUMBER, STATEMENT_DATE, and CURRENCY_CODE. Control totals for reconciliation are stored in CONTROL_BEGIN_BALANCE, CONTROL_TOTAL_DR, CONTROL_TOTAL_CR, and CONTROL_END_BALANCE. The STATUS_COMPLETE_FLAG column, which was the focus of the user's search, is a critical indicator denoting whether the statement reconciliation process is finalized. Other significant columns include ORG_ID for multi-org security, AUTO_LOADED_FLAG denoting electronic import, GL_DATE for accounting, and a series of fifteen descriptive flexfield columns (ATTRIBUTE1-15). The view also stores cash positioning data such as CASHFLOW_BALANCE and FLOAT amounts.

Common Use Cases and Queries

This view is predominantly used for historical reporting and audit inquiries. A common use case is generating a report of all completed statements for a specific bank account within a date range. The STATUS_COMPLETE_FLAG is frequently used to filter for finalized records. For example, to find incomplete archived statements, one might query: SELECT statement_number, statement_date FROM ce_arch_headers WHERE bank_account_id = :p_bank_acct AND statement_complete_flag = 'N';. Another typical scenario involves reconciling control totals by comparing archived header data with the sum of corresponding lines from CE_ARCH_LINES. Analysts also use the view to track statement sequencing (DOC_SEQUENCE_VALUE) or to audit the auto-load process via the AUTO_LOADED_FLAG. Since it is a view, it is directly suitable for inclusion in custom BI or operational reports.

Related Objects

The CE_ARCH_HEADERS view has direct dependencies and relationships with several other core Cash Management objects. Its base table is CE_ARCH_HEADERS_ALL. The associated transaction lines for each header are stored in CE_ARCH_LINES (and its underlying table CE_ARCH_LINES_ALL). The BANK_ACCOUNT_ID column references CE_BANK_ACCOUNTS to obtain bank account details. For reconciliation engine processes, it relates to the CE_RECONCILIATIONS_ALL table. The ORG_ID security links it to HR_OPERATING_UNITS. Understanding this view necessitates familiarity with this related hierarchy, as meaningful queries often involve joins to CE_ARCH_LINES for detail and CE_BANK_ACCOUNTS for descriptive bank account information.