Table 65 describes example workflow policy conditions to use in order to create

Table 65 describes example workflow policy conditions

This preview shows page 403 - 405 out of 512 pages.

Table 65 describes example workflow policy conditions to use in order to create a workflow policy that is based on the Account object. Multiple database triggers that are generated for multiple workflow policy conditions of one workflow policy is expected behavior. This technique separates the functionality of Generate Triggers and Workflow Monitor Agent. Generate Triggers simply monitors changes that are made to database records and inserts records into tables that are specific to a workflow policy. Workflow Monitor Agent evaluates violations, determines if the conditions that are associated with the rule for the violation are met, and executes the actions that are associated with a policy. You cannot use AND between database triggers that are generated for multiple workflow policy conditions of a workflow policy, because Generate Triggers can monitor only database changes, and database changes that violate different conditions might not be concurrent. Therefore, using an AND condition causes Generate Triggers to miss many violations. For example, assume a workflow policy contains the following workflow policy conditions: SR area is Network Activity Priority is 1-ASAP Two database triggers are generated. One database trigger monitors an SR that is created or updated, and checks if the area equals Network. The other database trigger monitors an activity that is created or updated, and checks whether the Priority equals 1-ASAP. Table 65. Example of Workflow Policy Conditions Property Condition 1 Condition 2 Condition Field Account Modification Num Account Last Update By Operation > <> Value 0 0-1
Image of page 403
Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A Administering a Workflow Policy Administering a Workflow Policy 404 But if you use AND database triggers and an end user creates an SR without an activity, then the database trigger is not violated because the activity does not exist. If later, a user adds an activity to the SR, then there still is no database trigger violation because the SR record does not change. This violation is missed due to use of AND logic. However, if you use OR for the database triggers and Workflow Monitor Agent evaluates the workflow policy condition, even though there are multiple violations in the S_ESCL_REQ table, then the Workflow Monitor Agent only processes one request because the other requests do not evaluate to TRUE. Generating Database Triggers This topic describes how to generate database triggers with the Generate Triggers server component. You can run the Generate Triggers server component from the Siebel client or from the command line. Both the Siebel client and the command line use the same parameters. The database triggers are only there in order to generate indicators for the Workflow Engine to check conditions for the policies.
Image of page 404
Image of page 405

You've reached the end of your free preview.

Want to read all 512 pages?

  • Summer '16
  • Oracle
  • Siebel Workflow, Workflow Guide

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors