Oracle Workflow Notification Expand Roles

If you are sending the Notification to a Role (everyone with the Payables Responsibility) the Expand Roles is very important

  • Checked, this will create a separate Notification to each person in the Role.  If an action is expected every person has an opportunity to act on the Notification
  • Unchecked, this will create a single Notification which is emailled to each person in the Role.  The first person to act on the notification completes (or closes) it.

oracle workflow notification activity

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

You can retry the workflow with the following script.

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.

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?

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

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;