My Oracle Support Banner

"ORA-00904: : Invalid Identifier" Errors Seen When Confirming If OIM DB Objects Are Valid During Upgrade (Doc ID 2171482.1)

Last updated on SEPTEMBER 26, 2019

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 ).

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:



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

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