Siebel Hospitality Guide > Getting Started with Siebel Hospitality > Process of Setting Up Hospitality Workflows >

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 from the following table.

    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.



  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.
Siebel Hospitality Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.