Resetting the Workflow for Purchase Order

-- ---------------------------------------------------------------------------------
-- Purpose : Steps to restart/reset the Purchase order workflow.
-- Date      : 20.May.2009
-- Created by : Chaitanya
-- .....
-- ---------------------------------------------------------------------------------


If any Standard Purchase Order got strucked in the Workflow if we need to reset it then follow the process below.

Setps:

1. SELECT ph.segment1 PO_Num,
ph.ORG_ID,
ph.TYPE_LOOKUP_CODE PO_TYPE,
ph.authorization_status,
ph.WF_ITEM_KEY,
ph.WF_ITEM_TYPE
from po_headers_all ph
where ph.segment1 = '225343' -- PO Number
and ph.TYPE_LOOKUP_CODE = 'STANDARD';

2. Download the file poxrespo.sql and run the script in the instance where the purchase order got strucked.

3. The workflow will be resetted after the script execution and user can try re-approving the order now.

Suggestion: Make sure that workflow background process is running and scheduled.

If you have any doubts follow the Oracle note.id: 390023.1

=====================================================