Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sending Multiple Notifications Using Ad Hoc Roles

SparxAug 13 2008 — edited Sep 12 2008
Hi
I have created a workflow and i need to send a FYA notification to multiple people. I have created one role using wf_directory.createadhocrole API and I am adding users to this role dynamically in the PLSQL program. The users are based on a manager group hierarchy related to the person who is triggering the workflow. I am using wf_directory.RemoveUsersFromAdHocRole API to remove users initially and using wf_directory.AddUsersToAdHocRole API to add all the users belonging to the respective group.

My question is, since i am using only one role to send the multiple notifications, there can be instances where multiple people can trigger the same workflow at the same time(item key is taken care to be unique everytime) and members of the role are added and removed based on the group. Is workflow gonna take care of sending the notifications to the right group of members?? Will the sharing of the Role can create issue and notifications are sent to irrelevant group of people?? If yes then what is the workaround for this?? Please help me..

Regards,
Norman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2008
Added on Aug 13 2008
3 comments
2,214 views