Search Results trx_currency_type




Overview
Explore in AI Chat

Overview

APPS.CE_AVAILABLE_BATCHES_V is a reporting and integration view in the Oracle E-Business Suite Cash Management (CE) module. Its purpose is to expose bank statement batch information that is available for reconciliation processing, primarily for use by Oracle Cash Management's Automatic Bank Matching and reconciliation workbench functionality. In Oracle EBS 12.1.1 and 12.2.2, the view acts as a filtered, unified presentation layer over multiple version-specific batch views, allowing a single query interface to return the correct data set depending on the matching engine that is active.

The view includes a column named MULTI_SELECT, which is exposed as the second column in the SELECT list. Multi-select behavior is significant in the automatic reconciliation UI, where users select one or more transactions from a results grid for batch clearing. The MULTI_SELECT column presence indicates this view was designed to support grid-based selection workflows in the Cash Management reconciliation interface.

Underlying Base Objects

The documented base objects referenced by this view are: CE_200_BATCHES_V, CE_200_GROUPS_V, CE_222_BATCHES_V, the package CE_AUTO_BANK_MATCH, and the MO_GLOBAL package. The view text applies a UNION ALL over the version-specific batch views (for example, CE_200_BATCHES_V). Each branch of the union is gated by a conditional expression driven by the function CE_AUTO_BANK_MATCH.GET_200. When that function returns 1, the branch sourced from CE_200_BATCHES_V is included in the result set; other branches governed by equivalent flags (for the newer matching engines represented by CE_222_BATCHES_V) are included in turn. This structure enables a single view name to serve organizations running different matching algorithms across releases.

The join to MO_GLOBAL provides multi-org (Operating Unit / ORG_ID) security context, since the view exposes ORG_ID. The reference to CE_BANK_ACCT_USE_ID further indicates that bank account usage and association to legal entities and operating units are resolved through related CE bank account tables and views.

Key Columns

The view exposes the following important columns:

Common Use Cases and Queries

This view is typically queried to identify batches eligible for automatic clearing, to populate reconciliation grids, or to report on outstanding bank statement lines by bank account and operating unit.

  • Identifying available batches for a bank account: SELECT batch_id, trx_number, trx_date, amount, currency_code FROM ce_available_batches_v WHERE bank_account_id = :p_account_id AND org_id = :p_org_id;
  • Listing multi-selectable reconciliation candidates: SELECT row_id, multi_select, batch_id, remittance_number FROM ce_available_batches_v WHERE multi_select = 'Y';
  • Reporting cleared versus total amounts: SELECT bank_account_name, trx_number, amount, amount_cleared, exchange_rate FROM ce_available_batches_v WHERE gl_date BETWEEN :p_start AND :p_end;

Because access is governed by MO_GLOBAL, queries should be executed within a properly initialized multi-org session so that ORG_ID restrictions are applied.