"ORA-00904: : Invalid Identifier" Errors Seen When Confirming If OIM DB Objects Are Valid During Upgrade
Last updated on AUGUST 14, 2016
Applies to:Identity Manager - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
During an 11.1.1 to 184.108.40.206 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