My Oracle Support Banner

Workflow does not Trigger WF_STANDARD.INITIALIZEERRORS to Notify Administrator Upon Error (Doc ID 2782943.1)

Last updated on SEPTEMBER 27, 2022

Applies to:

Oracle Engineering - Version 12.2.4 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.4 version, ECO


This issue is specific to the ECO_APP workflow. (engwkfwb.pls)

When this workflow enters into an error state, it triggers the WFERROR process, but it does not initiate a notification to the administrator. This notification process needs to be incorporated into the workflow per the below details.

It has to be added specifically to that workflow, it's not an automatic part of the WFERROR child process. From what we can determine, this is not a function which was delivered by that product team on the engwkfwb.pls.

This workflow calls 'WFERROR/ENG_ERROR_PROCESS' which is specific to ECO; in order to include a notification to the admin, there must be a call to the 'Initialize Error' Function Activity.

The Initialize Error activity calls a PL/SQL procedure named WF_STANDARD.INITIALIZEERRORS. This procedure determines if the item type of the errored process has an item type attribute defined with an internal name of WF_ADMINISTRATOR. If it does, it sets the performer of the subsequent notification activity, Notify Administrator, to the role stored in WF_ADMINISTRATOR. If it does not, the subsequent notification activity remains set to the default performer, SYSADMIN.

The Notify Administrator activity sends the Default Retry Error message to a performer (either SYSADMIN or whatever role is stored in your item type's WF_ADMINISTRATOR item attribute). The message indicates that an error has occurred in the specified process and that a response is needed.

According to the ECO workflow code, they're not using the wf_standard.initializeerrors function, they're using PROCEDURE Set_Eco_Approval_Error and that's why it's not creating that de


When the ECO_APP workflow enters WFERROR state that it sends a notification to the administrator. Currently this seeded workflow does not call the correct procedure to perform this notification.

The issue can be reproduced at will with the following steps:
1. Submit WF: ECO_APP workflow. (engwkfwb.pls)

  a. Navigate: Engineering > ECOs > ECOs
  b. Create a new ECO and use a Change Type and Priority that uses an approval workflow.
  c. Enter an approval list name and save.
  d. Submit the ECO for processing by clicking the Submit button.
  e. Navigate: Engineering > ECOs > Notification
  f.  Locate and open the notification,
  g. Review the status details to see that it has failed with Status=Error.

2. When there is an error in ECO workflow... no one gets notice.

    This workflow calls 'WFERROR/ENG_ERROR_PROCESS' which is specific to ECO; in order to include a notification to the admin, there must be a call to the 'Initialize Error' Function Activity.





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

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