How To Troubleshoot When Email Notification Responses Are Processed But The Approval Workflow Still Shows In Process
(Doc ID 458665.1)
Last updated on MARCH 04, 2021
Applies to:Oracle Workflow - Version 22.214.171.124 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 30-MAR-2013
How To Troubleshoot When Email Notification Responses Are Processed But The Approval Workflow Still Shows In Process?
There are cases where sometimes even though the email responses are processed by Mailer but it does not complete the waiting workflow process. The status of the Approval workflow still shows as "In Process" and the activity history shows that the workflow is pending at the Notification activity to the Approver with a "Notified" status.
The basic flow involved in the Inbound Mailer processing is as follows:
1. Workflow Notification Mailer's inbound thread reads the response e-mail from IMAP inbox. It then parses the content and identifies the notification id using NID string in the response e-mail and it identifies the response it expects. Using this information it parses the e-mail and finds out the response value. Using this information it builds a XML message under event name oracle.apps.wf.notification.receive event and enqueues to WF_NOTIFICATION_IN.
2. Workflow Inbound Notifications Agent Listener listens to WF_NOTIFICATION_IN agent dispatches event oracle.apps.wf.notification.receive that executes WF_XML.RECEIVE rule function. This rule function parses the response XML and applies the response value to the corresponding notification. It then calls WF_NOTIFICATION.Respond that completes the Notification Activity and the complete flow following the Notification Activity till a blocking activity is encountered.
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
|Workflow Information Center, Diagnostics, & Community|