How To Retry Multiple Errored Approval Workflow Processes After A Fix Or Patch Has Been Implemented

In this Document

APPLIES TO:

GOAL

In some cases there are multiple documents for which the workflow process has failed. After root cause is identified and the issue is fixed, how to retry all the failed processes at the same time?

SOLUTION

From Oracle Applications Manager:

1. Login as the System Administrator and choose the 'Workflow Manager' under the Workflow: Oracle Applications Manager menu.

2. Click on Work Items under Throughput

3. Look to the upper right hand corner of the screen, and choose the value 'Errored Work Items' in the list of values for 'View'.  Click on the 'Go' button.

4.  Filter using the value of 'PO%' and the Contains clause - as seen below.

5. Click on the Item Type that is in question.

It is also possible to select the Work Item Type and choose 'View Details'.

6. Click on the failed activity i.e. VERIFY_APPROVAL_AUTHORITY. 

What is being seen - is the various activities which have errors - in the various workflow processes for the POAPPRV workflow (pictured above).

7. Click on Retry All button.

Notes: Depending on the amount of failed activities, this action may take some time.

For 11.5.9,  FND.G should be applied.

Using Retry Errored Workflow Activities concurrent program:

This program is included in 11i.ATG_PF.H.delta.6 (RUP 6) and onwards. Use the Retry Errored Workflow Activities (FNDWFRET) concurrent program to retry activities with a status of ERROR for a particular item type. You can retry all errored activities for that item type, or you can choose to retry only activities for a particular work item of that item type, activities for a particular process within the item type, or instances of a particular activity node within the item type. You can also choose to retry only activities that encountered errors during a particular range of dates.

Login as system administrator and use the standard request submission form to run this program, specifying the following parameters.

Item Type - Select the item type to which the activities to retry belong. i.e PO Approval

Item Key - Optionally, to retry only activities that belong to a particular work item, select the item key that identifies that work item within the item type. The list of values includes only item keys for work items that have activities with a status of ERROR.

Process Name - Optionally, to retry only activities that belong to a particular process within the specified item type, select the process name. The list of values includes only processes that have activities with a status of ERROR.

Activity Label - Optionally, to retry only instances of a particular activity node, select the label name of that activity node. The list of values includes only activity nodes that have instances with a status of ERROR.

Errored On or After - Optionally specify the earliest error date for the activities to retry.

Errored On or Before - Optionally specify the latest error date for the activities to retry. If you previously retried an activity and that attempt still encountered an error, then the error date for the activity is the date when it was most recently retried, rather than the date of the original error.

Maximum Retries - Optionally specify the maximum number of times that the Retry Errored Workflow Activities program can retry a particular activity. For example, if you schedule this program as a recurring request, then you can set this parameter to limit automatic retries for activities that may need manual intervention to resolve the errors. The highest value you can specify for this parameter is 99. The default value is 5.

Perform Commit - Optionally select Yes or No to indicate whether to commit data while retrying activities. If you want the program to commit data as it retries activities to reduce rollback size and improve performance, select Yes. If you do not want to perform automatic commits, select No. The default value is Yes.

For more information, reference Note 431219.1 Oracle Workflow Documentation Updates for 11i.ATG_PF.H.delta.6 (RUP 6)

REFERENCES