NOTE It is recommended that DB Operation be used only when the data dependency

Note it is recommended that db operation be used only

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

NOTE: It is recommended that DB Operation be used only when the data dependency that is involved is centered around database records rather than around business components. For example, if one database record must be updated when another database record is inserted, then use DB Operation, regardless of which business components the two database records belong to, or whether the two database records belong to a business component at all. Properties of the Workflow Policy Program Argument A workflow policy program argument defines recipients, database actions, and available substitutions. Each workflow policy program typically contains several program arguments. The fields that display in this view depend on the type of workflow policy program you choose. A workflow policy program argument is a child of a workflow policy program. CAUTION: Certain text is not allowed in the Default Value workflow policy program argument. Do not use trailing spaces, [newline], or escape characters. Using this text can cause problems, such as failure of Workflow Monitor Agent at run time. Type Yes You can choose the following types from the picklist: DB Operation. Insert or update a database table based on arguments. For more information, see “DB Operation Type” on page 476 . External Program. Execute an external program in Windows. Send Message. Compose and send an automatic email message. Send Page. Send a page to a pager. Send Broadcast Message. Send a broadcast message to a group of users. Workflow object No Limits use of this program to policies that are associated with this workflow policy object. Inactive No Checked if the workflow policy program is not active. Comments No Add text to describe the workflow policy program. Table 97. Properties of the Workflow Policy Program Property Required Usage
Image of page 476
Reference Materials for Siebel Workflow Properties of Workflow Policies Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A 477 Table 98 describes properties that are displayed in the Workflow Policy Program Arguments OBLE. Date Format with a Workflow Policy Program You must use the following formats when setting a Default Value for time and date fields: Date Column format: 2001-03-16 Time Column format: 19:26:26 Date Time Column format: 2001-04-05 21:25:00 A workflow policy program is executed by the Siebel Server that connects to Oracle through ODBC. As part of this process, the required data is retrieved from the database through this connection. The format of a date in an email is the format that is returned by the ODBC driver, which might be different from that used by Oracle. Table 98. Properties of the Workflow Policy Program Argument Property Required Usage Applet Optional Define the Picklist applet. Default Value Optional Define the text value of a type that depends on the Name of the program argument, an SQL statement, the text of a message, the email address of a recipient, and so forth.
Image of page 477
Image of page 478

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