Search Results ce_interest_bal_ranges




Overview
Explore in AI Chat

Overview

CE_INTEREST_BAL_RANGES is a Cash Management (CE) configuration table in Oracle EBS 12.1.1 and 12.2.2 that stores interest balance range information. It defines the tiered balance bands used by Oracle Cash Management's interest calculation engine when computing interest on bank account balances. Each row represents one balance tier (a "from" and "to" amount pair) belonging to a particular interest schedule, allowing interest rates to vary according to the balance level held in an account.

From a Data Vault modeling perspective, the metadata's heuristic classification of this object is standalone. This suggests it is best modeled as a self-contained reference or configuration entity rather than as a hub, link, or satellite. It has no downstream dependencies within a Data Vault sense other than the parent interest schedule to which it belongs.

Key Information Stored

The table contains 10 documented columns. The most significant are:

The FROM/TO boundary columns are the operative business attributes, since they define how balances are bucketed for rate assignment. The BALANCE_RANGE_ID is purely a surrogate; the natural key is effectively the combination of INTEREST_SCHEDULE_ID with the balance boundaries.

Common Use Cases and Queries

The primary use case is reviewing and maintaining the tiered balance structure attached to interest schedules. A typical query joins the ranges to their parent schedule:

  • Listing all balance ranges for a given schedule: SELECT balance_range_id, from_balance_amount, to_balance_amount FROM ce_interest_bal_ranges WHERE interest_schedule_id = :schedule_id ORDER BY from_balance_amount;
  • Determining which band a specific balance falls into: SELECT * FROM ce_interest_bal_ranges WHERE interest_schedule_id = :id AND :balance BETWEEN from_balance_amount AND to_balance_amount;
  • Auditing configuration changes: filtering on LAST_UPDATE_DATE to identify recently modified tiers.

Because the table is configuration-oriented, it is frequently used in reconciliation and setup-verification reports that confirm tiered interest schedules are correctly defined before interest calculation runs.

Related Objects

The following objects are most significant in relation to CE_INTEREST_BAL_RANGES, based on the documented foreign-key relationships:

  • CE_INTEREST_SCHEDULES — Parent table. Joined on CE_INTEREST_BAL_RANGES.INTEREST_SCHEDULE_ID = CE_INTEREST_SCHEDULES.INTEREST_SCHEDULE_ID.
  • CE_INTEREST_RATES — Child table. Joined on CE_INTEREST_RATES.BALANCE_RANGE_ID = CE_INTEREST_BAL_RANGES.BALANCE_RANGE_ID. Each rate applies the appropriate percentage to the corresponding balance band defined here.

Together these three tables form the core configuration triplet for tiered interest calculation in Oracle Cash Management, with CE_INTEREST_BAL_RANGES providing the banding that bridges schedules and their rates.