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 laterInformation 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 |