Results for “spread_against_usd”

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

Overview

XTR_SPOT_RATES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the XTR (Treasury) product family and is documented with a status of VALID. The view presents spot foreign exchange rate information maintained within Oracle Treasury, exposing one row per currency and effective rate date. Its role is to provide a stable, read-only projection of the spot rate store so that external interfaces, custom reports, and concurrent programs can consume treasury rate data without binding directly to the underlying transactional table. Because the view is a passthrough projection rather than a derivation, the values returned are identical to those held in the base object, and the view adds no filtering, joining, or aggregation logic of its own.

Underlying Base Objects

The view is defined over the base object XTR_SPOT_RATES, accessed through a synonym in the APPS schema. The ETRM metadata identifies XTR_SPOT_RATES (SYNONYM) as the sole referenced base object. The view text is a straightforward column projection: it selects CURRENCY, RATE_DATE, BID_RATE_AGAINST_USD, SPREAD_AGAINST_USD, OFFER_RATE_AGAINST_USD, USD_BASE_CURR_BID_RATE, USD_BASE_CURR_OFFER_RATE, HCE_RATE, SEQ_NO, ARCHIVE_DATE, ARCHIVE_BY, and UNIQUE_PERIOD_ID from XTR_SPOT_RATES. No WHERE clause, join, or function is applied. Consequently, the row cardinality of the view matches that of the underlying spot rate table, and any archive or purge activity performed against the base table is immediately reflected in query results. The presence of SEQ_NO, ARCHIVE_DATE, ARCHIVE_BY, and UNIQUE_PERIOD_ID indicates the base table participates in Oracle's standard archival and multi-period data model, in which historical rate sets are retained and tagged by period.

Key Columns

• CURRENCY — The currency code for which the spot rate is quoted.
• RATE_DATE — The effective date of the quoted spot rate.
• BID_RATE_AGAINST_USD — The bid side of the spot quote expressed against the US dollar.
• SPREAD_AGAINST_USD — The spread applied to the rate against USD.
• OFFER_RATE_AGAINST_USD — The offer (ask) side of the spot quote against USD.
• USD_BASE_CURR_BID_RATE — The bid rate expressed on a USD-base convention.
• USD_BASE_CURR_OFFER_RATE — The offer rate expressed on a USD-base convention.
• HCE_RATE — The rate used in high-context or alternate-rate reporting contexts.
• SEQ_NO — Sequence number supporting ordering and multi-row rate sets.
• ARCHIVE_DATE / ARCHIVE_BY — Audit columns identifying when and by whom a rate row was archived.
• UNIQUE_PERIOD_ID — The identifier that links the rate row to its originating period within the treasury archiving model. This is the column most frequently used to isolate a specific historical or period-scoped rate set.

Common Use Cases and Queries

Typical usage includes feeding spot rates into revaluation, reporting on historical rate sets by period, and validating rate maintenance. To retrieve the current spot rates for a currency as of a date:

• SELECT currency, rate_date, bid_rate_against_usd, offer_rate_against_usd FROM xtr_spot_rates_v WHERE currency = :p_currency AND rate_date = :p_rate_date;
• SELECT currency, rate_date, unique_period_id FROM xtr_spot_rates_v WHERE unique_period_id = :p_unique_period_id ORDER BY currency, rate_date;
• SELECT currency, rate_date, archive_date, archive_by FROM xtr_spot_rates_v WHERE archive_date IS NULL ORDER BY currency, rate_date;

The third query exploits the archive columns to isolate live, non-archived rate rows, while the second demonstrates the period-scoped access pattern implied by UNIQUE_PERIOD_ID. Because the view is a direct projection, standard tuning guidance applies: filter on CURRENCY and RATE_DATE where possible and avoid unbounded full scans of the view in high-volume interfaces.