My Oracle Support Banner

Reinsurance IIA_CALCULATION Batch Failed, Error MCR_TTL_LOSS_CLS_BAL_UND_CNTR Invalid Identifier (Doc ID 2866524.1)

Last updated on MAY 06, 2022

Applies to:

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


Created a reinsurance run that uses the OOB template: RE-PRO-GMM_FVA_DEFAULT_TEMPLATE. Macro: "Total Loss component Closing Balance Of Underlying Insurance Contracts" is being used in the OOB template in the line item: "Changes In CSM due to Gain Reversal" under CSM.

However, when the IIA_CALCULATION batch triggered, it fails on Task 7: IIA PROSPECTIVE REINSURANCE COMPUTE CSM (DT_IIA_RI_PROP_CSM_Calculation).

From FSI_MESSAGE_LOG(Atomic Schema):

Error occur for the RUN ID 212662 in LOG NUMBER:: 12 and Error:: ORA-00904: "MCR_TTL_LOSS_CLS_BAL_UND_CNTR": invalid identifier
Error occur for the RUN ID 212662 in LOG NUMBER:: 10 and Error:: ORA-00942: table or view does not exist


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

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