My Oracle Support Banner

IIA EP RI - Claims Data Not Updated - Fn_iia_ins_cf_loader Failed But Batch Shows Successful (Doc ID 3070180.1)

Last updated on FEBRUARY 06, 2025

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

On: 8.1.2.6.1.0 version OFS_IIA

Reinsurance settlement Calculation implemented in setup. They noticed Claim Payments empty in the report Detailed Report of Reinsurance Settlement Reports,on debugging and understood that FSI_RI_SETTLEMENT_GROUP_CFS table is not getting updated with claim information because merge query in the task Reinsurance Settlement Cash flow Data Loader(fn_iia_ins_cf_loader) is failing.

Please find the below FSI_IIA_DT_LOG_MESSAGES.log error.

LOG FILE
-----------------------
Filename = FSI_IIA_DT_LOG_MESSAGES.log
See the following error:

Stage-6 error in putting ri settlemet group paid claims cf data of BOTH to FSI_RI_SETTLEMENT_CLAIMS_CFS on 20240131 ORA-30926: unable to get a stable set of rows in the source tables

Changes

 No Changes.

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
Changes
Cause
Solution


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