module 38 using workflow policies
TRANSCRIPT
![Page 1: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/1.jpg)
Using Workflow Policies 1 of 27
Siebel 8.0 Essentials
![Page 2: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/2.jpg)
Module 37: Using Workflow Policies
![Page 3: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/3.jpg)
Using Workflow Policies 3 of 27
Module Objectives
• To Create a workflow policy that invokes a workflow process in the Workflow Process Manager server component.
• To Enable the workflow policy using workflow server components.
![Page 4: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/4.jpg)
Using Workflow Policies 4 of 27
Asynchronous Workflow Processing
• Some workflows need to be executed asynchronously– They might run for a long time and should not execute in the user’s
object manager– They might need to wait for the invoking condition to be satisfied
for some period of time• Example: If a critical service request remains unassigned for more than two
hours, notify the service manager and set the priority to High
• Workflow policies are a mechanism for asynchronous execution
of workflow processes
![Page 5: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/5.jpg)
Using Workflow Policies 5 of 27
Workflow Policies
• A workflow policy is a rule consisting of:– One of more policy conditions– A policy action
• Action is invoked when all conditions are true• Example: When a service request priority = Critical AND
substatus = Unassigned:– Send urgent message to service manager
![Page 6: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/6.jpg)
Using Workflow Policies 6 of 27
Workflow Policy Conditions
• Policy condition specifies a logical relationship between a
workflow policy column and a value• All policy conditions must be satisfied for a condition to apply• Policy may have a duration specified• Conditions must apply for the duration before the action is
executed
![Page 7: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/7.jpg)
Using Workflow Policies 7 of 27
Workflow Policy Actions
• A workflow policy action is the response to be executed• Consists of:
– Type of program to be executed• Examples: Run workflow process, send email, send message
broadcast
– One or more program-specific arguments
• Multiple types of programs are supported– Not restricted to running workflow processes
• Actions are defined separately– Can be used in multiple workflow policies
![Page 8: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/8.jpg)
Using Workflow Policies 8 of 27
Workflow Policies
• Leverage:– A separate server component known as the Workflow Process
Manager component
• Is a server component optimized for executing workflows• Behaves like an object manager• Can access the business and data layers• Does not have a user interface for direct user interaction
– Database triggers:• A trigger is a process or a stored procedure attached to a
database table that fires when a specified data modification event occurs
• Are created by the Generate Triggers server component
![Page 9: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/9.jpg)
Using Workflow Policies 9 of 27
Executing Workflow Policies
• Generate Triggers creates the database triggers required to
monitor conditions in policies• Workflow Monitor Agent checks for fired triggers
– Identifies policy conditions that are satisfied– Invokes the desired workflow process
• Workflow Process Manager executes the workflow process• Execution is asynchronous
![Page 10: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/10.jpg)
Using Workflow Policies 10 of 27
Workflow Policy Groups
• A workflow policy group is a collection of workflow policies that
are monitored as a group by a workflow monitor agent process– Typically workflow policies that can be monitored at the same
frequency are assigned to the same policy group
![Page 11: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/11.jpg)
Using Workflow Policies 11 of 27
Prerequisite for Executing Workflow Policies
• Enable the Workflow Management component group on the
enterprise• Assign and enable the component group on a server• Navigate to Administration - Server Configuration > Enterprises
> Component Groups
![Page 12: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/12.jpg)
Using Workflow Policies 12 of 27
Workflow Component Definitions
• Workflow Component Group consists of six server component
definitions
![Page 13: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/13.jpg)
Using Workflow Policies 13 of 27
Implementing a Workflow Policy
1. Create a Workflow Group
2. Create a Workflow Policy Action
3. Create a Workflow Policy
4. Generate Database Triggers
5. Start Workflow Monitor Agent
![Page 14: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/14.jpg)
Using Workflow Policies 14 of 27
1. Create a Workflow Group
• Navigate to Administration - Business Process > Policy Groups• Create a new policy group
![Page 15: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/15.jpg)
Using Workflow Policies 15 of 27
2. Create a Workflow Policy Action
• Navigate to Administration - Business Process > Actions• Create a new action
– Specify Run Workflow Process
• Provide workflow process as an argument
Specify the Run Workflow Process
program
Specify the Workflow process to invoke
![Page 16: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/16.jpg)
Using Workflow Policies 16 of 27
3. Create a Workflow Policy
• Navigate to Administration - Business Process > Policies• Create a new policy
– Specify conditions– Add one or more actions
![Page 17: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/17.jpg)
Using Workflow Policies 17 of 27
3. Create a Workflow Policy…
![Page 18: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/18.jpg)
Using Workflow Policies 18 of 27
3. Set Duration
• Set duration for the workflow policy– All conditions must be met and the policy duration must be
satisfied to trigger the workflow policy actions
• Defaults to 0– The workflow policy actions are triggered as soon as the policy
conditions are met
![Page 19: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/19.jpg)
Using Workflow Policies 19 of 27
4. Generate Database Triggers
• Run a Generate Triggers batch job to create database triggers
corresponding to the policy conditions– When a trigger fires against a Policy Condition, a record is inserted
in the Escalation Request Table (S_ESCL_REQ)– S_ESCL_REQ contains all the rows in the database that could
trigger a policy to take action
![Page 20: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/20.jpg)
Using Workflow Policies 20 of 27
4. Generate Database Triggers…
• Navigate to Administration - Server Management > Jobs• Create a new job• Select Generate Triggers• Specify parameters• Submit job
![Page 21: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/21.jpg)
Using Workflow Policies 21 of 27
• Start the server manager by entering:
srvrmgr /g <Siebel Gateway Name Server address> /s <Siebel server name> /e <enterprise server name> /u <server administrator username> /p <server administrator password>
• Start a new Workflow Monitor Agent task in background mode by entering:
start task for component WorkMon with SleepTime=<time>,GroupName=<group name>
5. Start Workflow Monitor Agent
![Page 22: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/22.jpg)
Using Workflow Policies 22 of 27
5. Start Workflow Monitor Agent…
• Use a Vanilla Workflow Monitor Agent component definition
to specify a Workflow group– Monitors all policies within a single Workflow group
• Activate the new component definition to make it available
![Page 23: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/23.jpg)
Using Workflow Policies 23 of 27
Verify the Workflow Policy
• Create a test record (or modify an existing record) that violates
the policy condition• Wait for at least the policy duration• Verify that the desired workflow actions are executed
![Page 24: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/24.jpg)
Using Workflow Policies 24 of 27
Workflow Policies Database Tables
TABLE DESCRIPTION
S_ESCL_REQ This table holds the potential matching requests created by applications
S_ESCL_STATE This table holds the time based policy matches
S_ESCL_ACTN_REQ This table holds the requests to execute actions.This is only used is Action Agent = TRUE
S_ESCL_LOG This table holds a history of base table rows that have matched policies
Workflow Monitor Agent :
•Checks the Escalation Requests table to see whether the conditions of a Policy are met
•Monitors all policies in a Single group
![Page 25: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/25.jpg)
Using Workflow Policies 25 of 27
Comparing Different Methods
• Use different methods for different needs
![Page 26: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/26.jpg)
Using Workflow Policies 26 of 27
Module Highlights
• A workflow policy is a rule consisting of one or more conditions
and a policy action to be executed when the conditions are
satisfied• Workflow policies implement asynchronous execution of
workflow processes• Workflow policies require the use of:
– Generate Triggers to create the database triggers– Workflow Monitor Agent to check for fired triggers– Workflow Process Manager to execute the associated workflow
policy
![Page 27: Module 38 Using Workflow Policies](https://reader033.vdocuments.us/reader033/viewer/2022061109/54518ad2b1af9f154c8b46e2/html5/thumbnails/27.jpg)
Using Workflow Policies 27 of 27
Lab
• In the lab you will:– Create a workflow policy– Enable the workflow management group components– Test the workflow policy