Tag: workflow builder

How To Retry or Skip Workflow Oracle E-Business Suite?

Guven Leave a comment

You can retry the workflow with the following script.

View Code 
1
2
3
4
5
6
7
8
9

BEGIN
	wf_engine.handleerror (itemtype	 => 'POAPPRV',
			itemkey 	 => 27013,
			activity	 => 'APPROVE_PO_NEW',
			command 	 => 'RETRY',
			result		 => NULL);
	COMMIT;
END;
/

You can skip the workflow with the following script.

View Code 
1
2
3
4
5
6
7
8
9

BEGIN
	wf_engine.handleerror (itemtype	 => 'POAPPRV',
			itemkey 	 => 27013,
			activity	 => 'APPROVE_PO_NEW',
			command 	 => 'SKIP',
			result		 => NULL);
	COMMIT;
END;
/

How To Cancel Workflow Oracle E-Business Suite?

Guven Leave a comment

You can cancel the workflow with the following script as single or multiple.

View Code 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

DECLARE
   CURSOR aa
   IS
      SELECT item_type, item_key, root_activity
        FROM wf_items wi
       WHERE wi.item_type = :item_type
         AND wi.item_key IN (:item_key1, :item_key2, ...)
         AND wi.end_date IS NULL;
BEGIN
   FOR bb IN aa
   LOOP
      wf_engine.abortprocess(itemtype => bb.item_type, 
                             itemkey => bb.item_key, 
                             process => bb.root_activity);
      COMMIT;
   END LOOP;
END;