My Oracle Support Banner

AS-OF-DATE EIR COMPUTATION Batch Failed 'ORA-06512: at "OFSAAATM.FN_COMPUTE_EIR' Error (Doc ID 3079438.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Financial Services Loan Loss Forecasting and Provisioning - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

AS-OF-DATE CAHFLOW GENERATION AND EIR COMPUTATION batch failed with below error.

LOG FILE
-----------------------
Filename = FSI_LLFP_DT_LOG_MESSAGES

fn_gather_stats ERROR Stats gathered for table FCT_IFRS_STAGE_DETERMINATION successfully
fn_compute_eir ERROR Exception occurred while executing fn_Compute_EIR with ERROR - ORA-06512: at "OFSAAATM.FN_COMPUTE_EIR", line 269

fn_compute_eir DEBUG fn_Compute_EIR initiated with parameters. 1) p_sys_id=-99999 2) p_start_date=20240430 3) p_table_name=FSI_D_LOAN_CONTRACTS 4) p_slice_id=25 5) p_flag=AD 6) log_level=0

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.