Search Results statement_header_number




Overview
Explore in AI Chat

Overview

APPS.CE_RECONCILED_TRANSACTIONS_V is a consolidated reconciliation view in the Oracle Cash Management (CE) module of Oracle E-Business Suite. It presents the union of all bank-statement-to-transaction reconciliation data across the various bank file format reconciliation views supported by Cash Management. Rather than querying each format-specific view independently, applications and reports can query this single view to retrieve a uniform, format-independent picture of every reconciled and unreconciled transaction line processed through the bank statement reconciliation engine.

The view plays a central role in reconciliation reporting, bank statement matching workbenches, and downstream integration or extract processes. Because it normalizes columns such as TRX_TYPE, LINE_TRX_TYPE, STATUS, and AMOUNT_CLEARED across all underlying source views, it allows a single query or report definition to operate consistently regardless of which bank statement format the source data originated from.

Underlying Base Objects

The view is defined as a UNION ALL over the family of format-specific reconciliation views, including:

It also references supporting program units: CE_AUTO_BANK_CLEAR, CE_AUTO_BANK_MATCH, FND_GLOBAL, IBY_FD_EXTRACT_GEN_PVT, and PAY_CE_RECONCILIATION_PKG. The package CE_AUTO_BANK_MATCH supplies the inverse exchange rate handling applied to the EXCHANGE_RATE expression via the GET_INVERSE_RATE function. FND_GLOBAL typically supplies session context such as ORG_ID. Each constituent view returns an identically structured result set, allowing the union to expose a common column list capped with CE_BANK_ACCT_USE_ID, ORG_ID, and LEGAL_ENTITY_ID.

Key Columns

The view exposes an extensive column list. Among the most significant are:

Common Use Cases and Queries

Typical uses include reconciliation dashboards, open-item analysis, and extracts for downstream reconciliation or audit. A frequent pattern filters on the line transaction type, which corresponds to the "line_trx_type" search term:

  • Listing all reconciled lines for a bank account: SELECT trx_number, line_trx_type, amount, amount_cleared, status FROM ce_reconciled_transactions_v WHERE bank_account_id = :p_account_id;
  • Filtering by line transaction type: SELECT statement_line_number, trx_number, line_trx_type, amount FROM ce_reconciled_transactions_v WHERE line_trx_type = :p_type;
  • Retrieving unreconciled or partially cleared items: SELECT trx_number, status, amount, amount_cleared FROM ce_reconciled_transactions_v WHERE amount_cleared < amount;
  • Org-scoped reporting leveraging ORG_ID and LEGAL_ENTITY_ID for multi-org and legal entity segregation.

Because the view applies the union across all format-specific sources, queries are portable across statement formats and remain consistent with the reconciliation workbench logic.