How to handle or reassign System : Error (WFERROR) Notifications that default to SYSADMIN (Doc ID 1448095.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Workflow - Version 11.5 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 01-MAR-2014

Symptoms

Large volumes of Error (WFERROR) notifications are piling up in the WF_NOTIFICATIONS table.

Changes

Oracle Applications E*Buisiness Suite uses Oracle Workflow embedded in the Applications.
Any time there is a problem or error within a Workflow process, a Workflow Error item (WFERROR) is generated as a child process to inform the Workflow Administrator about correcting the error in order to continue the original workflow's process.
System errors can also generate a Workflow Error (WFERROR) which do not belong to a parent workflow but requires the Workflow System Administrator's attention.
All workflow error notifications (WFERROR) are hard-coded to be sent to SYSADMIN and need to be responded to and handled. 

Failure to manage these SYSADMIN error notifications by responding to and closing these notifications will make associated workflow items ineligible for purging, and so Workflow runtime tables will continue grow.

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