Search Results ce_222_batches_v




Overview
Explore in AI Chat

Overview

CE_222_BATCHES_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes the set of available Accounts Receivable remittance batches eligible for reconciliation in Oracle Cash Management. The numeric prefix "222" corresponds to the batch source / document category used by the reconciliation workflow, and the view is designed to present these batches in the exact column layout expected by the Cash Management reconciliation engine and associated reporting screens.

The view functions as a read-only presentation layer over AR remittance batch data, joining batch header information with bank account, bank, branch, currency, and exchange rate reference data. It does not store data itself; every row is derived at runtime. Because it is registered in the APPS schema and referenced through ETRM metadata, it can be treated as a supported reporting and integration object for reconciliation-oriented extracts.

Underlying Base Objects

The view is defined over a combination of base tables, synonyms, and views. The principal operational source is AR_BATCHES_ALL, which supplies the remittance batch header rows (batch ID, name, deposit number, batch date, currency, GL date, exchange rate details). Bank account information comes from CE_BANK_ACCOUNTS, while account usage and org-level access are enforced through CE_BANK_ACCT_USES_ALL.

The joins enforce effective-dating (SYSDATE between start and end dates) and remittance linkage through B.REMIT_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID.

Key Columns

Common Use Cases and Queries

Typical uses include reconciliation dashboards, custom remittance batch reports, and integration extracts feeding AutoReconciliation. A basic query retrieves available receipt batches for the current operating unit:

  • SELECT batch_id, bank_account_name, batch_date, currency_code, exchange_rate FROM ce_222_batches_v WHERE org_id = :org_id ORDER BY batch_date;
  • SELECT batch_id, bank_deposit_number, gl_date FROM ce_222_batches_v WHERE batch_date BETWEEN :from_date AND :to_date;

Because access is already filtered through MO_GLOBAL.CHECK_ACCESS and effective-dated account usage, queries against this view return only batches the current responsibility is authorized to reconcile, making it suitable for direct use in BI Publisher reports and concurrent program extracts.