Results for “currency_first”

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

Overview

XTR_R_CURRENCY_CROSS_RATES_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Treasury (XTR) module. It exposes currency cross-rate information maintained by Treasury, presenting currency pair quotations expressed as a bid rate and an offer rate on a given rate date. The view is documented as VALID in the EBS 12.1.1 / 12.2.2 data dictionary, and its definition is a straightforward projection over the base currency cross-rates table, carrying both the live rate attributes and the archival audit columns ARCHIVE_DATE and ARCHIVE_BY.

Because it is a view rather than a table, no data is physically stored in it; every query executes against the underlying base object at runtime. This makes the view a stable, read-only interface that isolates consumers from the physical layout of the base table while guaranteeing that any row-level changes recorded against the base object are immediately visible through the view. The presence of ARCHIVE_BY is significant: users searching on this column are typically performing archival audits—determining who retired or superseded a particular set of cross-rate rows and when.

Underlying Base Objects

The view is defined over a single base object, XTR_R_CURRENCY_CROSS_RATES, which is exposed through a synonym. The documented view text is a direct, unmodified column list:

• SELECT RATE_DATE, CURRENCY_FIRST, CURRENCY_SECOND, BID_RATE, OFFER_RATE, ARCHIVE_DATE, ARCHIVE_BY FROM XTR_R_CURRENCY_CROSS_RATES

No joins, aggregations, filters, or calculated expressions appear in the definition. This one-to-one relationship means the view is functionally equivalent to the base table for read purposes, and the row count returned by the view always matches the base table. The base table stores the master cross-rate records for currency pairs used by Treasury for revaluation, hedging, and reporting calculations, and it carries the standard EBS archival audit columns so that historical or superseded rates can be distinguished from current rates.

Key Columns

The view exposes seven columns, each inherited unchanged from the base table:

• RATE_DATE — The effective date for which the currency pair quotation applies. Treasury cross-rates are date-versioned, so this column is integral to selecting the correct rate for a transaction or valuation date.
• CURRENCY_FIRST — The base (first) currency of the pair.
• CURRENCY_SECOND — The quote (second) currency of the pair. Together with CURRENCY_FIRST, this defines the unique currency pair.
• BID_RATE — The rate at which the market buys the first currency against the second; used as the buying-side reference rate.
• OFFER_RATE — The rate at which the market sells the first currency against the second; used as the selling-side reference rate.
• ARCHIVE_DATE — The date on which the row was archived or superseded. A null value typically indicates an active, non-archived record.
• ARCHIVE_BY — The user or process identifier responsible for archiving the row. This is the column most commonly targeted in audit-oriented searches such as "archive_by."

Common Use Cases and Queries

The view supports Treasury reporting, rate maintenance validation, and archival auditing. Typical scenarios include retrieving the current cross-rate for a currency pair on a specific date, and identifying which user archived a set of rates. The following queries illustrate standard usage:

• Current rates for a pair: SELECT rate_date, currency_first, currency_second, bid_rate, offer_rate FROM xtr_r_currency_cross_rates_v WHERE currency_first = 'USD' AND currency_second = 'EUR' AND rate_date = :p_rate_date;
• Audit of archiving activity: SELECT rate_date, currency_first, currency_second, archive_date, archive_by FROM xtr_r_currency_cross_rates_v WHERE archive_by = :p_user AND archive_date BETWEEN :p_from AND :p_to;
• Identification of active versus archived rows: SELECT currency_first, currency_second, rate_date, archive_date, archive_by FROM xtr_r_currency_cross_rates_v WHERE archive_date IS NULL ORDER BY currency_first, currency_second, rate_date;

Because the view performs no filtering of its own, archive-related predicates must be applied explicitly by the calling report or concurrent program. Reports and integrations that must exclude retired rates should therefore include an ARCHIVE_DATE IS NULL or equivalent predicate, while reconciliation reports should query the archived rows deliberately using ARCHIVE_BY and ARCHIVE_DATE.