Getting ORA-00942 Running OFSA DUP Scripts Check.sql & Generate_upgrade.sql (Doc ID 303284.1)

Last updated on OCTOBER 03, 2007

Applies to:

Oracle Financial Services Applications (OFSA) 4.5.2
Oracle Financial Data Manager - Version: 4.5.2
This problem can occur on any platform.

Symptoms

While upgrading to OFSA 4.5.2, you receive the following ORA-00942 errors running the upgrade scripts check.sql and generate_upgrade.sql:

From check.log:

BEGIN ofsa_dup_check.Check_for_Problems; END;

*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "owner.OFSA_DUP_CHECK", line 269
ORA-06512: at "owner.OFSA_DUP_CHECK", line 561
ORA-06512: at "owner.OFSA_DUP_CHECK", line 728
ORA-06512: at line 1

From generate_upgrade.log:

BEGIN ofsa_dup.Process; END;

*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "owner.OFSA_DUP_CHECK", line 269
ORA-06512: at "owner.OFSA_DUP_CHECK", line 561
ORA-06512: at "owner.OFSA_DUP", line 18
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms