1. Business Process Framework: Workflow Guide
  2. Guidelines for Using an SQL Statement with a Workflow Policy Program Argument

Guidelines for Using an SQL Statement with a Workflow Policy Program Argument

If you use an SQL statement with a Workflow Policy program argument, then it is recommended that you adhere the following guidelines:

  • Make sure the table name and column name are in upper case.

  • You must prefix the case-sensitive table name with the following value:

    &Table_Owner

  • Make sure the RDBMS you use supports the SQL statement.

  • It is recommended that the SQL statement return only one record.

  • Siebel CRM can use only one Workflow Policy program argument that uses an SQL statement for a Workflow Policy program. Do not use two or more Workflow Policy program arguments that use SQL statements for a given Workflow Policy program.

  • Use an SQL tool that is external to Siebel CRM to test your statement.

Caution: It is recommended that you thoroughly test your SQL statement in the context of the Workflow Policy program before you implement it in a production environment.