Table 60 describes arguments for the Change SR Close Date to Today workflow

Table 60 describes arguments for the change sr close

This preview shows page 388 - 391 out of 512 pages.

program enters the current system date into the Close Date field of the service request. Table 60 describes arguments for the Change SR Close Date to Today workflow policy program. Table 60. Arguments for the Change SR Close Date to Today Workflow Policy Program Argument Name Description Primary ID Contains the row ID of the service request that meets the conditions for the workflow policy. Primary Table Operation Type Specifies the S_SRV_REQ table and the operation to execute the Update operation.
Image of page 388
Using a Predefined Workflow Policy Examples of Workflow Policy Programs That Are Predefined Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A 389 Example of a Workflow Policy Program That Assigns an SR Owner This topic gives one example of using a predefined workflow policy program to automatically assign an SR that is not yet assigned. You might use this feature differently, depending on your business model. If an open service request is not assigned for a certain length of time, then this workflow policy program can be used to assign, that is change the owner of, a service request to the person who is considered an expert in the area of the specific service request. This configuration allows the correct people to see the incoming service request and assign it appropriately. This workflow policy program allows you to choose a new owner from a picklist and put it into the field of the service request that matches the condition for the workflow policy. Sql Statement select sys_extract_utc(current_timestamp) from &Table_Owner.S_DUAL This statement calls the Siebel function now() to obtain the current date and uses the table &Table_Owner.S_DUAL to temporarily hold the value. The S_DUAL table is used to hold temporary values. A math function can also be performed. For example, the SQL statement select {fn now()}+7 from &Table_Owner.S_DUAL returns the current date plus seven days. Different RDBMS databases use different formats for the same function. For example, in MS SQL, the function GetDate() is used to return the current date. NOTE: The column name length must be less than 30 characters. For example, the following statement violates this rule because it is more than 30 characters in length: TO_CHAR(CREATED,'dd month yyyy','NLS_DATE_LANGUAGE=FRENCH') . Sql Statement Outputs The value for the Today variable is obtained from the SQL statement. New Close Date (Column) Specifies the column in the record to be updated (ACT_CLOSE_DT). New Close Date Specifies the field to be updated to the value of Today. Update Row ID The row ID of the record you must update. This argument is the same as the value of the Primary ID. Table 60. Arguments for the Change SR Close Date to Today Workflow Policy Program Argument Name Description
Image of page 389
Siebel Business Process Framework: Workflow Guide Version 8.1, Rev A Using a Predefined Workflow Policy Examples of Workflow Policy Programs That Are Predefined 390 Table 61 describes arguments for the Change SR Owner workflow policy program.
Image of page 390
Image of page 391

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