Search Results ce_185_transactions_v




Overview
Explore in AI Chat

Overview

CE_185_TRANSACTIONS_V is a Cash Management (CE) database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes available Treasury transactions that are eligible for bank statement reconciliation through the Cash Management Open Interface. The view is part of the seeded Open Interface mapping framework: the numeric suffix 185 identifies a specific Open Interface transaction source format, and the view supplies rows shaped to match that format's column layout. Cash Management reconciliation programs read from this view when loading external or Treasury-originated transactions into the reconciliation workbench.

Because it is a view rather than a table, no data is stored in it; every query dynamically assembles settlement and deal information from the Treasury (XTR) tables and joins it to bank account, ledger, and security context. The view is therefore read-only and intended for integration and reporting rather than transactional DML.

Underlying Base Objects

The view is defined over a combination of XTR (Treasury), CE (Cash Management), GL, and application context objects. Documented referenced objects include:

The view text confirms these joins, including references to ABA.BANK_ACCOUNT_ID, SOB.CURRENCY_CODE, and CRE.STATUS_FLAG, consistent with the documented base objects.

Key Columns

Common Use Cases and Queries

The primary use case is loading Treasury transactions into reconciliation. A typical query filters by bank account and date:

  • SELECT settlement_number, bank_account_num, currency, settlement_date FROM ce_185_transactions_v WHERE settlement_date BETWEEN :p_from AND :p_to;
  • SELECT * FROM ce_185_transactions_v WHERE bank_account_id = :p_bank_account_id;

Note that the view enforces access control through FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, and XTR_USER_ACCESS, so results are restricted to banks the querying user is authorized to reconcile. The user search term xtr_asset_ccid reflects the Treasury asset account code combination carried through these settlement joins; users typically join the view to CE_GL_ACCOUNTS_CCID or the Treasury deal tables to resolve the reconciling GL account for asset-side postings.