Queue APPLSYS.AQ$_WF_CONTROL_E is not enabled for dequeue

While running Workflow Control Queue Cleanup concurrent program completed error

+—————————————————————————+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation.
All rights reserved.
FNDWFBES_CONTROL_QUEUE_CLEANUP module: Workflow Control Queue Cleanup
+—————————————————————————+
Current system time is 30-JUL-2013 16:09:48
+—————————————————————————+
**Starts**30-JUL-2013 16:09:49
ORACLE
error 25226 in FDPSTP
Cause: FDPSTP failed due to ORA-25226: dequeue failed,
queue APPLSYS.AQ$_WF_CONTROL_E is not enabled for dequeue
ORA-06512: at “SYS.DBMS_AQ”,
line 335
ORA-06512: at “APPS.WF_BES_CLEANUP”,
line 117
ORA-06512: at “APPS.WF_BES_C
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
Output file size:
0
Finished executing request completion options.
+—————————————————————————+
Concurrent request completed
Current system time is 30-JUL-2013 16:09:49
+—————————————————————————+

Solution:

To solve the problem, start the queue by connecting to SQL*Plus as the APPS users, then exec:

exec dbms_aqadm.start_queue(queue_name =>’APPLSYS.AQ$_WF_CONTROL_E’ ,dequeue =>
TRUE,enqueue=>FALSE);

Reference: Workflow Control Queue Clean Up Program Fails With ORA-25226 (Doc ID 334237.1)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s