Oracle Workflow

Oracle Workflow

Oracle Workflow lets you automate and continuously improve business processes,

Features of WF

• Oracle Workflow Builder

      Oracle Workflow Builder lets you create, view, or modify a business process with simple drag 

      and drop operations. Using the Workflow Builder, you can create and modify all workflow 

      objects, including activities, item types, and messages

• Workflow Engine

     The Workflow Engine embedded in the Oracle database server monitors workflow states and 

     coordinates the routing of activities for a process. These are the API like wf_engine , wf_core.

• Workflow Definitions Loader

      Used to move workflow definitions from a development to a production database

• Complete Programmatic Extensibility

    Oracle Workflow lets you include your own PL/SQL procedures or external functions as activities 

    in your workflows. Without modifying your application code, you can have your own program run

    whenever the Workflow Engine detects that your program's prerequisites are satisfied. 

 Major Components in Work Flow Builder

Attributes      : (Variables)

Processes       : Actual Work Flow to automate the business process

Notifications : Through which send and receive the message

Functions      : PL/SQL procedure for any functionality

Messages       :  Text/message to be sent

Lookup Types :Which contain look up code that is used for conditional flow.

Create a Simple Notification 

1. Open Workflow Builder > File > New

   

Right Click on Untitled-1 > New Item Type

Provide the New Item Type details as below then Click on Apply and OK

Expand Test Type Item Type (Click on +)  symbol to add its components

Create Attribute: 

Right Click on Attributes > New Attribute > Provide the details as below

Create Message

Right Click on Messages > New Message > Provide the details as below

Click on Body Tab to provide the message body 

Create Notifications

Right Click on Notifications > New Notification > Provide the details as below

Create Process

Right Click  on Processed > New Process > Provide the details as below

Save the Workflow by clicking on SAVE button

Design the Workflow Process

1. Add the Node (Start and End) to your new process (Test Process)

Note: Start and End Node are available in WFSTD file which is available in Workflow Builder.

         Open WFSTD file as below

           Click on Open  Icon> Browse > Choose WFSTD.WFT > Click on Open        

This WFSTD.WFT file will be available in <WF Installed Folder>WF>DATA>US

1. Double Click on Test Process to open the Process window

2. Expand WFSTD to drag and drop the START and END node to your process

3. Drag your notification to your Process

4. Connect them by Right Click and Drag as below

Click on Node tab in START function and select Start for Start/End filed

Click on Node tab in END function and select End for Start/End filed

Attach Message to the Notification

Double Click on Test Notification you have created to open the same.

Select message name from 'Message' field that you have created above.

Add Performer to the Notification. Performer is a application user who will get the notification.

Click on Node Tab from the Notification Window and Select the user from the list

Check your Design by clicking on Verify icon from the Menu

Save the Workflow in the Database

To start  the Process we need to follow these steps:

1.  Create the workflow process

2. Set the item attributes

3. Start the workflow process

Check your WF :

Go to Work flow Administration Web Applications Resp.