Search Results cefv_ect




Overview
Explore in AI Chat

Overview

CEFV_ECT is a read-only business view owned by the APPS schema within the Cash Management (CE) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The view acts as a consolidated reporting layer over cash transaction interface data, joining transaction records to their associated bank account and currency conversion type information. It is registered as a VALID database object and is exposed through the ETRM (E-Business Suite Technical Reference Manual) as a documented business view.

In practice, CEFV_ECT allows external reports, reconciliation extracts, and integration programs to retrieve cash transaction details together with the human-readable bank account number and name in a single query, avoiding the need to manually join the interface and bank account tables. Because the view is created WITH READ ONLY, it is intended exclusively for query and reporting purposes and cannot be used as a DML target.

Underlying Base Objects

The view text is defined over three referenced base objects, each documented in the 12.2.2 metadata:

The alias assignment (IV, BA, DC) and the outer-join on GL_DAILY_CONVERSION_TYPES are significant: they indicate the view tolerates missing or unmapped exchange rate types rather than silently filtering those rows.

Key Columns

The view exposes the following columns, renamed where appropriate for readability:

Common Use Cases and Queries

Typical uses include bank reconciliation reporting, cash position analysis, and integration extracts that require the bank account number. A representative query returning transactions for a specific account is:

SELECT transaction_id, bank_account_number, bank_account_name,
    transaction_number, transaction_date, currency_code,
    amount, cleared_amount, status
FROM apps.cefv_ect
WHERE bank_account_number = '1234567890'
ORDER BY transaction_date DESC;

A second common pattern aggregates amounts by currency and account for cash reporting:

SELECT bank_account_number, currency_code,
    SUM(amount) total_amount, SUM(cleared_amount) cleared
FROM apps.cefv_ect
GROUP BY bank_account_number, currency_code;

Because the view is read-only and references the interface view, callers should treat the results as query-time snapshots rather than persistent data, and should not attempt INSERT, UPDATE, or DELETE against CEFV_ECT.