Retry Errored Workflow Activities in Oracle EBS

You can retry all errored activities for the specific 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.

You can get the list of Errored WF activities : (where conditions change as per the need)

Eg :
—
SQL> SELECT wf_act.begin_date,wf_act.*
FROM apps.WF_ITEM_ACTIVITY_STATUSES wf_act
WHERE ITEM_TYPE = ‘IEXSTRY’
–AND ITEM_KEY = 29224782; –:strategy_id
AND ACTIVITY_STATUS = ‘ERROR’
AND ACTIVITY_RESULT_CODE = ‘#EXCEPTION’
and trunc(begin_date) > to_date(’01-APR-2020′, ‘DD-MON-YYYY’ )
and error_stack like ‘%resource busy and acquire with NOWAIT specified or timeout expired in Package IEX_strategy_work_items%’;

Then make a note of Failed WF activities from the above SQL and run the below Concurrent Program to retry them: “Retry Errored Workflow Activities“