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.
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:
(203105) Oracle drv_oci error:
OCI Function:  - oexec(), oexn()
SQL Function:  - 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms