NTF_DEFER_RESP_PROCESS_ERROR is the internal name of the Error Process for Notification Response Processing. The purpose of this error handling process is to:
send a notification to the workflow administrator specified in the Workflow Configuration page when an error occurs during deferred notification response processing
provide information to the workflow administrator about the error
allow the workflow administrator to retry the notification processing or resolve the problem that caused the error to occur
For more information about deferred notification response processing and the workflow administrator role, see: Setting Global User Preferences.
Error Process for Notification Response Processing Diagram
The Receive Errored Queue Message activity receives an event message that has encountered an error during subscription processing. In the Error Process for Notification Response Processing, this event is usually the oracle.apps.wf.notification.wl.response.message event. The activity stores the event name, event key, and the complete event message in item type attributes.
The Initialize Error Information (Defer Notification Response) activity calls a PL/SQL procedure named WF_STANDARD.INITIALIZEERRORINFO. This procedure stores details about the original notification that encountered an error in item type attributes. The procedure also sets the value of the Error Notification Recipient Role item type attribute to the workflow administrator role specified in the Workflow Configuration page. See: Setting Global User Preferences.
Note: If the workflow administrator value is set to an asterisk (*), meaning that all users and roles have workflow administrator privileges, then the WF_STANDARD.INITIALIZEERRORINFO procedure sets the Error Notification Recipient Role item type attribute to the SYSADMIN role instead. Note that this workflow administrator setting is suggested for development environments only and is not recommended in production environments for security reasons.
The Error Notification for Notification Response Processing activity sends the Default Response Processing Error Message to the workflow administrator role specified in the Error Notification Recipient Role item type attribute. The message indicates that an error occurred while processing a notification response and provides details about the original notification, the responder, and the error. The message also includes a link to the definition of the event subscription that performs the deferred notification response processing. The response options and their resulting actions are:
Retry - executes the Retry Event activity to enqueue the notification response event message back onto the WF_NOTIFICATION_IN queue, and ends the error process. The workflow administrator can attempt to correct the error before re-enqueuing the event.
Resolved - ends the error process because the workflow administrator addressed the error in the notification response processing directly through some external means.
The subject and body of the Default Response Processing Error Message are as follows:
Subject: Error occurred while processing notification response from &RESPONDER_DISP_NAME for ID - &NOTIFICATION_ID Body: An Error occurred in the following Workflow. &NEWLINE_ATTR Errorred Notification Details WF_NOTIFICATION(ATTRS,NOTIFICATION_ID,SUBJECT,MESSAGE_TYPE,MESSAGE_NAME,RECIPIENT,RECIPIENT_DISP_NAME,RESPONDER,RESPONDER_DISP_NAME) Error Details WF_NOTIFICATION(ATTRS,ERROR_NAME,ERROR_MESSAGE,ERROR_STACK) &EVENT_SUBSCRIPTION to see the event subscription definition that processes notification responses in the background. &NEWLINE_ATTR
The Default Response Processing Error Message has the special #HIDE_MOREINFO message attribute defined to hide the Request Information button in the Notification Details page and exclude the Request Information response link from HTML-formatted e-mail notifications. See: #HIDE_MOREINFO Attribute.
The Retry Event function activity executes the PL/SQL procedure WF_STANDARD.RETRYEVENT to retry the notification response processing by re-enqueueing the oracle.apps.wf.notification.wl.response.message event message onto the WF_NOTIFICATION_IN queue.