Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing >

Installing the Temporary Patch for Oracle Warehouse Builder 11g

If you created the repository using Oracle Warehouse Builder 11g, follow this procedure to install the temporary patch. The temporary patch is not required for Release 2 of Oracle Warehouse Builder 11g.

This task is a step in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing.

To install the temporary patch for Oracle Warehouse Builder 11g

1. Go to the EDX_HOME/db/ebilling/oracle/olap/etl/packages (or the EDX_HOME\db\ebilling\oracle\olap\etl\packages folder on Windows), and verify that the BUG7497106.sql file exists in that folder.
2. Log in to the OLAP database using SQL*Plus as sysdba, where OLTP_Instance is the name of the OLTP instance:

   export ORACLE_SID=OLTP_Instance

   SQLPLUS "/ as sysdba"

3. At the SQL*Plus prompt, run:

   SQL>@BUG7497106.sql

   SQL>exit

   SQL>exit