Oracle Application's Blog: Oracle ebs workflow Tables

Oracle ebs workflow Tables

In this post , We will be discuss about the Oracle ebs workflow Tables. EBS workflow tables helps to store the approval workflow information in oracle apps. Workflow in Oracle EBS helps to drive the approval process and accounting engines/ process. With the help of workflow , We do implement the approval process in oracle ebs. Workflow is the key component in oracle ebs for driving the approval process in system. Workflow mailer is one of the important component of the oracle ebs workflow which do help to send the approval notification through email and help to drive the approval process from the email itself like approver can approve , reject the approval notifications from the email itself. here below is the complete details about Oracle ebs workflow Tables.

14 Most Important Oracle ebs workflow Tables

1.WF_ITEMS

2.WF_ITEM_TYPES

3.WF_ITEM_ATTRIBUTES

4.WF_ACTIVITIES

5.WF_ACTIVITY_ATTRIBUTES

6.WF_ITEM_ACTIVITY_STATUSES

7.WF_ACTIVITY_TRANSITIONS

8.WF_MESSAGE_ATTRIBUTES

9.WF_ITEM_ACTIVITY_STATUSES_H

10.WF_ACTIVITY_ATTR_VALUES

11.WF_MESSAGES

12.WF_NOTIFICATIONS

13.WF_NOTIFICATION_ATTRIBUTES

14.WF_PROCESS_ACTIVITIES

Detail Overview of the Oracle ebs workflow Tables

WF_ITEMS :-

For Example , I will take the example of Purchase Order Approval. Oracle EBS do create the Item Key for Each Purchase order approval proces. In the same way it work for ' Expense' 'Requisitions' and others.

We need to use the ITEM_TYPE='POAPPRV' , Using this Table , We can find that , how many purchase order apprvoal process has been triggered through

workflow and whats its state. Like , Owner Role, User Key is the Purchase Order No., Workflow start date and End date.

WF_ITEM_TYPES : -

The WF_ITEM_TYPES table defines an item that is transitioning through a workflow process. NAME (PK), PROTECT_LEVEL, CUSTOM_LEVEL, PERSISTENCE_TYPE

WF_ITEM_ATTRIBUTES :-

WF_ITEM_ATTRIBUTES help to store the different Workflow Attributes which is currently used in the Workflow Specific Process. For example, we are seeing the Workflow Item attributes for Purchase Order.

WF_ACTIVITIES :-

WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications,functions or folders. ITEM_TYPE (PK), RERUN, EXPAND_ROLE, PROTECT_LEVEL, CUSTOM_LEVEL, BEGIN_DATE, RROR_ITEM_TYPE, RUNNABLE_FLAG

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.

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. ITEM_TYPE (PK), ITEM_KEY (PK), PROCESS_ACTIVITY (PK).

WF_MESSAGES :-

WF_MESSAGES helps to store the Registry or definition of the workflow Notifications messages. When we do create the Workflow notifications , We do create Notifications through workflow

messages so this tables help to store the Registry or definition of the workflow Notifications messages

WF_MESSAGE_ATTRIBUTES :-

WF_MESSAGE_ATTRIBUTES helps to store the Workflow message attributes which we are using in the workflow notification messages. Each message attribute drive some value in run time and display in the Workflow notification

message.

WF_NOTIFICATIONS :-

This table help to track the each workflow notifications sent by workflow each process. We can track the wrokflow notifications for each process like PO , Expenses , Requisition , AP Invoice.