My Oracle Support Banner

SQL Execution failed while Upgrading OIDF 8.1.1.0.0 (Doc ID 2870852.1)

Last updated on MAY 24, 2022

Applies to:

Oracle Insurance Data Foundation - Version 8.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading OIDF from 8.1.0.1.0 to 8.1.1.0.0, getting following error message for table/view does not exist along with invalid identifier. There are 26 similar errors in total.

[29-04-22 05:55:49,701 EST AM] [INFO ] Executing file :/u01/ofsaa/shared/ofsaa8/installerScripts/OFS_OIDF/scripts/atomic/insert/scd-993-dim_physical_activity-stg_physical_activity_master.sql
[29-04-22 05:55:49,705 EST AM] [ERROR] Query:CALL FSI_CREATE_SEQUENCE('SEQ_DIM_PHYSICAL_ACTIVITY','DIM_PHYSICAL_ACTIVITY','N_PHYSICAL_ACTIVITY_SKEY')...
  Error:ORA-00942: table or view does not exist
ORA-06512: at "ATOMIC.FSI_CREATE_SEQUENCE", line 6

[29-04-22 05:57:07,630 EST AM] [ERROR] Query:UPDATE FCT_COMMON_POLICY_SUMMARY SET N_BUSINESS_SEGMENT_CAT_SKEY= 0 WHERE N_BUSINESS_SEGMENT_CAT_SKEY IS NULL...
  Error:ORA-00904: "N_BUSINESS_SEGMENT_CAT_SKEY": invalid identifier

[29-04-22 05:57:07,634 EST AM] [ERROR] Query:UPDATE FCT_INSURANCE_QUOTES SET N_BUSINESS_SEGMENT_CAT_SKEY= 0 WHERE N_BUSINESS_SEGMENT_CAT_SKEY IS NULL...


In addition, FSI_CREATE_SEQUENCE failed which is getting called from : /installerScripts/OFS_OIDF/scripts/FSI_CREATE_SEQUENCE.xml



Changes

 Upgrading OIDF environment from 8.1.0.1.0 to 8.1.1.0.0 version

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
Changes
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.