Search from 700 + Posts

Jun 14, 2009

Role in Oracle WORKFLOW

Role in Oracle Workflow
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 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
http://eoracleapps.blogspot.com/2008/07/oracle-workflow-concept.html

http://eoracleapps.blogspot.com/2008/07/how-to-customized-oracle-om-worflow.html

2 comments:

  1. what are the APIs to create ad Hoc users and Roles at runtime?

    ReplyDelete
  2. Hi Apps

    thanks 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.

    ReplyDelete