Results for “usd_quoted_spot”

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

Overview

XTR_A_MASTER_CURRENCIES_V is an APPS-owned view within the Oracle EBS Treasury (XTR) product family, shipped in release 12.1.1 and 12.2.2 with a status of VALID. It presents the currency master records used by Treasury to govern how each currency is quoted, valued, and rounded throughout the module's deal, exposure, and limit processing. In practice, the view serves as the reporting and integration layer over the currency setup data, exposing the same column set as its underlying base object so that external reports, interfaces, and custom extensions can read currency definitions without referencing the base table directly.

The view is particularly relevant to users searching for rounding_factor, since that column is one of the principal configuration attributes it exposes. ROUNDING_FACTOR defines the precision to which Treasury rounds calculated amounts for the given currency, and is applied alongside the quotation method and year basis during interest and foreign exchange computations.

Underlying Base Objects

The view is defined over a single documented base object, XTR_A_MASTER_CURRENCIES, which is referenced as a synonym from the APPS schema. The view text performs a straight projection of columns from that base object, with no joins, unions, or aggregation; it is a one-to-one presentation layer rather than a transformed data set. Consequently, any row visible in the view corresponds directly to a row in the master currencies table, and DML against the view is governed by the usual updatable-view rules for a simple projection.

Key Columns

• CURRENCY — the currency code identifying each master record.
• NAME — the descriptive name of the currency.
• AUTHORISED — indicates whether the currency is enabled for use in Treasury transactions.
• DIVIDE_OR_MULTIPLY — the quotation convention indicating whether rates are applied by division or multiplication.
• YEAR_BASIS and IG_YEAR_BASIS — day-count conventions used in interest and interest-guarantee calculations.
• ROUNDING_FACTOR — the rounding precision applied to computed amounts in this currency.
• MINIMUM_BAND and MAXIMUM_BAND — allowable rate bands for validation.
• IR_SEQ_NO and FX_SEQ_NO — sequence numbers controlling interest rate and FX rate derivation.
• NET_FX_EXPOSURE, MAX_DAYS_CONTRACT, CALCULATE_HOLS_YEARS — exposure and contract-duration controls.
• CURRENT_SPOT_RATE, HCE_RATE, USD_QUOTED_SPOT, SPOT_DATE, USD_BASE_CURR_BID_RATE, USD_BASE_CURR_OFFER_RATE, RATE_DATE — stored rate and date information used in valuation.
• UTILISED_AMOUNT — accumulated utilisation against the currency record.
• Audit columns: CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, AUDIT_INDICATOR, AUDIT_DATE_STORED.

Common Use Cases and Queries

Typical usages include validating currency setup before deal entry, reporting authorised currencies and their rounding and quotation conventions, and extracting rate and exposure attributes for reconciliation or data warehousing. A representative query retrieving rounding and quotation settings for authorised currencies is shown below.

• SELECT currency, name, rounding_factor, divide_or_multiply, year_basis FROM xtr_a_master_currencies_v WHERE authorised = 'Y';
• SELECT currency, current_spot_rate, spot_date FROM xtr_a_master_currencies_v WHERE currency = 'EUR';
• SELECT currency, minimum_band, maximum_band, net_fx_exposure FROM xtr_a_master_currencies_v ORDER BY currency;

Because the view mirrors the base object, queries should filter on AUTHORISED where only active currencies are required, and join to CURRENCY codes in deal or exposure tables for cross-module reporting.