How Oracle Workflow Acquires Information About a Role

How Oracle Workflow Acquires Information About a Role,AskHareesh Blog for Oracle Apps

 

How Oracle Workflow Acquires Information About a Role

In Oracle Workflow a role is a user or a group of users. Oracle Workflow gets information about a role from the following three views:
  • WF_USERS
  • WF_ROLES
  • WF_USER_ROLES

WF_USERS
The WF_USERS view contains information about every user who can receive notifications and responses in Oracle Workflow. The below table shows all of the columns in the WF_USERS view.

Column
Description
Name
The internal name of the user. This column must be all
uppercase and contain no spaces. This is the column that
the Workflow Engine will refer to for the user name.
Display_name
The display name of the user.
Description
The description of the user.
Notification_preference
This is the column that identifies the notification preference
of the user. Valid values are MAILTEXT, MAILHTML, QUERY,
or SUMMARY. When the value is set to MAILTEXT, the user
receives notifications and responses by email. When the
value is set to MAILHTML, the user receives notifications
and responses through HTML email attachments. When the
value is set to QUERY, the user receives notifications and
responses from the Notifications Web page or Notification
Viewer form. The Notification Viewer form is only available
to Oracle Applications users. When the value is set to
SUMMARY, the user receives emails that contain summaries
of all notifications.
Language
The language to use for notification features that are
language dependent
Territory
The territory to determine the date formatting and numeric
formatting.
E-mail_address
The email address of the user.
Fax
The fax number of the user.
Orig_system
This column identifies the original system where the user
resides.
Orig_system_ID
This column identifies the unique identifier for the user in
the original system where the user resides.
Status
The status of the user. Valid statuses are ACTIVE for
active users, EXTLEAVE for extended leave, INACTIVE for
inactive users, and TMPLEAVE for temporary leave.


WF_ROLES
The WF_ROLES view contains information about every role in Oracle Workflow that can receive notifications and responses. Each user in WF_USERS must be a role in WF_ROLES. If the attributes of the role are different than the attributes of the users within the role, the attributes of the role will override the attributes of the user. The below table shows all of the columns in WF_ROLES.

Column
Description
Name
The internal name of the role. This column must be all
uppercase and contain no spaces. This is the column that
the Workflow Engine will refer to for the role name.
Display_name
The display name of the role.
Description
The description of the role.
Notification_preference
This is the column that identifies the notification preference
of this role. Valid values are MAILTEXT, MAILHTML, QUERY,
or SUMMARY. When the value is set to MAILTEXT, the user
receives notifications and responses by email. When the
value is set to MAILHTML, the user receives notifications
and responses through HTML email attachments. When the
value is set to QUERY, the user receives notifications and
responses from the Notifications Web page or Notification
Viewer form. The Notification Viewer form is only available
to Oracle Applications users. When the value is set to
SUMMARY, the user receives emails that contain summaries
of all notifications.
Language
The language to use for notification features that are
language dependent.
Territory
The territory determines the formatting of dates and
numbers.
E-mail_address
The email address of the role, most likely a mail distribution
list. You use the email address of the role if you choose not
to expand the role into its users.
Fax
The fax number of the role.
Orig_system
This column identifies the original system where the role
resides.
Orig_system_ID
This column identifies the unique identifier for the role in
the original system where the role resides.

WF_USER_ROLES
In Oracle Workflow, WF_USER_ROLES is the view that resolves the many-to-many relationship between users and roles. One role can contain many users, and one user can belong to many roles. The below table shows all of the columns in the WF_USER_ROLES view.
Column
Description
User_name
The internal name of the user.
User_orig_system
The original system where the user resides. Use this
and User_orig_sytem_ID to join to WF_USERS.
User_orig_system_ID
The unique identifier for the user in the original system
where the user resides. Use this and the
User_orig_system to join to WF_USERS.
Role_name
The internal name of the role.
Role_orig_system
The original system where the role resides. Use this and
the ROLE_ORIG_SYSTEM_ID to join to WF_ROLES.
Role_orig_system_ID
The unique identifier for the role in the original system
where the role resides. Use this and the
ROLE_ORIG_SYSTEM_ID to join to WF_ROLES.


*/