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 9.3.0.0 and later
Oracle Agile PLM Framework - Version 9.3.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to release or audit release any change through Web Client, the following error occurs.

Error

"ORA-00904: : invalid identifier"


Facts

- 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"


Changes

Imported Agile database

Cause

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