Results for “fx_original_reval_rate”

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

Overview

The XTR_TMP_FX_EXPOSURE_V view is a Treasury (XTR) module database object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a denormalized, query-ready projection of foreign exchange (FX) exposure data used by Oracle Treasury for measuring, analyzing, and reporting currency risk across portfolios and periods. The view exposes the results of the FX exposure calculation process, including net exposure amounts, forecast coverage, discount rates, and revaluation rates, along with the parameter selections used to produce each result set.

Functionally, the view serves as a reporting and integration layer. Because it carries both the calculated exposure figures and the input parameters (base currency, selected currency, portfolio, yield curve, period), it allows downstream reports, concurrent programs, and custom integrations to reproduce or audit a specific exposure run without re-executing the underlying calculation logic. This makes it a natural access point for BI Publisher reports, OTBI-style extracts, and third-party risk dashboards that need periodic FX exposure snapshots.

Underlying Base Objects

The documented view definition is a straightforward projection: it selects all columns from XTR_TMP_FX_EXPOSURE, which is referenced through a synonym. The view text uses SELECT ... FROM XTR_TMP_FX_EXPOSURE covering every column listed in the metadata, with no joins, filters, or aggregation present in the view layer itself. This means the view inherits its row population entirely from the base temporary/staging object.

The "TMP" naming convention and the presence of UNIQUE_REF_NUMBER, CREATED_BY, and CREATED_ON indicate that the underlying object holds transient or run-scoped output from the FX exposure calculation engine. Each invocation typically writes a set of rows tagged by a unique reference number, and the view provides a stable, named interface to that data. Because the base is described as a temporary/staging construct, consumers should treat the contents as refreshable and scoped to a specific calculation run rather than as permanent master data.

Key Columns

• UNIQUE_REF_NUMBER — Identifier that groups rows belonging to a single exposure calculation run; essential for correlating parameters with results.
• COMPANY — Legal entity or company context for the exposure.
• CURRENCY — The exposure currency being measured.
• BASE_CURRENCY and SELECTED_BASE_CURRENCY — The reporting base currency and the user-selected base currency. This distinction is central to the "base_currency" search context: BASE_CURRENCY reflects the functional/reporting currency, while SELECTED_BASE_CURRENCY reflects the parameter chosen for the run.
• SELECTED_CCY and SELECTED_PORTFOLIO — User-selected currency and portfolio filters applied to the calculation.
• PORTFOLIO and YIELD_CURVE — Portfolio assignment and the yield curve used for valuation and discounting.
• INCL_FX_OPTIONS and INCL_INDIC_EXPOSURES — Flags indicating whether FX options and indirect exposures were included.
• DISCOUNT_RATE and FX_ORIGINAL_REVAL_RATE — Discounting and revaluation rates applied.
• FX_AMOUNT, EXP_AMOUNT, NET_EXPOSURE — Core monetary results.
• COVER_TO_FORECAST, MAX_AMOUNT, MIN_AMOUNT — Forecast coverage and threshold amounts.
• FX_PERCENT_MAX and FX_PERCENT_MIN — Percentage tolerance bounds on FX exposure.
• PERIOD_NAME, PERIOD_DESC, PERIOD_FROM, PERIOD_TO — Accounting period identification and date boundaries.
• CREATED_BY and CREATED_ON — Audit columns identifying who ran the calculation and when.

Common Use Cases and Queries

Typical scenarios include retrieving the latest exposure by base currency, auditing the parameters used in a run, and feeding exposure figures into hedging or reporting processes.

To inspect exposure results for a specific base currency:

• SELECT unique_ref_number, company, currency, base_currency, selected_base_currency, net_exposure, period_name FROM xtr_tmp_fx_exposure_v WHERE base_currency = :p_base_currency;

To review the parameters and result amounts for a single run:

• SELECT currency, portfolio, yield_curve, discount_rate, fx_amount, exp_amount, net_exposure, cover_to_forecast FROM xtr_tmp_fx_exposure_v WHERE unique_ref_number = :p_ref;

To compare selected versus reporting base currency across periods:

• SELECT period_name, currency, base_currency, selected_base_currency, SUM(net_exposure) net_exp FROM xtr_tmp_fx_exposure_v GROUP BY period_name, currency, base_currency, selected_base_currency;

Because the contents are run-scoped and transient, queries should always constrain by UNIQUE_REF_NUMBER, PERIOD_NAME, or CREATED_ON to avoid mixing results from multiple executions.