Search Results ce_260_cf_transactions_v




Overview
Explore in AI Chat

Overview

CE_260_CF_TRANSACTIONS_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents available cashflow payments and receipts eligible for reconciliation or clearing, consolidating bank account, cashflow, and multi-currency conversion data into a single reporting structure. The view is a key component of the cashflow reconciliation data model used by Cash Management worksheets and related internal logic. It is registered as VALID in ETRM and is intended for reporting and integration rather than direct transactional data entry.

Underlying Base Objects

The view is defined over a substantial set of documented base objects, as recorded in ETRM 12.2.2. These include bank account and branch views (CE_BANK_ACCTS_GT_V, CE_BANK_BRANCHES_V), cashflow tables (CE_CASHFLOWS, CE_CASHFLOW_ACCT_H, CE_PAYMENT_TRANSACTIONS), reconciliation objects (CE_STATEMENT_RECONCILS_ALL), and reference data such as FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, GL_SETS_OF_BOOKS, and CE_LOOKUPS. Security and setup are handled through CE_SECURITY_PROFILES_GT, CE_SYSTEM_PARAMETERS, and CE_TRXNS_SUBTYPE_CODES. Payables-side objects include IBY_FD_DOCS_PAYABLE_V, IBY_FD_PAYMENTS_V, and IBY_FD_EXTRACT_GEN_PVT, while XLE_ENTITY_PROFILES supplies legal entity context. The view joins cashflow records to bank account definitions, converts foreign-currency amounts to bank account currency using system parameters and daily conversion rates, and enriches results with lookup meanings for transaction type and status.

Key Columns

Common Use Cases and Queries

Typical use cases include building reconciliation worksheets, identifying uncleared cashflows, validating bank account balances, and feeding downstream integration extracts. A simple query returns available payments and receipts for a given bank account:

  • SELECT cashflow_id, trx_number, trx_type, bank_account_name, cashflow_amount, bank_account_amount, cashflow_status_code, gl_date FROM ce_260_cf_transactions_v WHERE bank_account_id = :p_account_id ORDER BY cashflow_date;
  • SELECT cashflow_direction, SUM(bank_account_amount) FROM ce_260_cf_transactions_v WHERE cashflow_status_code = 'UNCLEARED' GROUP BY cashflow_direction;

Because the view enforces bank-level and legal entity context through security profiles and system parameters, it is commonly joined in Cash Management reports and reconciliation APIs to present multi-currency amounts consistently in the bank account currency, supporting accurate clearing and statement reconciliation.