Results for “unique_ref_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_FX_WHAT_IFS_V is a Treasury (XTR) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes data from the foreign exchange "what-if" analysis facility maintained by Oracle Treasury, presenting scenario-based currency exposure simulations used by treasury analysts and dealers. The view is a thin projection: it selects a defined subset of columns from the underlying base object and returns them under a stable, read-only interface. Because its definition is trivial (a straight column projection with no joins, aggregation, or filtering), it functions primarily as a semantic reporting layer. The columns of interest to the user search term "month_or_week" — the MONTH_OR_WEEK column — classify the forecasting interval applied to each what-if record, distinguishing monthly from weekly bucketing of projected currency movement.

Underlying Base Objects

The view is defined over a single documented base object:

• XTR_FX_WHAT_IFS (referenced through a SYNONYM) — the base table storing foreign exchange what-if scenario records.

Per the documented view text, XTR_FX_WHAT_IFS_V performs a SELECT UNIQUE_REF_NUMBER, CURRENCY, CREATED_BY, REVIEW, CCY_PERCENTAGE_MOVEMENT, FORECAST_RATE, BASIS, MONTH_OR_WEEK FROM XTR_FX_WHAT_IFS. No WHERE clause, DISTINCT, or join is present, so the view returns one row for each qualifying row in the base table. Its role is therefore interface stabilization and column-level access control rather than data transformation. Consumers should expect that the view inherits the partitioning, indexing, and multi-org characteristics of XTR_FX_WHAT_IFS, and that any data security on the base table effectively applies to the view.

Key Columns

• UNIQUE_REF_NUMBER — The primary identifier for the what-if scenario record; the natural join/surrogate key for linking to related Treasury entities.
• CURRENCY — The foreign currency code to which the what-if simulation applies.
• CREATED_BY — The Oracle Applications user ID of the creator of the record, used for audit and ownership reporting.
• REVIEW — A review indicator/status flag for the scenario, supporting approval and oversight workflows.
• CCY_PERCENTAGE_MOVEMENT — The assumed percentage movement in the currency, i.e., the shock or sensitivity input for the what-if.
• FORECAST_RATE — The projected exchange rate resulting from applying the assumed movement.
• BASIS — The basis of the forecast (for example, the underlying rate or reference convention used).
• MONTH_OR_WEEK — The time bucket controlling whether the scenario is evaluated on a monthly or weekly interval; this is the column most relevant to interval-based analysis.

Common Use Cases and Queries

Typical reporting scenarios include auditing forecast assumptions, reviewing scenario inputs by user, and comparing monthly versus weekly what-if exposures. Because the view exposes MONTH_OR_WEEK directly, interval filtering is straightforward.

• List all monthly what-if scenarios:
  SELECT unique_ref_number, currency, forecast_rate FROM apps.xtr_fx_what_ifs_v WHERE month_or_week = 'MONTH';
• Summarize scenario counts by currency and interval:
  SELECT currency, month_or_week, COUNT(*) FROM apps.xtr_fx_what_ifs_v GROUP BY currency, month_or_week;
• Review creator-owned scenarios:
  SELECT created_by, unique_ref_number FROM apps.xtr_fx_what_ifs_v WHERE review IS NOT NULL;

Since the view adds no predicates, restrict large result sets with MONTH_OR_WEEK, CURRENCY, or CREATED_BY filters to avoid full scans of the underlying Treasury table.