Search Results xtr_rm_md_curve_rates




Overview
Explore in AI Chat

Overview

The XTR_RM_MD_CURVE_RATES table is a core data structure within the Oracle E-Business Suite Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It functions as the detailed repository for the individual market data points that collectively define a financial curve. In treasury and risk management, curves—such as yield curves, forward rate curves, or volatility curves—are fundamental for valuation, simulation, and risk analysis. This table stores the granular rate data that populates these curves, enabling the system to perform complex financial calculations for instruments like bonds, swaps, and options. Its existence is critical for the Risk Management (RM) and Market Data (MD) components, providing the underlying numerical data upon which treasury analytics depend.

Key Information Stored

The table's structure is designed to link a specific rate to a specific curve. The primary key is a composite of CURVE_CODE and RATE_CODE, ensuring each rate is uniquely associated with a curve. The CURVE_CODE column is a foreign key that identifies the parent market data curve defined in the XTR_RM_MD_CURVES table. The RATE_CODE column is a foreign key that references a specific market price or rate stored in the XTR_MARKET_PRICES table. While the provided metadata does not list additional columns, typical implementations of such a junction table would include attributes like effective date, term or tenor (e.g., 1M, 1Y), and potentially a sequence number to order the points along the curve. The table essentially acts as a mapping mechanism, defining which market rates belong to which constructed curve.

Common Use Cases and Queries

The primary use case is the retrieval of all data points for a given curve to construct it for valuation engines or reports. Treasury analysts and risk managers query this table to audit curve composition, verify rate inputs, and troubleshoot valuation outputs. A common reporting need is to list all curves that utilize a particular market rate, which is vital for impact analysis when a source rate is updated. Sample SQL patterns include fetching the complete set of rates for a curve or joining to obtain descriptive information.

  • To retrieve all rate codes for a specific curve: SELECT RATE_CODE FROM XTR_RM_MD_CURVE_RATES WHERE CURVE_CODE = 'USD-LIBOR-3M';
  • To list curves containing a specific market rate: SELECT CURVE_CODE FROM XTR_RM_MD_CURVE_RATES WHERE RATE_CODE = 'LIBOR-1Y';
  • To join with the market prices table for a full curve view: SELECT cr.CURVE_CODE, cr.RATE_CODE, mp.RATE FROM XTR_RM_MD_CURVE_RATES cr, XTR_MARKET_PRICES mp WHERE cr.RATE_CODE = mp.RATE_CODE AND cr.CURVE_CODE = 'EUR-SWAP';

Related Objects

This table is centrally linked within the Treasury market data model. Its two defined foreign keys create essential dependencies. The XTR_RM_MD_CURVES table is the parent, containing the master definition (name, type, currency) of the curve referenced by CURVE_CODE. The XTR_MARKET_PRICES table is the source for the actual numerical rate values referenced by RATE_CODE. This table is therefore a junction between curve definitions and the raw market data. It is likely referenced by various treasury valuation engines, risk calculation packages, and reporting views within the XTR module that consume constructed curves for financial processing.