Search Results ce_999_transactions_v




Overview
Explore in AI Chat

Overview

CE_999_TRANSACTIONS_V is an Oracle E-Business Suite Cash Management (CE) view owned by the APPS schema. It is documented as presenting the set of available transactions for reconciliation through the Open Interface. In the Cash Management reconciliation workflow, treasury and accounting users match bank statement lines against internal cash transactions. This view acts as a normalized, consumer-facing projection over the transactional data used by that reconciliation process, exposing bank account, bank, transaction, currency, amount, and status information in a single queryable structure. The view is VALID and is available in both EBS 12.1.1 and 12.2.2 environments. Because it is a view rather than a table, it carries no storage of its own and inherits the access controls and row-level security that apply to its underlying objects.

Underlying Base Objects

The documented ETRM metadata for 12.2.2 lists the following referenced base objects:

The view text shows the principal alias sources: transaction rows (T), bank account data (ABA), bank and branch data (ABB), the set of books record (SOB), a user conversion type reference (GLC), and a creation-status reference (CRE). The presence of FND_PROFILE, FND_GLOBAL, FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, and XTR_USER_ACCESS indicates that the view applies multi-org and access-control predicates, so rows visible to a session are constrained by the user's organization and access privileges.

Key Columns

The view projects a positional column list, with the following business-relevant fields:

Several positional columns are intentionally NULL or typed placeholders (TO_NUMBER(NULL), TO_DATE(NULL)), which preserves a fixed interface signature expected by downstream reconciliation consumers.

Common Use Cases and Queries

The view is typically queried for reconciliation reporting, open-interface diagnostics, and data validation. A basic listing of reconcile-ready transactions is:

  • SELECT TRX_NUMBER, TRX_TYPE, BANK_ACCOUNT_NAME, CURRENCY_CODE, AMOUNT, GL_DATE, STATUS_DSP FROM APPS.CE_999_TRANSACTIONS_V ORDER BY TRX_DATE;

Filtering by bank account and status supports statement reconciliation analysis:

  • SELECT TRX_ID, TRX_NUMBER, CLEARED_AMOUNT, CLEARED_DATE FROM APPS.CE_999_TRANSACTIONS_V WHERE BANK_ACCOUNT_ID = :p_account AND STATUS = :p_status;

Because access is governed by FND and MO security packages, results are automatically scoped to the operating unit and organization privileges of the connected user. The view should be treated as read-only; interface loading and reconciliation posting are performed through the corresponding Cash Management Open Interface programs rather than direct DML.