Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Installing the Siebel Customer-Centric Enterprise Warehouse Environment > Process of Creating the Development Repository >

Deploying Stored Procedures

This task is a step in the Process of Creating the Development Repository.

This section applies only to Siebel Supply Chain Analytics for Oracle 11i and the Siebel Enterprise Workforce Analytics applications for PeopleSoft 8.4.

Stored procedures are a group of SQL statements that perform particular tasks on the database. For example, stored procedures can help to improve the performance of the database.

You can deploy stored procedures by copying the stored procedure files from your Siebel Customer-Centric Enterprise Warehouse installation and deploying them to the target data warehouse.

NOTE:  Some sessions may fail if these procedures are not compiled in the database before running the workflows.

To deploy stored procedures

1. Navigate to the $Siebel\ETL\Stored_Procedure_Scripts folder.
   • For Oracle 11i, copy the source codes Compute_Bounds_Ora11i.sql and PROC_PA_TASK_HIER.SQL into the target data warehouse schema.
   • For PeopleSoft 8.4, copy the source code build_posn_sets.sql into the target data warehouse schema.
2. Compile the stored procedures in the target data warehouse database.

NOTE:  If you have problems deploying the stored procedures, see your database reference guide, or contact your database administrator.