This content has been marked as final. Show 6 replies
You cannot assign multiple roles separated by commas to the notification recipient. You need to assign the users/role to a single role and specify the same.1 person found this helpful
The workflow code treats the specified value as a single user/role.
You can at runtime also add the other recipient to the original group and remove it afterwards. Or you can also modify your workflow process and add another notification activity for the other recipient.1 person found this helpful
I have resolved the issue by creating an adhoc role and assigned the user from the original role along with the additional recipient to the adhoc role.
Now i'm able to send the notification to both the end-users as requested.
As per the advise i have incorporated the logic to create an adhoc-role to which i assign the two users who are to recieve the notification.
But when i test run the workflow, the notification is assigned the performer the value of the adhoc-role i created.
But only one user receives the notification. But when i check the wf_notifications table the status = 'CLOSED' and Mail_Status = 'SENT'.
I have checked the mail preference as well the e-mail setup for both the users. Everything is setup as it should be.
Please advise as to what else could be wrong with the adhoc-role solution to my issue.
The following is the logic through which i create an adhoc-role,
Any help is much appreciated !!
wf_directory.createadhocrole(role_name,role_display_name); wf_directory.adduserstoadhocrole(user_name1); wf_directory.adduserstoadhocrole(user_name2);
Edited by: vishm8 on Dec 7, 2012 6:07 PM
looks like 'user_name2' is overriding the 'user_name1'.1 person found this helpful
The following is the way to add multiple users to a adhoc role
l_users varchar2(100):='user_name1 user_name2' ;
role_name => 'TESTROLE1',
role_users => l_users
role_name --> ad hoc role name for which users has to be added
role_users --> individual user names to be added to the role separated with space.
In Workflow builder check the Notification properties. Ensure the check box Expand Roles is checked.