How to Manually Process the Events from Workflow Queues When The Deferred Agent Listener Won't Start
Last updated on MAY 08, 2017
Applies to:Oracle Workflow Cartridge - Version 11.5.9 to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 27-JUL-2013
The Workflow Agent Listener goes down with 10 consecutive errors due to the unwanted / corrupted events from the queue.
Running the following select shows reflects a large volume of subscriptions on this queue with no correlation id:
The output may resemble:
CORR_ID MSG_STATE COUNT(*)
APPS:oracle.apps.gl.CloseProcess.period.open READY 4
APPS:oracle.apps.ar.transaction.Invoice.complete READY 1
APPS:oracle.apps.ar.batch.AutoInvoice.run READY 2
APPS:oracle.apps.ap.payment READY 33
APPS:oracle.apps.po.rcv.rcvtxn READY 1
APPS READY 729442
Generally this kind of issues occurs after a new clone was performed from Production, but it may occur from various other reasons.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms