Search Results ce_interest_schedules




Overview
Explore in AI Chat

Overview

The CE_INTEREST_SCHEDULES table is a core data repository within the Oracle E-Business Suite Cash Management (CE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master table for defining and storing the parameters of interest rate schedules. These schedules are critical for calculating interest earned or paid on bank accounts managed within the system. The table's primary role is to provide a reusable, centralized definition of interest calculation rules, which can then be associated with one or more bank accounts. This enables automated and consistent interest accrual processing, a fundamental aspect of treasury and cash management operations.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as INTEREST_SCHEDULE_ID, which uniquely identifies each schedule. Based on its functional purpose, the table typically stores attributes that define how interest is calculated. This commonly includes the schedule name, effective dates, the base interest rate, the rate calculation method (e.g., fixed, variable tied to an index), compounding frequency, day count basis (e.g., Actual/360, 30/360), and any applicable minimum or maximum rate boundaries. The structure is designed to support complex, multi-tiered rate schedules that can change over time.

Common Use Cases and Queries

The primary use case is the configuration and maintenance of interest rules for bank accounts. During bank account setup in the CE_BANK_ACCOUNTS table, a user assigns an INTEREST_SCHEDULE_ID to link the account to a predefined schedule. Common reporting and validation queries involve joining these two tables. For instance, to list all bank accounts with their associated interest schedules, a query would be: SELECT cba.bank_account_name, cba.bank_account_num, cis.schedule_name FROM ce_bank_accounts cba, ce_interest_schedules cis WHERE cba.interest_schedule_id = cis.interest_schedule_id;. Another critical use case is during the interest accrual process, where batch programs reference this table to determine the correct rate and calculation rules for each account on a given value date.

Related Objects

The CE_INTEREST_SCHEDULES table has a direct and documented foreign key relationship with the CE_BANK_ACCOUNTS table, which is central to the Cash Management module. The relationship is defined as follows:

  • Primary Table: CE_INTEREST_SCHEDULES
  • Related Table: CE_BANK_ACCOUNTS
  • Join Column: CE_BANK_ACCOUNTS.INTEREST_SCHEDULE_ID references CE_INTEREST_SCHEDULES.INTEREST_SCHEDULE_ID
This relationship enforces referential integrity, ensuring a bank account cannot be linked to a non-existent interest schedule. The CE_BANK_ACCOUNTS table is the primary consumer of data from CE_INTEREST_SCHEDULES. Other related objects may include concurrent programs for interest calculation and associated interface or summary tables used in the accrual process, though these are not explicitly detailed in the provided metadata.