Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for Oracle 11i >

Deploying Stored Procedures

This task is a step in the Process of Configuring Supply Chain Analytics for Oracle 11i.

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 Oracle BI Analytics 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 OracleBI\dwrep\Informatica\Stored_Procedure_Scripts folder. copy the source codes Compute_Bounds_Ora11i.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.