Error: "ORA-00904: : invalid identifier" When Attempting to Release or Audit Release Change
Last updated on MARCH 26, 2017
Applies to:Oracle Agile Product Collaboration - Version 126.96.36.199 and later
Oracle Agile PLM Framework - Version 188.8.131.52 and later
Information in this document applies to any platform.
When attempting to release or audit release any change through Web Client, the following error occurs.
"ORA-00904: : invalid identifier"
- Cannot reproduce the issue by running the SQL found in sql trace debug log just before ORA-00904 is logged.
For instruction on how to enable SQL trace log, see <Note 568239.1>
- Below error is found in Agile database alert log found in [ORACLE_HOME]/admin/[ORACLE_SID]/bdump/alert_[ORACLE_SID].log:
ORA-04063: package body "AGILE.AGILE9_UTILS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "AGILE.AGILE9_UTILS"
Imported Agile database
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