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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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

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