How to send notification to multiple users in oracle workflow

How to send notification to multiple users in oracle workflow

In this post , we will be try to do How to send notification to multiple users in oracle workflow. We can easily sent notification to single user in through workflow but to send notification to multiple users is some thing tricky and needs to do some different steps as compared to single user notifications. Here in this post , I will show you some PLSQL code for Workflow Builder package using this we can send Single notifications to N number of Users in the Application. Please find below the steps of How to send notification to multiple users in oracle workflow.

 

Example of How to send notification to multiple users in oracle workflow

In this post , I am not doing every thing from scratch , I will explain only that Part which will be use full to send notification to multiple users in oracle workflow.

 

Suppose we have 4 Users in the Application and We want to Send the Single Notification to all these users at a Same Time.

 

Users Name are below :

 

XX_USER1

XX_USER2

XX_USER3

XX_USER4

 

 

Step1:- First We need to Create the Single Role for all these users to used in the Workflow as below I am creating the Role 'XX_GROUP_USER_ROLE' for that.

 

wf_directory.createadhocrole(role_name               => 'XX_GROUP_USER_ROLE'
                                   ,role_display_name       => 'XX_GROUP_USER_ROLE');

 

Step2:- Once the role will be created then we will be assign these Users to that Role.

 

wf_directory.AddUsersToAdHocRole(role_name => 'XX_GROUP_USER_ROLE'
                                 ,role_users => 'XXUSER1 XXUSER2 XXUSER3 XXUSER4');

 

Step3:- Now in the Last Step we need to Assign the Value of this Role to the Workflow Builder Attribute to be used inside the Workflow Notifications.
                                

wf_engine.setitemattrtext(itemtype => itemtype
                              ,itemkey  => itemkey
                              ,aname    => 'XXSEND_TO_SUPERVISOR'
                              ,avalue   => 'XX_GROUP_USER_ROLE'); 

 

Step4:- Give the values for Notification function as below  

Step 5:- Now Click on Node Tab of the same Notification functions as below.

select performer as below.