Generating Database Triggers for Hospitality Workflows

The Generate Trigger (GenTrig) component on Oracle’s Siebel Server allows you to generate database triggers. Workflow policies use database triggers to identify which records match policy conditions. For more information about database triggers, see the chapter about administering a workflow policy in Siebel Business Process Framework: Workflow Guide.

To generate database triggers for the Hospitality workflows, follow this procedure.

This task is a step in Process of Setting Up Hospitality Workflows.

To generate database triggers for Hospitality workflows

1. Navigate to the Administration - Server Management screen, then the Jobs view.

2. In the Jobs list, create a new job.

3. In the Component/Job field, select the component with the Name of Generate Triggers.

4. In the Job Parameters list, add new component-specific parameters, using the names and values shown in the following table.

   Name	Value
   Trigger File Name	Name of the SQL script file, for example, Gentrigger.sql. Any filename can be given.
   Privileged User	Table owner name for the Oracle database, for example, ORA31144.
   Privileged User Password	Table owner password for the Oracle database, for example, ORA31144.
   Exec	True

5. In the Jobs list, with the Generate Triggers job selected, click Submit Job.

6. Verify that the Status field of the Generate Triggers job has a value of Completed.