Search Results ce_int_calc_details_gt




The CE.CE_INT_CALC_DETAILS_GT table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a global temporary table utilized by the Cash Management module for interest calculation processing. This table serves as a transient storage mechanism during the execution of interest computation routines, ensuring data isolation between concurrent sessions while maintaining transactional integrity. Below is a detailed technical breakdown of its purpose, structure, and functional context within Oracle EBS.

Purpose and Functional Context

The CE_INT_CALC_DETAILS_GT table is primarily used during the execution of the Calculate Interest program (CEINTEREST) in Cash Management. This program computes interest for bank accounts, loans, or investments based on predefined interest rules, balance tiers, and calculation methods. The temporary table stores intermediate results during interest computation, such as:
  • Account balances segmented by calculation periods
  • Applicable interest rates and tiered rate adjustments
  • Accrued interest amounts before final posting
As a global temporary table (GTT), its data persists only for the duration of a session or transaction, preventing contention in multi-user environments.

Table Structure

While the exact columns may vary slightly between EBS 12.1.1 and 12.2.2, the table typically includes the following key attributes:
Column Name Data Type Description
INTEREST_CALC_DETAIL_ID NUMBER Unique identifier for each interest calculation record
BANK_ACCOUNT_ID NUMBER References CE_BANK_ACCOUNTS for the account being processed
CALCULATION_PERIOD DATE Time frame for which interest is calculated
AVERAGE_BALANCE NUMBER Computed average balance used for tiered rate calculations
INTEREST_RATE NUMBER Effective interest rate applied (may be tier-specific)
ACCRUED_INTEREST NUMBER Calculated interest amount before journal creation
STATUS VARCHAR2 Indicates processing state (e.g., 'PENDING', 'POSTED')

Integration Points

The table interacts with several key components of Oracle EBS:
  1. Cash Management APIs: The CE_INTEREST_CALC_PKG package populates and processes data in this table during interest runs.
  2. General Ledger: Final interest amounts are transferred via CE_ACCOUNTING_PKG to create GL journals.
  3. Concurrent Processing: The CEINTEREST program leverages this table for mid-process storage without committing to permanent tables.

Technical Considerations

  • Performance: Indexes on BANK_ACCOUNT_ID and CALCULATION_PERIOD optimize large-scale interest runs.
  • Purging: As a GTT, data is automatically purged per the ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS clause definition.
  • Customization: Extensions to interest logic may require joining this table with custom PL/SQL logic.

Version-Specific Notes

In EBS 12.2.2, enhancements to the interest calculation engine may introduce additional columns for:
  • Multi-currency support
  • Tax-aware interest computations
  • Audit trail attributes for compliance