ORA-00942, ORA-04068 & ORA-04063 on OFSA_DUP_MAIN When Running Generate_upgrade (Doc ID 303383.1)

Last updated on AUGUST 26, 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

When running generate_upgrade.sql, you receive the following errors in the resulting generate_upgrade.log file:

Errors for PACKAGE BODY OFSA_DUP_MAIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2452/19 PL/SQL: SQL Statement ignored
2453/43 PL/SQL: ORA-00942: table or view does not exist
2517/16 PL/SQL: SQL Statement ignored
2518/40 PL/SQL: ORA-00942: table or view does not exist
2571/13 PL/SQL: SQL Statement ignored
2572/37 PL/SQL: ORA-00942: table or view does not exist

and

BEGIN ofsa_dup.Process; END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "owner.OFSA_DUP_MAIN" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "owner.OFSA_DUP", line 40
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