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
TheCE_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
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:- Cash Management APIs: The
CE_INTEREST_CALC_PKG
package populates and processes data in this table during interest runs. - General Ledger: Final interest amounts are transferred via
CE_ACCOUNTING_PKG
to create GL journals. - 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
andCALCULATION_PERIOD
optimize large-scale interest runs. - Purging: As a GTT, data is automatically purged per the
ON COMMIT PRESERVE ROWS
orON 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
-
APPS.CE_INTEREST_CALC dependencies on CE_INT_CALC_DETAILS_GT
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on CE_INT_CALC_DETAILS_GT
12.2.2
-
APPS.CE_INTEREST_CALC SQL Statements
12.1.1
-
SYNONYM: APPS.CE_INT_CALC_DETAILS_GT
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CE_INT_CALC_DETAILS_GT, status:VALID,
-
APPS.CE_INTEREST_CALC SQL Statements
12.2.2
-
SYNONYM: APPS.CE_INT_CALC_DETAILS_GT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CE_INT_CALC_DETAILS_GT, status:VALID,
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_BAL_RANGES
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_BAL_RANGES
12.2.2
-
APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCOUNTS
12.2.2
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_SCHEDULES
12.1.1
-
TABLE: CE.CE_INT_CALC_DETAILS_GT
12.2.2
owner:CE, object_type:TABLE, object_name:CE_INT_CALC_DETAILS_GT, status:VALID,
-
APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCOUNTS
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_SCHEDULES
12.2.2
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_RATES
12.2.2
-
PACKAGE BODY: APPS.CE_INTEREST_CALC
12.1.1
-
PACKAGE BODY: APPS.CE_INTEREST_CALC
12.2.2
-
TABLE: CE.CE_INT_CALC_DETAILS_GT
12.1.1
owner:CE, object_type:TABLE, object_name:CE_INT_CALC_DETAILS_GT, status:VALID,
-
APPS.CE_INTEREST_CALC dependencies on CEP_STANDARD
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on STANDARD
12.2.2
-
APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_RATES
12.1.1
-
PACKAGE BODY: APPS.CE_INTEREST_CALC
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CE_INTEREST_CALC, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
PACKAGE BODY: APPS.CE_INTEREST_CALC
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CE_INTEREST_CALC, status:VALID,
-
APPS.CE_INTEREST_CALC dependencies on STANDARD
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on CEP_STANDARD
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCT_BALANCES
12.1.1
-
APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCT_BALANCES
12.2.2
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1