Search Results ce_interest_calc




Overview
Explore in AI Chat

Overview

The APPS.CE_INTEREST_CALC package body is a core component of the Oracle E-Business Suite Cash Management module, specifically supporting the computation of interest on bank account and cash pool balances. Its principal business function is to calculate interest earned or accrued on internal and external bank accounts based on configured interest schedules, tiered balance ranges, and negotiated interest rates. The package is responsible for evaluating the balances held in one or more accounts over a defined period and applying the applicable interest rate structure to derive an interest amount. It is typically used by organizations that perform internal interest allocation across subsidiaries or divisions, or that need to reconcile interest calculated by banks against internally maintained schedules.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, each supporting a distinct step in the interest calculation lifecycle.

  • ROUNDUP — Applies the rounding rules defined for interest calculations, ensuring computed amounts conform to configured precision.
  • GET_INTEREST_RATE — Retrieves the applicable interest rate for a given account, schedule, and period from the configured rate structures.
  • DELETE_SCHEDULE_ACCOUNT — Removes an account from an interest schedule, allowing schedule membership to be maintained without affecting historical calculations.
  • GET_BALANCE_INFO — Obtains the account balance information required for interest computation over the relevant period.
  • GET_BALANCE_POOL_INFO — Gathers balance information across the accounts comprising a cash pool.
  • GET_INTEREST_INFO — Collects the interest configuration details for a standard (non-pool) account.
  • GET_INTEREST_POOL_INFO — Collects the interest configuration details applicable to a cash pool.
  • SET_END_DATE — Establishes the effective end date for the interest calculation window.
  • SET_INT_RATE — Assigns or overrides the interest rate used in the calculation.
  • SET_RANGE_AND_RATE — Applies tiered balance ranges and their associated rates, supporting graduated interest computation.
  • CALCULATE_INTEREST — The primary driver that orchestrates the calculation process and produces the interest amount.
  • INT_CAL_DETAIL_MAIN — Populates the detail records for the interest calculation results.
  • INT_CAL_XTR — Extracts calculation output, typically for downstream reporting or posting.

Tables Accessed

The package reads from and writes to several Cash Management tables through APPS synonyms.

Usage Notes

CE_INTEREST_CALC is invoked primarily through Cash Management's interest calculation functionality, including the concurrent program that processes periodic interest computations for eligible accounts and cash pools. It may also be called from Oracle Forms subroutines or from custom PL/SQL code extending interest reporting. The package relies on FND_PROFILE and FND_MESSAGE/FND_MSG_PUB for profile option resolution and error messaging, and on CE_BAL_UTIL and CEP_STANDARD for shared balance and utility logic. Per ETRM metadata, it is referenced by three other database packages and does not itself depend on external callers beyond those documented dependencies.