Workflow Tutorial

  1 | 2 | 3| 4 | 5 | 6 | 7 Next>>

Business Requirement:
When an item is created in inventory, workflow needs to be launched and it should collect the details of the item created and sends a notification to group of users along with the details and link to master item form.

Process flow: When an item is created it will create/insert a record in MTL_SYSTEM_ITEMS_B so create a database trigger on the table and launch workflow from that trigger. All you need to do is create the workflow, create the trigger, pl/sql package, roles and finally create an item in inventory.

• Open WFSTD and save as new workflow
• Create Attributes
• Create Functions
• Create Notification
• Create Messages
• Create Roles
• Create database trigger
• Create PL/SQL Package

Open WFSTD and save as new workflow

 

 

Navigation: File >> Open

 

 

 

Click Browse then navigate to Workflow installation directory

 

Navigation: Workflow Installation Directory à WF à DATA à WFSTD

Now Click File à  Save as à enter "ErpSchools Demo" and click OK

 

Right click on WFSTD and select New Item type

 

Enter the fields as below

Internal Name: ERP_DEMO

Display Name: ErpSchools Demo

Description: ErpSchools Demo

 

 

Now you will see ErpSchools Demo icon in the Navigator

 

Expand the node to see attributes, processes, notifications, functions, Events, Messages and lookup types.

 

 

Double click on Process to open up the properties window as shown below

 

 

Enter the fields

Internal Name: ERPSCHOOLS_PROCESS

Display Name: ErpSchools Process

Description: ErpSchools Process

 

 

 

Double click ErpSchools Process Icon

 

 

1 | 2 | 3| 4 | 5 | 6 | 7 Next>>