My Oracle Support Banner

Workflow Deferred Agent Listener SYSTEM DEACTIVATED With oracle.apps.fnd.cp.gsc.ProcessorException: Could not executeUpdate() (Doc ID 1379004.1)

Last updated on MAY 19, 2024

Applies to:

Oracle Workflow - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


Trying to start the Workflow Deferred Agent Listener, but it stops on its own and going to a "System Deactivated" state and the Workflow Agent Listener log shows the following error:

1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:xxxx:PROCEDURE:[SVC-GSM-WFALSNRSVC-29260-10002 : oracle.apps.fnd.cp.gsc.SvcComponent.performStopError(Connection, Exception)]:BEGIN (oracle.jdbc.driver.T4CConnection@xxx, oracle.apps.fnd.cp.gsc.ProcessorException: Could not executeUpdate() on begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7 );end; -> java.sql.SQLException: ORA-20002: 3837: An unhandled error '-1086 - ORA-01086: savepoint 'WF_DISPATCH_SAVEPOINT' never established in this session or is invalid
ORA-06512: at "APPS.WF_EVENT", line 2221
ORA-01086: savepoint 'WF_DISPATCH_SAVEPOINT' never established in this session or is invalid
ORA-06550: line 1, column 14:
PLS-00201: identifier 'HZ_EVENT_ELT.HZ_PARAM_DELETE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored' encountered when dispatching event '' with key ''
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1



Implementing Ebiz Release 12.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.