SQL> select owner, OBJECT_NAME, OBJECT_TYPE from ALL_OBJECTS where status='INVALID' and owner like '%OWB%'
  2  ;

OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ ------------------
OWB10G_RUNTIME                 OWB_UPROP                      PACKAGE
OWB10G_RUNTIME                 OWB_UPROP                      PACKAGE BODY
OWB10G_RUNTIME                 UTL_RECOMP                     PACKAGE BODY
OWB10G_RUNTIME                 WB_OLAP_LOAD_CUBE              PROCEDURE
OWB10G_RUNTIME                 WB_OLAP_LOAD_DIMENSION         PROCEDURE
OWB10G_RUNTIME                 WB_OLAP_LOAD_DIMENSION_GENUK   PROCEDURE

6 rows selected.

SQL> alter package OWB_UPROP compile;

Warning: Package altered with compilation errors.

SQL> show error;
Errors for PACKAGE OWB_UPROP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1      PL/SQL: Declaration ignored
2/36     PLS-00201: identifier 'SUB_FQ_PUSAGE_DEF' must be declared
3/1      PL/SQL: Declaration ignored
3/36     PLS-00201: identifier 'ALL_IV_EXT_OBJECT_PROPERTIES' must be
         declared

SQL> alter procedure WB_OLAP_LOAD_CUBE compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE WB_OLAP_LOAD_CUBE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/205    PLS-00201: identifier 'DBMS_AWM.CREATE_AWCUBELOAD_SPEC' must be
         declared

1/205    PL/SQL: Statement ignored
1/351    PLS-00201: identifier 'DBMS_AWM.REFRESH_AWCUBE' must be declared
1/351    PL/SQL: Statement ignored
1/533    PL/SQL: SQL Statement ignored
1/557    PL/SQL: ORA-00942: table or view does not exist
1/768    PLS-00201: identifier 'DBMS_AWM.AGGREGATE_AWCUBE' must be
         declared

1/768    PL/SQL: Statement ignored
SQL>

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    PLS-00201: identifier 'DBMS_AWM.CREATE_AWDIMLOAD_SPEC' must be
         declared

1/205    PL/SQL: Statement ignored
1/365    PLS-00201: identifier 'DBMS_AWM.SET_AWDIMLOAD_SPEC_PARAMETER'
         must be declared

1/365    PL/SQL: Statement ignored
1/500    PLS-00201: identifier 'DBMS_AWM.REFRESH_AWDIMENSION' must be
         declared

1/500    PL/SQL: Statement ignored
SQL> alter procedure WB_OLAP_LOAD_DIMENSION_GENUK compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE WB_OLAP_LOAD_DIMENSION_GENUK:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/211    PLS-00201: identifier 'DBMS_AWM.CREATE_AWDIMLOAD_SPEC' must be
         declared

1/211    PL/SQL: Statement ignored
1/371    PLS-00201: identifier 'DBMS_AWM.SET_AWDIMLOAD_SPEC_PARAMETER'
         must be declared

1/371    PL/SQL: Statement ignored
1/505    PLS-00201: identifier 'DBMS_AWM.REFRESH_AWDIMENSION' must be
         declared

1/505    PL/SQL: Statement ignored
SQL>