Posted on

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

You can retry the workflow with the following script.

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.

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

How To Cancel Workflow Oracle E-Business Suite?

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

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;