My Oracle Support Banner

RCU Throws Warnings "PLS-00905: object ODS.CRIDXPN_DN is invalid" While Creating ODS Schema (Doc ID 2052465.1)

Last updated on OCTOBER 11, 2018

Applies to:

Oracle Fusion Middleware - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Below warnings seen while loading ODS schema to the 11.2.0.4 Oracle database using 11.1.1.6.0 RCU.


The oid.log shows the following:

Errors for PROCEDURE CRIDXPN_DN:

12/5 PL/SQL: Statement ignored
12/18 PLS-00201: identifier 'DBMS_SQL' must be declared
13/5 PL/SQL: Statement ignored
13/44 PLS-00201: identifier 'DBMS_SQL' must be declared
14/5 PL/SQL: Statement ignored
14/23 PLS-00201: identifier 'DBMS_SQL' must be declared
15/5 PL/SQL: Statement ignored

DROP INDEX pn_dn
*
ERROR at line 1:
ORA-01418: specified index does not exist

BEGIN cridxpn_DN; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object ODS.CRIDXPN_DN is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

 

The rcu.log shows the following:

2015-08-26 17:58:55.603 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-06550: line 1, column 7:
PLS-00905: object ODS.CRIDXPN_DN is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

2015-08-26 18:47:55.895 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-06550: line 1, column 7:
PLS-00905: object ODS.OIDRIPKG is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.