Error: "ORA-00904: : invalid identifier" When Attempting to Release or Audit Release Change

(Doc ID 1122315.1)

Last updated on MARCH 26, 2017

Applies to:

Oracle Agile Product Collaboration - Version and later
Oracle Agile PLM Framework - Version 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