Search Results ce_arch_interface_headers

Overview

CE_ARCH_INTERFACE_HEADERS is a reporting and integration view within the Oracle E-Business Suite Cash Management (CE) module. It exposes bank statement interface header information that has been archived, providing a read-accessible projection of the underlying interface data. In the context of Oracle EBS 12.1.1 and 12.2.2, this object is classified as a single-org view, meaning that the Multi-Org security model is applied through the ORG_ID column via the CLIENT_INFO session context rather than through a separate operating unit filter. The view is documented as not implemented in the reference database, which indicates that it is a supplied definition whose instantiation depends on the deployment and archival configuration in a given environment.

The view plays a role in reconciliation, audit, and downstream reporting of bank statement loads that have been moved to archival storage. Because it filters on ORG_ID, queries against it are implicitly scoped to the operating unit established in the user's session, aligning with standard EBS multi-org access control.

Underlying Base Objects

The view is defined over the base table CE_ARCH_INTERFACE_HEADERS_ALL. The view text is a straightforward projection that selects a defined column list from that base table and applies a WHERE clause restricting rows to the current operating unit. The security predicate compares the current NVL-wrapped ORG_ID of each row against the ORG_ID derived from USERENV('CLIENT_INFO'), using the standard ten-character decode pattern and the sentinel value -99 for records that carry no explicit organization identifier. No other referenced base objects are documented in the supplied ETRM metadata, and the metadata lists no additional dependencies beyond this single underlying table.

Key Columns

• STATEMENT_NUMBER — Bank statement identifier for the archived interface header.
• BANK_ACCOUNT_NUM, BANK_NAME, BANK_BRANCH_NAME — Bank and account identification attributes.
• STATEMENT_DATE — Date of the statement being interfaced.
• CONTROL_BEGIN_BALANCE, CONTROL_END_BALANCE — Opening and closing balances used for control reconciliation.
• CONTROL_TOTAL_DR, CONTROL_TOTAL_CR — Control totals for debits and credits.
• CONTROL_DR_LINE_COUNT, CONTROL_CR_LINE_COUNT, CONTROL_LINE_COUNT — Line counts supporting integrity checks between header and detail.
• CURRENCY_CODE — Currency of the statement header.
• RECORD_STATUS_FLAG — Processing/status indicator for the interface record.
• CASHFLOW_BALANCE, INT_CALC_BALANCE, INTRA_DAY_FLAG, ONE_DAY_FLOAT, TWO_DAY_FLOAT — Cash positioning and float attributes.
• CHECK_DIGITS — Bank account check digit information.
• ORG_ID — Operating unit identifier driving single-org security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield columns for extensibility.

Common Use Cases and Queries

Typical scenarios include reconciliation between control totals and detail lines, audit of historically loaded statements, and reporting on float and cash positioning balances. The following query retrieves recent archived headers for the current operating unit:

• SELECT STATEMENT_NUMBER, BANK_ACCOUNT_NUM, STATEMENT_DATE, CONTROL_BEGIN_BALANCE, CONTROL_END_BALANCE FROM CE_ARCH_INTERFACE_HEADERS ORDER BY STATEMENT_DATE DESC;
• SELECT CURRENCY_CODE, SUM(CONTROL_TOTAL_DR), SUM(CONTROL_TOTAL_CR) FROM CE_ARCH_INTERFACE_HEADERS GROUP BY CURRENCY_CODE;

Because the view enforces single-org filtering, results reflect the operating unit associated with the active session context.