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