In Oracle workflow we need a role for notification activity.Workflow engine calls the notification system to deliver a notification message to an appropriate role.Once user of that role completes the notification response, the workflow Engine continues to drive through the remaining activities in process
Message -The information sent by notification activity.The message may request the performer (the role receiving the message) to do some work or may simply provide information.
A Role is grouping of one or more user who share the common responsibility.A role can contain more than 1 user.Oracle workflow send notification to roles.
Oracle stores Roles related information in following table & Views.
WF_USERS - contains info. on user
WF_ROLES - contain Info. on roles of whoch user can be member.
WF_USER_ROLES - Have assocation between user with roles.
WF_USER_ROLE_ASSIGNMENTS_V - Tracks assignments of user to roles.
For Oracle Notification to work there should always a Role assign to Performer attribute of the Notification Activity.A performer is a role that can consist of one or more users.You can specify a
1. Static Role2. Dynamic Role
Static Role - It is a constant Value.Specify a Hardcoded Role name.
Dynamic Role - Define an Item Attribute and assign that item attribute to Notification Performaer.At Run time populate the Item attribuet value with ROLE(based on your requirements).
Oracle Workflow has provided standard PL/SQL APIs to create ad Hoc users and Roles ar runtime.
For More Infor on Workflow - refer