Re: Workflow Deferred Agent Listener & Workflow Deferred Notification Agent Listener "ERROR"

Posted by ErmanArslansOracleBlog on Mar 10, 2016; 6:59pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-Deferred-Agent-Listener-Workflow-Deferred-Notification-Agent-Listener-ERROR-tp705p710.html

Check this doc to find out more details, there are lots of bug records in Oracle Support. It is according to the module. For ex, PO workflows have these kinds of bug in 11i.

Tracking Workflow Notification Event Messages (Doc ID 433359.1)
->


If an error occurs during dispatch of oracle.apps.wf.notification.send, the message is enqueued to WF_ERROR queue. The Error Agent Listener dispatches the ERROR subscription for oracle.apps.wf.notification.send that executes WF_XML.Error_Rule.

5. Run $FND_TOP/sql/wfmlrdbg.sql for a notification id and check the status of the message in WF_DEFERRED and WF_NOTIFICATION_OUT queue.

    PROCESSED in WF_DEFERRED - The message is enqueued to WF_NOTIFICATION_OUT

    PROCESSED in WF_NOTIFICATION_OUT - The message is sent as e-mail

    READY in WF_DEFERRED - Check if Deferred Agent Listener is running

    READY in WF_NOTIFICATION_OUT - Check if Notification Mailer is running

6. Analyzing outbound XML message for a notification id. The wfmlrdbg.sql output provides the XML message generated by WF_XML.Generate at the time the script is run. If the original XML message used by the mailer is required to be analyzed following SQL may be used.

    SELECT tab.user_data.text_lob text_lob
    FROM applsys.aq$wf_notification_out tab
    WHERE dbms_lob.instr(tab.user_data.text_lob,'&1') > 0
    /