"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 184.108.40.206.0 and later
Information in this document applies to any platform.
During an 11.1.1 to 220.127.116.11 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:
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