My Oracle Support Banner

IIA_CALCULATION Batch Fails (Doc ID 2914653.1)

Last updated on DECEMBER 15, 2022

Applies to:

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

Symptoms

In IAA 8.1.2.1.1, when running IIA_CALCULATION batch, task DT_IIA_FCT_POPULATION is failing with the error
LOG_NUM :: 12 ERR:: ORA-00904: "N_RLA_ACT_CLM_EXP_REP_PRD_PV": invalid identifier
N_RLA_ACT_CLM_EXP_REP_PRD_PV is a custom column added in tables FSI_INS_GROUP_INPUT_DETAIL and FCT_INS_ACSTVAL_DIRGROUP_DTLS thru data model change.
A variable is created with the name N_RLA_ACT_CLM_EXP_REP_PRD_PV and it is used in Calculation preferences.

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


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