When View Quality Results, get Error ORA-00904: "ASSET_GROUP_ID": invalid identifier

(Doc ID 799707.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Enterprise Asset Management - Version and later
Information in this document applies to any platform.


When attempting to view Quality Results from Maintenance Super User windows within Asset Tab the following error occurs:

Error Page - You have encountered an unexpected error. Please contact the System Administrator for assistance.

Error Stack shows the following details:
## Detail 0 ##
java.sql.SQLException: ORA-00904: "ASSET_GROUP_ID": invalid identifier
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

The issue can be reproduced at will with the following steps:
1. Go to Maintenance Super User > Asset Tab
2. Select an Asset number
3. Click on Quality Plan
4. Click on View Quality Plan Results


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