You can associate a workflow policy action with a workflow policy that updates

You can associate a workflow policy action with a

This preview shows page 478 - 481 out of 512 pages.

You can associate a workflow policy action with a workflow policy that updates a table. This value is used only when the Operation Type is set to update. The row ID you must update. Operation Type Define the operation to perform: update or insert. Two possible values for DB Operation: Update or Insert.
Image of page 478
Reference Materials for Siebel Workflow Properties of Workflow Policies Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A 479 Items to consider include: The value is entered manually into the Name property of the Workflow Policy Program Arguments OBLE. If you run a database operation with Insert as the Operation Type, then you can choose a Default Value, New Row ID, as described previously, which provides the value for the ROW_Id field for the inserted row. Passing Multiple Variables to SQL Program Arguments Multiple variables can be passed into SQL program arguments. To pass multiple variables to SQL program arguments 1 In the Workflow Policy Program Arguments OBLE, choose Sql Statement Inputs. 2 Enter the variable names into the Default Value property. Use the following format: [variable1], [variable2], [variable n] Field Name Define the Name of the column in the base table to which the operation is performed. This is one of two field column pairs. Allowable values: Text, Variable, Function. New Row ID For insert operations, this argument is automatically populated with the row ID of the row about to be inserted. Empty. Field Name (Column) Define the Field Name, which must be identical to the Field Name of the first column pair and (Column) appended to the name. This is the second of two column pairs. Actual field name in the base table. The value can not contain leading spaces. Sql Statement Used as a way to identify more data from the database that are used as substitutions when the action is performed. Valid SQL query statement for the RDBMS that is used: Oracle, MS SQL, Informix, or Sybase. Sql Statement Inputs Define the Name of the column in the base table on which the operation is performed. Not applicable Sql Statement Outputs Use as a placeholder for the values that are chosen in the SQL Statement argument. Variable Name. Table 99. Arguments in the Name Property of the Workflow Policy Program Arguments OBLE Argument Usage Allowable Default Value
Image of page 479
Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A Reference Materials for Siebel Workflow Properties of Workflow Policies 480 Arguments for a Workflow Policy Program that Sends a Message Table 100 describes program arguments that are specific to some workflow policy programs that send a message. Arguments for a Workflow Policy Program that Sends a Page Table 101 describes program arguments that are specific to some workflow policy programs that send a page.
Image of page 480
Image of page 481

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