Stored procedures are a group of SQL statements that perform particular tasks on the database. For example, stored procedures can help improve the performance of the database. You deploy stored procedures by copying the stored procedure files from your Oracle BI Applications installation and deploying them to Oracle Business Analytics Warehouse.
Some sessions might fail if these procedures are not compiled in the database before running the workflows.
Note:
If you have problems deploying the stored procedures, refer to your database reference guide, or contact your database administrator.