ORA-04068 Errors When Attempting To Login To OFSA After Upgrading to RDBMS 10G

(Doc ID 748741.1)

Last updated on OCTOBER 30, 2012

Applies to:

Oracle Financial Data Manager - Version 4.5.38 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5

Checked for relevance on 30-Oct-2012.

Symptoms

After an upgrade in database from 9i to 10g, when attempting to login to OFSA using a non database owner id, the following error occurs:

ERROR
(203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "PUBLIC.DBMS_SQL"
ORA-06508: PL/SQL: could not find program unit being called: "PUBLIC.DBMS_SQL"
ORA-06512: at "STAR.OFSA_AUTHENTICATE", line 18
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: declare begin ofsa_authenticate.EnableRole('C_JAV1WXQV$5TO2BHY2N33UWDD_FR7'); end;

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Attempt to login to OFSA after upgrade to 10g using a non database owner id

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