My Oracle Support Banner

Populate Reporting Tables Batch Fails with ORA-00904: "N_RI_MA_LIC_REL_CURR_PERD": invalid identifier error. (Doc ID 3062528.1)

Last updated on DECEMBER 12, 2024

Applies to:

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

Symptoms

#INFODOM#_POPULATE_RPT_TBLS batch failed after adding new rep line in DIM_INS_ACST_REP_LINE table in order to be able to display a non-existent output in the Disclosure reports. Issue occurring even after removing the custom line item.

Filename = FSI_IIA_DT_LOG_MESSAGES
See the following error:

EXEC_COMPONENT MSG_SEVERITY LOG_MESSAGE
pr_drilldown_dim_load DEBUG Completed DIM_INS_ACST_TEMPLATE_VAR Merge,Committing Now
dt_iia_populate_rpt_tbls DEBUG Executed PR_DRILLDOWN_DIM_LOAD: 203129 and fic_mis_date 20221231:ret_val:1
pr_fct_rep_drilldown_load DEBUG Started Insurance Reporting Line Procedure 203129 and fic_mis_date 20221231
pr_fct_rep_drilldown_load DEBUG Removing Partial Load -0
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 5 F_TRANS_FLAG:: N
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 5 COMPLETED VARIABLES TABLE REFRESH::
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 5 COMPLETED ANALYSIS OF TABLES::
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 6 PROJECTION_INDEX::0::V_CHILD_LIAB_ID::203129
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 7Insurance Reporting Line:Template Id->203042Projection Index->0Template Flag->NONTRANSITIONf_trans_flag->N
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 7 FINALLY LV_CALC_TEMPLATE_ID:: 203042CSM_METHOD_FINALLY::3
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 8Started Insurance Reporting Line Normal Load 203129 and fic_mis_date 20221231V_TABLE_NAME::FCT_IFRS_COHORT_OUTPUT
pr_fct_rep_drilldown_load DEBUG LOG_NUM :: 197Started Insurance Reporting Line Profit And Loss Load 203129 and fic_mis_date 20221231
pr_fct_rep_drilldown_load ERROR LOG_NUM :: 204 ERR:: ORA-00904: "N_RI_MA_LIC_REL_CURR_PERD": invalid identifier
dt_iia_populate_rpt_tbls DEBUG Executed PR_FCT_REP_DRILLDOWN_LOAD: 203129 and fic_mis_date 20221231:ret_val:0
pr_drilldown_dim_load DEBUG Started DIM_INS_ACST_VARIABLES Merge
pr_drilldown_dim_load DEBUG Completed DIM_INS_ACST_VARIABLES Merge
pr_drilldown_dim_load DEBUG Starting DIM_INS_ACST_TEMPLATE_VAR Merge

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.