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 -
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
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.
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:
Post a Comment