My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.