Search Results xtr_interest_rate_policy




Overview
Explore in AI Chat

Overview

The XTR_INTEREST_RATE_POLICY table is a core data object within the Oracle E-Business Suite (EBS) Treasury module (XTR). It serves as a master repository for defining and managing interest rate policies, which are fundamental to the automated calculation of interest for various treasury instruments and cash positions. Its primary role is to establish the rules linking specific currencies and investment categories to defined interest rate curves or specific rates, thereby enabling systematic and policy-driven interest accruals and valuations across the treasury portfolio. This table is critical for ensuring that interest-related financial operations adhere to the organization's configured treasury management policies in both EBS 12.1.1 and 12.2.2.

Key Information Stored

While the full column list is not detailed in the provided metadata, the table's description and foreign key relationship explicitly define its core data elements. The table stores policy records that are uniquely identified by a combination of currency and an investment category. A key column is CURRENCY, which has a foreign key relationship to XTR_MASTER_CURRENCIES, ensuring referential integrity. Another critical column would define the INVESTMENT_CATEGORY or a similar descriptor to classify the type of instrument or cash pool. Each record then associates this currency-category pair with a specific interest rate policy, which likely references an interest rate curve identifier, a benchmark rate code, or a fixed rate, along with applicable spreads, calculation methods, and reset frequencies.

Common Use Cases and Queries

This table is central to interest rate configuration and inquiry processes. A common use case is during the setup of a new treasury product or the definition of a cash pool, where the system references this table to determine the applicable interest rate for accruals. For reporting and analysis, treasury analysts may query this table to review or audit the interest policies applied across different currencies and portfolios. A typical SQL query would join this table to currency and interest rate master tables to produce a comprehensive policy listing.

  • Policy Review Query: SELECT policy.currency, mc.name, policy.investment_category, policy.rate_code FROM xtr_interest_rate_policy policy, xtr_master_currencies mc WHERE policy.currency = mc.currency_code ORDER BY 1, 3;
  • Instrument Valuation: Back-end processes for daily mark-to-market or accrual calculations will read the policy from this table based on an instrument's currency and type to fetch the correct rate for computation.

Related Objects

The primary documented relationship for XTR_INTEREST_RATE_POLICY is with the XTR_MASTER_CURRENCIES table via the CURRENCY column. This table is also intrinsically linked to other core Treasury tables. It is almost certainly referenced by transaction tables (e.g., XTR_DEALS, XTR_CASH_POSITIONS) that store instruments requiring interest calculation. Furthermore, it will have dependencies on tables storing interest rate curves (such as XTR_RATE_CURVES) or benchmark rate definitions. Views like XTR_INTEREST_RATE_POLICY_VL may exist to provide a translatable version of the data for forms and reports.