Search Results xtr_market_prices




Overview
Explore in AI Chat

Overview

The XTR_MARKET_PRICES table is a core data repository within the Oracle E-Business Suite Treasury (XTR) module. It serves as the central system of record for storing current and historical market rates, which are fundamental for valuing financial instruments and executing treasury operations. Its primary role is to maintain the official market prices for foreign exchange (FX) and money market deals, providing the critical rate data necessary for deal pricing, portfolio revaluation, profit and loss (P&L) calculation, and risk management. As a validated table in both EBS 12.1.1 and 12.2.2, its integrity is enforced by a primary key and it is referenced by several other key treasury tables, underscoring its importance in the financial data architecture.

Key Information Stored

While the provided metadata does not list individual columns, the table's description and foreign key relationships define its core data elements. The primary key, XTR_MARKET_PRICES_PK, is based on the RIC_CODE (Reuters Instrument Code) or a similar unique rate identifier, which acts as the key for retrieving a specific financial rate. Each record logically represents a single market rate for a specific financial instrument or currency pair at a point in time. The table stores the associated rate value (e.g., exchange rate, interest rate) and pertinent metadata such as the rate type, valuation date, and source. The existence of foreign keys from revaluation and curve rate tables indicates it also supports term structure data for different tenors.

Common Use Cases and Queries

The table is primarily accessed for real-time deal processing and periodic financial reporting. A common operational use case is fetching the latest spot FX rate to price a new currency trade. For month-end closing, batch processes query the table to obtain revaluation rates for marking portfolios to market. Typical reporting queries involve joining XTR_MARKET_PRICES with deal tables to analyze P&L against market movements. Sample SQL patterns include selecting the latest rate for a given RIC_CODE or retrieving a time series of rates for historical analysis. The table is also a target for data feeds from external market data providers via the related XTR_MARKET_DATA_INTERFACE table.

Related Objects

  • XTR_MARKET_DATA_INTERFACE: Serves as the staging table for importing market rate data from external sources into XTR_MARKET_PRICES.
  • XTR_REVALUATION_RATES: References this table to obtain the specific market rates used for revaluing treasury positions.
  • XTR_RM_MD_CURVE_RATES: Likely references rate codes to build yield curves for risk management and valuation of interest rate products.
  • XTR_SPOT_RATES: References the table, indicating a relationship for storing and retrieving specific spot foreign exchange rates.