My Oracle Support Banner

How To Troubleshoot When Email Notification Responses Are Processed But The Approval Workflow Still Shows In Process (Doc ID 458665.1)

Last updated on NOVEMBER 21, 2018

Applies to:

Oracle Workflow - Version 11.5.10.2 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

Purpose

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.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Workflow Information Center, Diagnostics, & Community
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.