Search Results xtr_rm_md_set_curves_pk

Overview

The XTR_RM_MD_SET_CURVES table is a core data structure within the Oracle E-Business Suite Treasury (XTR) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction or intersection table, defining the many-to-many relationship between market data sets and market data curves. Its primary role is to manage the composition of market data sets by storing the specific curves that are included within each defined set. This enables the Treasury application to group related financial curves—such as interest rate or foreign exchange curves—into logical sets for streamlined market data management, validation, and application in pricing and risk calculations.

Key Information Stored

The table's structure is intentionally simple, consisting of two key columns that form its composite primary key. The SET_CODE column stores the unique identifier for a market data set, as defined in the parent XTR_RM_MD_SETS table. The CURVE_CODE column stores the unique identifier for a specific market data curve, as defined in the parent XTR_RM_MD_CURVES table. Each record in this table represents a single membership link, explicitly stating that a particular curve (CURVE_CODE) is a constituent part of a specific market data set (SET_CODE). The integrity of this relationship is enforced by the primary key constraint, XTR_RM_MD_SET_CURVES_PK, which prevents duplicate curve assignments within the same set.

Common Use Cases and Queries

A primary use case is the validation and reporting of curve set compositions. Treasury analysts and system administrators query this table to audit which curves are assigned to operational sets, ensuring data completeness before running critical processes like portfolio valuation or Value at Risk (VaR) simulations. Common SQL patterns include listing all curves within a specific set or identifying all sets that contain a particular curve. For example, to retrieve all curve codes for a market data set named 'CORP_VAL_SET', a typical query would join to the XTR_RM_MD_SETS table: SELECT sc.curve_code FROM xtr_rm_md_set_curves sc, xtr_rm_md_sets s WHERE sc.set_code = s.set_code AND s.set_name = 'CORP_VAL_SET';. This table is also central to the application logic that fetches the complete set of market data required for processing a group of treasury transactions.

Related Objects

The XTR_RM_MD_SET_CURVES table maintains strict referential integrity with two key parent tables via foreign key constraints, as documented in the ETRM metadata. It is a direct child of the XTR_RM_MD_SETS table, joined on the SET_CODE column. This relationship ensures every curve set assignment corresponds to a valid, defined market data set. Similarly, it is a child of the XTR_RM_MD_CURVES table, joined on the CURVE_CODE column, guaranteeing that every assigned curve is a valid, defined curve in the system. These relationships are fundamental; the table has no meaning independent of these parent entities, serving purely to define their association.