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 18.104.22.168 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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!