Search Results ce_222_transactions_v




Overview
Explore in AI Chat

Overview

CE_222_TRANSACTIONS_V is a Cash Management (CE) reporting view owned by the APPS schema. It presents Accounts Receivable receipts that are available for reconciliation or clearing against bank statement lines. The view is one of a family of numbered CE transaction views (for example, CE_101_TRANSACTIONS_V, CE_222_TRANSACTIONS_V, CE_999_TRANSACTIONS_V) that conform to a common column layout consumed by the Cash Management reconciliation and AutoReconciliation engine, the CE_AUTO_BANK_CLEAR package, and the Bank Statement Reconciliation user interface.

The view consolidates receipt header information, receipt history, bank account attributes, payment schedule details, customer and party names, currency and exchange rate context, and reconciliation status into a single denormalized result set. The numeric suffix 222 identifies the transaction class the view returns; in the standard seeded configuration, CE_222_TRANSACTIONS_V is associated with Miscellaneous Receipt transaction types, distinguishing it from other numbered views that return different AR receipt classes. This makes it the specific access path used when Cash Management needs to present non-invoice-related receipts for matching against bank statement lines.

Underlying Base Objects

The documented base objects for this view span the AR, CE, GL, and HZ schemas, all referenced through APPS synonyms or views:

CE_SECURITY_PROFILES_GT is a global temporary table, indicating that the view participates in bank account security enforcement so that users see only receipts belonging to bank accounts within their security profile.

Key Columns

Because the view emits a positional column list, the important columns are the CASH_RECEIPT_HISTORY_ID (the reconciliation anchor), CASH_RECEIPT_ID, RECEIPT_NUMBER, RECEIPT_DATE, TYPE and its decoded MEANING, RECEIPT_CLASS, CURRENCY_CODE, STATUS, AMOUNT, ACCTD_AMOUNT, FACTOR_DISCOUNT_AMOUNT, GL_DATE, TRX_DATE, EXCHANGE_DATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE, and EXCHANGE_RATE_TYPE_MEANING. Bank account columns include BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM, and the bank's currency code. Customer context is carried through PAY_FROM_CUSTOMER and party name columns. REFERENCE_TYPE and REFERENCE_ID link the receipt to its originating document. The view also exposes audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, plus BATCH_ID, BATCH_NAME, and BANK_DEPOSIT_NUMBER.

Regarding the searched column, reversed_cash_receipt_id: this column is not part of the enumerated structure of CE_222_TRANSACTIONS_V. In Oracle EBS, REVERSED_CASH_RECEIPT_ID exists on AR_CASH_RECEIPTS_ALL to link a reversing receipt to the original. Because CE_222_TRANSACTIONS_V does not project that column, users searching for it in this view will not find it. To trace reversals, query AR_CASH_RECEIPTS_ALL directly, or join the view's CASH_RECEIPT_ID back to AR_CASH_RECEIPTS_ALL and inspect REVERSED_CASH_RECEIPT_ID there.

Common Use Cases and Queries

Typical uses include reconciling AR receipts to bank statements, generating receipt-level clearing reports, and diagnosing why a receipt is not appearing for reconciliation. A representative query:

  • SELECT cash_receipt_id, receipt_number, amount, currency_code, status, gl_date, bank_account_name FROM ce_222_transactions_v WHERE status = 'REMITTED' ORDER BY gl_date;
  • Joining back to AR_CASH_RECEIPTS_ALL for reversal data: SELECT v.receipt_number, r.reversed_cash_receipt_id FROM ce_222_transactions_v v, ar_cash_receipts_all r WHERE v.cash_receipt_id = r.cash_receipt_id AND r.reversed_cash_receipt_id IS NOT NULL;
  • Filtering by bank account and date for reconciliation extracts: WHERE bank_account_id = :p_account AND receipt_date BETWEEN :p_from AND :p_to.

In 12.1.1 and 12.2.2 the view definition is essentially stable, though the online table in online table is identical. The view is valid in both releases.