Starting Workflow Generates ORA-04068 Error with Debug Service Manager Stuck Activating
(Doc ID 383096.1)
Last updated on JUNE 14, 2023
Applies to:Oracle Concurrent Processing - Version 11.5.9 to 126.96.36.199 [Release 11.5]
Oracle Workflow - Version 11.5.9 to 188.8.131.52 [Release 11.5 to 11.5.10]
Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
When attempting to start the Workflow Mailer, an error is generated:
java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "APPS.FND_SVC_COMPONENT" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
After checking the services, discover the Debug Service Manager is stuck in Activating.
Review the FNDSMxx.mgr log file and there is an error:
The SQL statement being executed at the time of the error was: begin
FND_CP_GSM_IPC.Cartridge_Init_Service(:h, :p, :d); end; and was executed from the file &ERRFILE.
The call to function StartProcess in cartridge AQCART has failed.
03-AUG-2006 15:19:09 - ORACLE error 25207 in init_service
Cause: init_service failed due to ORA-25207: enqueue failed, queue APPLSYS.FND_CP_GSM_IPC_AQ is
disabled from enqueueing
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 178
ORA-06512: at line 1.
Bounced the database.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document