For example the SEVTACT table contains two required columns NAME and ROWSTATUS

For example the sevtact table contains two required

This preview shows page 366 - 368 out of 512 pages.

For example, the S_EVT_ACT table contains two required columns: NAME and ROW_STATUS. Because ROW_STATUS defaults to Y, it is not necessary for you to set a value in the program. A value for a system generated column is not required, such as CREATED, CREATED BY, LAST_UPD, LAST_UPD_BY, ROW_Id, MODIFICTION_NUM, and CONFLICT_Id.
Image of page 366
Defining a Custom Workflow Policy Customizing Workflow Policy Objects Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A 367 To define a customized workflow policy program 1 In Siebel Tools, in the Object Explorer, click Workflow Policy Program. 2 In the Workflow Policy Programs OBLE, choose an existing workflow policy program that is similar to what you require for the customized workflow policy program. 3 Right-click, then choose Copy Record. The Copy Record feature copies the entire program, including the program arguments. 4 In the new workflow policy program, modify the appropriate properties in order to meet the requirements of the customized program, such as Workflow Object. 5 Define the program arguments. Enter the arguments carefully to make sure capitalization, punctuation, and spelling are correct: Type the entries in the Name column exactly as indicated in Table 99 on page 478 . Primary ID, Primary Table, Operation Type, SQL Statement, and SQL Statement Outputs must contain one space between each word and each word must be properly capitalized. For example, Primary Id must contain: one space between the two words, a capital P, and a lowercase d. Avoid using the carriage return. For more information, see “Use of Carriage Return in the Argument of a Workflow Policy Program” on page 367 . If using an SQL statement in a program argument, then make sure the statement is specific to the particular RDBMS you are using. Type the names of the column pairs exactly: one space between each word, identically capitalized, one space in front of the left parenthesis, and no spaces in the column. The order of the rows is not important. NOTE: Before you use a workflow policy program and related arguments for the workflow policy program, you must delete the definitions for workflow policy program arguments that are inactive or incomplete. These can cause Workflow Monitor Agent errors. Use of Carriage Return in the Argument of a Workflow Policy Program In a workflow policy program argument, the carriage return character that exists in SQL Statement and SQL Statement Outputs can cause unexpected behavior for a workflow policy program. In most cases, the substitution value is not substituted with the intended value but is instead substituted with the [Label] literally. Avoid using the carriage return character. Copying an Existing Workflow Policy Program The advantage of copying an existing workflow policy program is that if something goes wrong with your customized workflow policy program, then you can start over with the original, unmodified workflow policy program.
Image of page 367
Image of page 368

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