Search Results xtr_exposure_transactions_v




Overview
Explore in AI Chat

Overview

XTR_EXPOSURE_TRANSACTIONS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite (12.1.1 and 12.2.2). It belongs to the XTR – Treasury product family and exposes treasury exposure transaction data for reporting, inquiry, and downstream integration. The view provides a denormalized, security-friendly projection of the underlying exposure transaction entity, allowing external systems, custom concurrent programs, and BI reporting tools to consume exposure records without querying base tables directly.

Because this object is a view rather than a table, it carries no storage of its own and cannot be updated through DML (unless an INSTEAD OF trigger exists, which is not documented here). Its role is to present a stable interface to exposure data such as deal type, counterparty, currency amounts, payment status, and FX coverage indicators. A distinguishing feature is the presence of the CASH_POSITION_EXPOSURE column, which classifies each record as a cash position exposure — a concept central to treasury liquidity and cash management reporting.

Underlying Base Objects

The view is defined over a single documented base object: XTR_EXPOSURE_TRANSACTIONS, referenced through a synonym. The SELECT statement projects the full set of base columns and adds the derived/persisted CASH_POSITION_EXPOSURE column. In practice, the base synonym resolves to the treasury exposure transaction table that stores deal-level exposure details. Because the view maps one-to-one with the base table columns (plus the exposure classification), joins to deal, counterparty, and currency reference tables are typically performed at the base or through related views such as XTR_EXPOSURE_HEADERS_V. Implementers should treat the base table as the system of record and this view as the reporting interface.

Key Columns

Common Use Cases and Queries

Typical usage includes building exposure reports by currency, monitoring unmatched settlement actions, and feeding treasury data warehouses. The following query lists open exposures by counterparty and currency:

SELECT transaction_number, company_code, cparty_code,
       currency, amount, amount_hce, value_date,
       cash_position_exposure, payment_status
FROM   apps.xtr_exposure_transactions_v
WHERE  deal_status = 'OPEN'
AND    value_date >= SYSDATE
ORDER BY cparty_code, currency;

To identify transactions requiring settlement action:

SELECT transaction_number, deal_type, deal_subtype,
       payment_amount, settle_action_reqd
FROM   apps.xtr_exposure_transactions_v
WHERE  settle_action_reqd = 'Y'
AND    payment_status <> 'SETTLED';

To summarize FX-covered exposure in home currency:

SELECT currency, COUNT(*) txns, SUM(amount_hce) total_hce
FROM   apps.xtr_exposure_transactions_v
WHERE  covered_by_fx_contract = 'Y'
GROUP BY currency;

Because the view is APPS-owned, grants to reporting schemas or BI users must be managed through standard EBS security; direct DML against the view is not supported.