Search Results xtr_interest_rate_bands




Overview
Explore in AI Chat

Overview

The XTR_INTEREST_RATE_BANDS table is a core data object within the Oracle E-Business Suite (EBS) Treasury module (XTR). It serves as the system of record for defining tiered or banded interest rate structures, which are essential for sophisticated treasury and cash management operations. These structures allow financial instruments, such as deposits or loans, to have interest rates that vary based on the principal amount or balance falling within specific monetary ranges. The table's role is to store the detailed configuration of these interest rate policies, enabling the accurate calculation of interest income or expense in accordance with complex, multi-tiered contractual agreements.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and foreign key relationship indicate the type of critical data it contains. Based on standard treasury implementations, the table typically stores attributes for each defined band within a policy. This includes a link to a master currency via the CURRENCY column, which is a foreign key to XTR_MASTER_CURRENCIES. Other expected columns would define the band's lower and upper monetary limits (e.g., FROM_AMOUNT, TO_AMOUNT), the applicable interest rate for amounts within that band (e.g., INTEREST_RATE), and a link to a parent policy or product definition. It also stores control information such as effective dates and sequence numbers to order the bands correctly for evaluation.

Common Use Cases and Queries

A primary use case is the automated interest calculation for corporate sweep accounts or structured deposits, where different portions of a balance earn different rates. Treasury analysts may query this table to audit or report on active rate policies. A common reporting query would join the table to currency and policy header tables to list all bands for a specific product. For calculation purposes, a typical SQL pattern finds the applicable rate band for a given transaction amount and currency, often using a BETWEEN clause on the amount columns. For example: SELECT INTEREST_RATE FROM XTR_INTEREST_RATE_BANDS WHERE CURRENCY = 'USD' AND :transaction_amount BETWEEN FROM_AMOUNT AND TO_AMOUNT AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE; This supports core treasury processes like interest accrual and forecasting.

Related Objects

The table maintains a documented foreign key relationship, establishing its integration within the XTR schema's data model. The specific relationship is:

  • Foreign Key to XTR_MASTER_CURRENCIES: The XTR_INTEREST_RATE_BANDS.CURRENCY column references the XTR_MASTER_CURRENCIES table. This ensures that all interest rate bands are defined for a valid, system-maintained currency, enforcing data integrity for multi-currency operations. The table is also inherently related to other treasury objects, such as interest rate policy headers (likely a table like XTR_INTEREST_POLICIES) and transaction tables that apply these banded rates, though these are not explicitly detailed in the provided metadata.