My Oracle Support Banner

How to delegate or reassign [(WFERROR) "System : Error"] Error Notifications that default to SYSADMIN (Doc ID 1448095.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Workflow - Version 11.5 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
 

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

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
Symptoms
Changes
Cause
Solution
References

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