Search Results xtr_rm_md_curves




Overview
Explore in AI Chat

Overview

The XTR_RM_MD_CURVES table is a core data repository within the Oracle E-Business Suite (EBS) Treasury (XTR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for market data curves, which are fundamental constructs in financial risk management and valuation. A curve, such as a yield curve or a forward rate curve, represents the relationship between interest rates and different maturities for a given currency or currency pair. This table stores the essential attributes and metadata that define each curve, enabling the system to correctly apply market data for pricing financial instruments, calculating fair values, performing sensitivity analysis, and assessing market risk exposures. Its role is central to the market data management subsystem of Oracle Treasury.

Key Information Stored

The table's primary function is to define curve characteristics. Its structure, inferred from the provided metadata, includes key columns that categorize and describe each curve. The CURVE_CODE column acts as the unique identifier (Primary Key) for each curve definition. The table maintains foreign key relationships to the XTR_MASTER_CURRENCIES table via two critical columns: CCY and CONTRA_CCY. This indicates the table supports curves for single currencies (e.g., USD yield curve) and for currency pairs (e.g., USD/EUR forward points curve). Additional columns, while not explicitly listed in the excerpt, typically store attributes such as curve type (e.g., Zero Coupon, Par, Forward), day count convention, interpolation method, compounding frequency, and the source or provider of the market data.

Common Use Cases and Queries

This table is primarily accessed for curve setup, maintenance, and reference in risk and valuation processes. A common operational use case is the creation and validation of a new curve during market data configuration. For reporting and analysis, queries often join this table with the XTR_RM_MD_CURVE_RATES table to retrieve the full term structure. A typical query pattern would be: SELECT c.curve_code, c.ccy, r.tenor, r.rate FROM xtr_rm_md_curves c, xtr_rm_md_curve_rates r WHERE c.curve_code = r.curve_code AND c.ccy = 'USD' ORDER BY r.tenor; This retrieves all tenors and rates for USD-denominated curves. The table is also crucial for batch processes that run mark-to-market valuation or Value-at-Risk (VaR) calculations, where the correct curve definition must be sourced for each instrument.

Related Objects

The XTR_RM_MD_CURVES table has defined relationships with several other key Treasury tables, forming the backbone of the market data model.

  • XTR_MASTER_CURRENCIES (Foreign Key): Joined via XTR_RM_MD_CURVES.CCY and XTR_RM_MD_CURVES.CONTRA_CCY to validate and describe the primary and contra currencies for the curve.
  • XTR_RM_MD_CURVE_RATES (Primary Key Reference): The child table where the actual rate values for specific tenors are stored, linked by XTR_RM_MD_CURVE_RATES.CURVE_CODE.
  • XTR_RM_MD_SET_CURVES (Primary Key Reference): Likely a mapping table that groups individual curves into logical sets for scenario analysis or reporting, linked by XTR_RM_MD_SET_CURVES.CURVE_CODE.
These relationships ensure data integrity and enable complex financial analyses across the Treasury module.