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
Symptoms
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:
SQL> select corr_id, msg_state, count(*) from applsys.aq$wf_deferred group by corr_id, msg_state;
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
Changes
Generally this kind of issues occurs after a new clone was performed from Production, but it may occur from various other reasons.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms