OBIEE 11g - Invalid Objects In PRD_ESS Schema Created By RCU "identifier 'DBMS_XMLDOM.DOMDOCUMENT' must be declared" (Doc ID 1932009.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

We have executed catblocks.sql as well on the database but still the error exists.

SQL> alter package PRD_ESS.ESS_RUNTIME compile body;

Warning: Package Body altered with compilation errors.


SQL> show errors;

Errors for PACKAGE BODY PRD_ESS.ESS_RUNTIME:

LINE/COL ERROR
-------- -----------------------------------------------------------------
159/3 PL/SQL: Item ignored
160/12 PLS-00201: identifier 'DBMS_XMLDOM.DOMDOCUMENT' must be declared
165/3 PL/SQL: Item ignored
166/12 PLS-00201: identifier 'DBMS_XMLDOM.DOMDOCUMENT' must be declared
3036/11 PL/SQL: Item ignored
3036/11 PLS-00201: identifier 'DBMS_XMLDOM.DOMDOCUMENT' must be declared
3037/16 PL/SQL: Item ignored
3037/16 PLS-00201: identifier 'DBMS_XMLDOM.DOMELEMENT' must be declared
3038/16 PL/SQL: Item ignored
3038/16 PLS-00201: identifier 'DBMS_XMLDOM.DOMELEMENT' must be declared
3039/16 PL/SQL: Item ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
3039/16 PLS-00201: identifier 'DBMS_XMLDOM.DOMNODE' must be declared
3051/5 PL/SQL: Statement ignored
3051/5 PLS-00320: the declaration of the type of this expression is incomplete or malformed

3053/5 PL/SQL: Statement ignored
3053/5 PLS-00320: the declaration of the type of this expression is incomplete or malformed

3054/5 PL/SQL: Statement ignored
3054/5 PLS-00320: the declaration of the type of this expression is incomplete or malformed

3059/5 PL/SQL: Statement ignored
3059/30 PLS-00320: the declaration of the type of this expression is incomplete or malformed


 

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