This content has been marked as final. Show 6 replies
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'.
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.