Invalid OWBSYS Objects For OWB 11g (Doc ID 742922.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Database Enterprise Edition 11.1.0.6/11.1.0.7 has been successfully created using the Database Configuration Assistant (DBCA).

Warehouse Builder Repositories have been successfully created by invoking the Repository Assistant.

While checking for invalid objects, Warehouse Builder OWBSYS schema reports the following invalid objects :

    OBJECT_NAME                    OBJECT_TYPE         STATUS
    ------------------------------ ------------------- -------
    SNAPSHOT                       PACKAGE BODY        INVALID
    WB_RTI_WORKFLOW_UTIL           PACKAGE BODY        INVALID
    WB_OLAP_LOAD_CUBE              PROCEDURE           INVALID
    WB_OLAP_LOAD_DIMENSION         PROCEDURE           INVALID
    WB_OLAP_LOAD_DIMENSION_GENUK   PROCEDURE           INVALID


Compiling the 2 package bodies will validate them but compiling the 3 procedures returns the following:

SQL> alter procedure WB_OLAP_LOAD_DIMENSION compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE WB_OLAP_LOAD_DIMENSION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/205 PL/SQL: Statement ignored
1/205 PLS-00201: identifier 'DBMS_AWM' must be declared
1/365 PL/SQL: Statement ignored
1/365 PLS-00201: identifier 'DBMS_AWM' must be declared
1/500 PL/SQL: Statement ignored
1/500 PLS-00201: identifier 'DBMS_AWM' must be declared
SQL>

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms