Search Results reversal_reason




Overview
Explore in AI Chat

Overview

APPS.CE_REVERSAL_TRANSACTIONS_V is a Cash Management (CE) reporting view that exposes transactions eligible for reversal or unclearing within Oracle E-Business Suite 12.1.1 and 12.2.2. It is a UNION ALL view assembled from a family of version-specific reversal views, allowing a single query surface to return reversal candidates regardless of which bank statement reconciliation engine is active for the operating unit.

The view does not store data; it is a curated projection over the underlying reversal views. Its purpose is to support the Reversal and Unclear Transactions windows, the Auto Reconciliation workflow, and downstream reporting or integration extracts that need to enumerate clearable or unclearable treasury transactions. Because the object is owned by APPS and marked VALID, it can be referenced directly from custom reports, BI Publisher data models, or interface programs following standard EBS security and MOAC conventions.

Underlying Base Objects

The documented base objects reflect the view's composition and dependency chain:

The union structure means the view returns the same logical column set from each branch; the trailing TO_NUMBER(NULL) padding in the documented excerpt indicates columns appended in later branches to preserve positional alignment.

Key Columns

Common Use Cases and Queries

Typical uses include populating reversal LOVs, driving Auto Reconciliation, and producing reconciliation audit extracts. When searching by agent_name, the view allows identification of all reversible or unclearable transactions associated with a given trading partner.

SELECT trx_number, trx_type, agent_name, amount,
       currency_code, status_dsp, cleared_date, batch_name
FROM   apps.ce_reversal_transactions_v
WHERE  agent_name LIKE :p_agent_name
AND    org_id = :p_org_id
ORDER  BY trx_date;

Reversal-specific queries can filter on the reversal category and reason to report why transactions are candidates for reversal, while unclearing queries filter on the reconciliation flag to locate cleared items still eligible for reversal. Joining back to CE_BANK_ACCOUNTS or GL tables is common when building financial reconciliation reports.