Search Results xtr_interest_rate_ranges




Overview
Explore in AI Chat

Overview

The XTR_INTEREST_RATE_RANGES table is a core data structure within the Oracle E-Business Suite Treasury (XTR) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for storing detailed interest rate information associated with bank accounts. Its primary role is to facilitate the management and calculation of interest for both external bank accounts and internal intercompany funding arrangements. By defining rate ranges or tiers, this table enables the application of different interest rates based on specified balance thresholds, supporting complex interest accrual and forecasting processes essential for corporate treasury operations.

Key Information Stored

The table stores configuration that links bank accounts to their applicable interest rates. Based on the provided metadata and standard XTR schema knowledge, critical columns include a foreign key to the bank account (such as BANK_ACCT_USE_ID linking to CE_BANK_ACCT_USES_ALL) and identifiers for the associated party and reference code (PARTY_CODE, REF_CODE) linking to XTR_BANK_ACCOUNTS. The table's core data would typically encompass columns for defining balance ranges (e.g., minimum and maximum balance thresholds), the corresponding interest rate for each range, the rate type (fixed or variable), and the basis for interest calculation. Effective and expiry dates are also standard to manage the lifecycle of rate agreements.

Common Use Cases and Queries

The primary use case is the automated accrual and forecasting of interest income or expense for treasury bank accounts. Treasury analysts use this data to generate cash flow forecasts and analyze the cost of funds. A common reporting query involves joining this table to bank account master tables to list all active rate schedules. For example:

  • Retrieving all rate tiers for a specific bank account: SELECT * FROM XTR_INTEREST_RATE_RANGES WHERE BANK_ACCT_USE_ID = <ID> ORDER BY effective_date, range_min_balance;
  • Forecasting interest for a given balance: A more complex query would join this table, apply the correct rate tier based on a projected balance, and calculate the periodic interest amount.

Data from this table is integral to the Treasury module's interest simulation and accrual batch processes.

Related Objects

As indicated by the foreign key metadata, XTR_INTEREST_RATE_RANGES has direct relationships with key treasury and cash management tables. The primary foreign key relationship is with CE_BANK_ACCT_USES_ALL, which is the Cash Management table storing bank account usage assignments. This link associates the interest rate schedule with a specific usage of a bank account within Oracle EBS. A second foreign key relationship exists with XTR_BANK_ACCOUNTS via the composite key of PARTY_CODE and REF_CODE, anchoring the rate data to the core Treasury bank account definition. Consequently, this table is a critical junction between the Cash Management infrastructure (CE) and the specialized Treasury (XTR) interest calculation engine.