Thursday, September 19, 2019

Forms Login Fails With ORA-06508: PL/SQL: Could Not Find Program Unit Being Called: "APPS.FND_GLOBAL"

Error occured while opening of any forms


Issue
-----
Main Login to EBS works Ok, but Launching Forms fail with FND_GLOBAL related errors.

APP-FND-01926: The customer event WHEN-LOGON-CHANGED raised unhandled exception: ORA-04068: existing state of packages () has been discarded
ORA-04065: not executed, altered or dropped stored procedure "APPS.FND_GLOBAL"
ORA-06508: PL/SQL: could not find program unit being called:"APPS.FND_GLOBAL"
ORA-06512: at "APPS.JG_ZZ_SHARED_PKG", line 433

or:
ERROR:[fnd.common.ErrorStack]:java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "APPS.FND_GLOBAL"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_GLOBAL"
ORA-06512: at line 1

Cause -

This is not an issue with the 10.1.2 Oracle Forms. The error suggest that Database objects are invalid or are out of sync.
 

Solution -

Invalidate all the objects and then Recompile all the objects as documented below:

a) set database parameter _disable_fast_validate=TRUE in init.ora file and restart the DB.

b) Invalidate all the objects by running: $ORACLE_HOME/rdbms/admin/utlirp.sql
Note: This step is NOT advisable in a Production environment, as it may invalidate all the User Connections.

c) Recompile all the objects by running: $ORACLE_HOME/rdbms/admin/utlrp.sql

d) Remove the parameter _disable_fast_validate=TRUE and bounce the DB again.
e) After restarting the db, retest the issue.


Reference - Doc ID 1598314.1

No comments: