ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Important wf-tables-simplifying-oracle-e-business-suite

•
•
M
mgarg82

This document lists and describes important tables used in Oracle E-Business Suite workflows. The tables store information about workflow roles, users, activities, notifications, messages, items, attributes, statuses, and transitions. Key tables include WF_USER_ROLES, which stores associations between users and roles; WF_ACTIVITIES, which stores definitions of workflow activities like processes and notifications; and WF_ITEMS, which is the runtime table for workflow processes and stores information about each work item.

1 of 2
Downloaded 15 times
8/4/2014 Important WF tables |Simplifying Oracle E Business Suite http://mandeeporacle.blogspot.in/2014/07/important-wf-tables.html 1/2 Monday, July 21, 2014 Important WF tables WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle . WF_USER_ROLES stores associations of users with the roles of which they are members. WF_ROLES stores Roles, which can have one or more users as members. WF_LOCAL_ROLES stores role information, including a user flag to mark those roles that also represent individual users. This table contains columns similar to those required in the WF_USERS and WF_ROLES views. WF_LOCAL_USER_ROLES stores information about the associations of users with roles. This table contains columns similar to those required in the WF_USER_ROLES view. WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. A process activity is a modeled workflow process, which can be included as an activity in other processes to represent a sub process. A notification activity sends a message to a performer. A functions activity performs an automated function that is written as a PL/SQL stored procedure. A folder activity is not part of a process, it provides a means of grouping activities. WF_ACTIVITY_ATTRIBUTES table defines attributes which behave as parameters for an activity. Activity attributes are only used by function activities.Examples of valid attribute types are DATE, DOCUMENT, FORM, ITEMATTR, LOOKUP, and VARCHAR2. WF_NOTIFICATIONS holds the runtime information about a specific instance of a sent message. A new row is created in the table each time a message is sent. WF_NOTIFICATION_ATTRIBUTES holds rows created for attributes of a notification. When each new notification is created, a notification attribute row is created for each message attribute in the message definition. Initially, the values of the notification attributes are set to the default values specified in the message attribute definition. WF_MESSAGES contains the definitions of messages which may be sent out as notifications. WF_MESSAGE_ATTRIBUTES contains message attribute definitions. WF_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system. WF_ITEM_TYPES: defines an item that is transitioning through a workflow process. WF_ITEM_ATTRIBUTES table stores definitions of attributes associated with a process. Each row includes the sequence in which the attribute is used as well as the format of the attribute data. WF_ITEM_ACTIVITY_STATUSES is the runtime table for a work item. Each row includes the start and end date, result code, and any error information an activity generates. WF_ITEM_ACTIVITY_STATUSES_H stores the history of the WF_ITEM_ACTIVITY_STATUSES table. WF_PROCESS_ACTIVITIES stores the data for an activity within a specific process. WF_ACTIVITY_TRANSITIONS defines the transitions from one activity to another in a process. Each row
8/4/2014 Important WF tables |Simplifying Oracle E Business Suite http://mandeeporacle.blogspot.in/2014/07/important-wf-tables.html 2/2 includes the activities at the beginning and end of the transition, as well as the result code and physical location of the transition in the process window. WF_ACTIVITY_ATTR_VALUES contains the data for the activity attributes. Each row includes the process activity id and the associated value for the attribute. Thanks Mandeep

More Related Content

Important wf-tables-simplifying-oracle-e-business-suite

  • 1. 8/4/2014 Important WF tables |Simplifying Oracle E Business Suite http://mandeeporacle.blogspot.in/2014/07/important-wf-tables.html 1/2 Monday, July 21, 2014 Important WF tables WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle . WF_USER_ROLES stores associations of users with the roles of which they are members. WF_ROLES stores Roles, which can have one or more users as members. WF_LOCAL_ROLES stores role information, including a user flag to mark those roles that also represent individual users. This table contains columns similar to those required in the WF_USERS and WF_ROLES views. WF_LOCAL_USER_ROLES stores information about the associations of users with roles. This table contains columns similar to those required in the WF_USER_ROLES view. WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. A process activity is a modeled workflow process, which can be included as an activity in other processes to represent a sub process. A notification activity sends a message to a performer. A functions activity performs an automated function that is written as a PL/SQL stored procedure. A folder activity is not part of a process, it provides a means of grouping activities. WF_ACTIVITY_ATTRIBUTES table defines attributes which behave as parameters for an activity. Activity attributes are only used by function activities.Examples of valid attribute types are DATE, DOCUMENT, FORM, ITEMATTR, LOOKUP, and VARCHAR2. WF_NOTIFICATIONS holds the runtime information about a specific instance of a sent message. A new row is created in the table each time a message is sent. WF_NOTIFICATION_ATTRIBUTES holds rows created for attributes of a notification. When each new notification is created, a notification attribute row is created for each message attribute in the message definition. Initially, the values of the notification attributes are set to the default values specified in the message attribute definition. WF_MESSAGES contains the definitions of messages which may be sent out as notifications. WF_MESSAGE_ATTRIBUTES contains message attribute definitions. WF_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system. WF_ITEM_TYPES: defines an item that is transitioning through a workflow process. WF_ITEM_ATTRIBUTES table stores definitions of attributes associated with a process. Each row includes the sequence in which the attribute is used as well as the format of the attribute data. WF_ITEM_ACTIVITY_STATUSES is the runtime table for a work item. Each row includes the start and end date, result code, and any error information an activity generates. WF_ITEM_ACTIVITY_STATUSES_H stores the history of the WF_ITEM_ACTIVITY_STATUSES table. WF_PROCESS_ACTIVITIES stores the data for an activity within a specific process. WF_ACTIVITY_TRANSITIONS defines the transitions from one activity to another in a process. Each row
  • 2. 8/4/2014 Important WF tables |Simplifying Oracle E Business Suite http://mandeeporacle.blogspot.in/2014/07/important-wf-tables.html 2/2 includes the activities at the beginning and end of the transition, as well as the result code and physical location of the transition in the process window. WF_ACTIVITY_ATTR_VALUES contains the data for the activity attributes. Each row includes the process activity id and the associated value for the attribute. Thanks Mandeep