Search Results acct_balance

Overview

XTR_EXPOSURE_SUMMARY_V is a reporting view owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2, delivered as part of the XTR – Treasury (ETRM) product family. The view presents summarized foreign exchange and treasury exposure data, consolidating amounts, currency combinations, discounting parameters, and hedging indicators into a single queryable structure. Its principal value in an EBS reporting and integration context is that it isolates exposure summary output without requiring consumers to reconstruct the same projection directly against the transactional exposure tables. The OBJECT_TYPE is VIEW and the object STATUS is VALID, indicating that the definition is compiled and available at the documented metadata level.

The view is defined as a horizontal projection: it selects a fixed list of columns rather than joining additional objects, and it does not perform aggregation or filtering beyond the DISTINCT semantics implied by the SELECT UNIQUE_REF_NUMBER, COMPANY, ... FROM XTR_EXPOSURE_SUMMARY construct. Consequently, row cardinality and grain are inherited directly from the base object.

Underlying Base Objects

The documented referenced base object is XTR_EXPOSURE_SUMMARY, resolved through a SYNONYM. The view text is a straight SELECT from XTR_EXPOSURE_SUMMARY listing the same column set that the view exposes, so the relationship is one-to-one in terms of rows and columns — no transformed expressions, unions, or analytical functions are present in the documented definition.

Because the view is owned by APPS and reads through a synonym, consumers querying XTR_EXPOSURE_SUMMARY_V implicitly depend on the synonym resolution and privileges governing XTR_EXPOSURE_SUMMARY in the target instance. The view therefore behaves as a controlled access layer over exposure summary data rather than as an independent data mart. Organizations should verify that any customization or security policy applied to the base object is also respected when access is granted to the view.

Key Columns

The column list is comprehensive and reflects the analytical dimensions of FX exposure reporting. Notable columns include:

• ACCT_BALANCE — the accounting balance associated with the summarized exposure, and the column most directly relevant to the user's search term. It is distinct from AMOUNT, which represents the summarized exposure amount.
• UNIQUE_REF_NUMBER — the identifier linking the summary record to a run or exposure set.
• COMPANY, CURRENCY, BASE_CURRENCY, SELECTED_CCY, SELECTED_CCY2 — the legal entity and currency dimensions, including selected currency parameters used in the summary run.
• PERIOD, PERIOD_DATE, MONTH_OR_WEEK — the time dimension, supporting both monthly and weekly reporting granularity.
• AMOUNT, FIXED_AMOUNT, WEIGHTED_AVERAGE, AVERAGE_DAYS, NUMBER_OF_ITEMS — quantitative measures describing the exposure population and its weighting.
• TRANSACTION_RATE, FORWARD_FX_RATE, FX_ORIGINAL_REVAL_RATE, DISCOUNT_RATE, DISCOUNTED_VALUE, DISCOUNTED_BACK_TO, YIELD_CURVE — valuation and discounting parameters applied to the exposure.
• INCL_FX_OPTIONS, INCL_INDIC_EXPOSURES, SELECTED_OPTIONS, SELECTED_INDIC, HEDGE_OR_TRADE_VIEW, HEDGE_TRADE_WHATIF — inclusion flags and scenario indicators controlling what the summary represents.
• PORTFOLIO_CODE, SELECTED_PORTFOLIO, CURRENCY_COMBINATION — portfolio and currency-pair grouping attributes.

Common Use Cases and Queries

Typical uses include exposure reporting, reconciliation of summarized amounts to accounting balances via ACCT_BALANCE, and feed extraction into downstream treasury or risk systems. A representative query retrieving accounting balance alongside exposure amounts by currency is:

• SELECT UNIQUE_REF_NUMBER, COMPANY, CURRENCY, PERIOD, AMOUNT, ACCT_BALANCE, WEIGHTED_AVERAGE FROM APPS.XTR_EXPOSURE_SUMMARY_V WHERE COMPANY = :p_company AND PERIOD = :p_period;
• SELECT CURRENCY, SUM(AMOUNT) EXPOSURE, SUM(ACCT_BALANCE) BALANCE FROM APPS.XTR_EXPOSURE_SUMMARY_V WHERE UNIQUE_REF_NUMBER = :p_ref GROUP BY CURRENCY;
• SELECT PORTFOLIO_CODE, HEDGE_OR_TRADE_VIEW, DISCOUNTED_VALUE FROM APPS.XTR_EXPOSURE_SUMMARY_V WHERE INCL_FX_OPTIONS = 'Y' AND MONTH_OR_WEEK = 'W';

Consumers should confirm the meaning of inclusion and what-if columns with their treasury configuration, since these attributes alter the population represented by each row.