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 Role
2. Dynamic RoleStatic 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
http://eoracleapps.blogspot.com/2008/07/oracle-workflow-concept.html
http://eoracleapps.blogspot.com/2008/07/how-to-customized-oracle-om-worflow.html
what are the APIs to create ad Hoc users and Roles at runtime?
ReplyDeleteHi Apps
ReplyDeletethanks for visiting my blog.Below are the APIs as their description about ho wto create ashoc Users and Roles at Run time.
#1. wf_directory.createAdRole
Creates a role at runtime by creating a value in the
WF_LOCAL_ROLES table with the user flag set to N. This is referred to
as an ad hoc role.
#2. wf_directory.createAdRole2
Creates a role at runtime by creating a value in the
WF_LOCAL_ROLES table with the user flag set to N. This is referred to
as an ad hoc role. CreateAdHocRole2() accepts the list of users who
belong to the role in the WF_DIRECTORY.UserTable format, which lets
you include user names that contain spaces or commas.
#3. CreateAdHocUser
Creates a user at runtime by creating a value in the
WF_LOCAL_ROLES table with the user flag set to Y. This is referred to
as an ad hoc user.