"ORA-00904: : Invalid Identifier" Errors Seen When Confirming If OIM DB Objects Are Valid During Upgrade

(Doc ID 2171482.1)

Last updated on AUGUST 14, 2016

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.


During an 11.1.1 to upgrade, one of the steps is to validate the Database objects (see http://docs.oracle.com/cd/E52734_01/core/IAMUP/common_tasks.htm#CHDFFFAF ).

The step advised to re-compile the invalid objects using @<$Oracle_Database_Home_Location>/rdbms/admin/utlrp.sql.  Upon compilation of an invalid stored procedure (if applicable) it may fail and if you run "select * from user_errors order by sequence;" the following error may be seen:

PL/SQL: ORA-00904: : invalid identifier  <--notice the empty strings between the ": :" - this is very important to determining root cause

The line the error pointed to in the stored procedure was:



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