Oracle Workflow Tables

Workflow Definition Tables

WF_ITEM_TYPES
The WF_ITEM_TYPES table defines an item that is transitioning through a workflow process.

WF_ACTIVITIES
WF_ACTIVITIES table stores the definition of an activity.
Activities can be processes, notifications, functions or folders.
A process activity is a modelled 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_MESSAGES
WF_MESSAGES contains the definitions of messages which may be sent out as notifications.

WF_ITEM_ATTRIBUTES
The 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_ACTIVITY_ATTRIBUTES
The WF_ACTIVITY_ATTRIBUTES table defines attributes which behave as parameters for an activity. Activity attributes are only used by function activities. Each row includes the associated activity, type of attribute, and the format used by the activity. Examples of valid attribute types are DATE, DOCUMENT, FORM, ITEMATTR, LOOKUP, and VARCHAR2.

WF_MESSAGE_ATTRIBUTES
WF_MESSAGE_ATTRIBUTES contains message attribute definitions.
Each message may have zero or more message attributes. Message attributes define additional information that is to be sent to, or received from the user. Some attributes are values to be substituted for messages tokens, while other attributes define more complex information.

WF_PROCESS_ACTIVITIES
WF_PROCESS_ACTIVITIES stores the data for an activity within a specific process.

WF_ACTIVITY_TRANSITIONS
The WF_ACTIVITY_TRANSITIONS table defines the transitions from one activity to another in a process. Each row 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.

Workflow Runtime Tables

WF_ITEMS
WF_ITEMS is the runtime table for workflow processes. Each row defines one work item within the system.

WF_ITEM_ACTIVITY_STATUSES
The WF_ITEM_ACTIVITY_STATUSES TABLE 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_NOTIFICATIONS
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_MESSAGES
WF_MESSAGES contains the definitions of messages which may be sent out as notifications.

WF_NOTIFICATION_ATTRIBUTES
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 mesage attribute definition.

Business Event Tables

WF_SYSTEMS
System definitions for Business Event System

WF_AGENTS
Agent definitions for Business Event System

WF_EVENTS
Event definitions for Business Event System

WF_EVENT_SUBSCRIPTIONS

Subscription for Business Event System

Related Topic:

Oracle Workflow Queries: http://blog.youkuaiyun.com/pan_tian/article/details/8167386