Unexpected Error In Quality Work Bench Web Page For QA Plan With Many Elements And Element Values (Doc ID 2274969.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Issue 1

Clicking on Duplicate results on Quality Workbench for a plan with many elements and actions:

Warning: Query has exceeded 300 roes. Potentially more rows exist, please restrict your query.
Error Page: You have encountered an unexpected error. Please contact the System Administrator for assistance.
Error Details: oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid

Issue 2

Trying to export results for the same plan:

Error Details:

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: select 'N' as "HideShowStatus" , ASSET_GROUP, ASSET_SERIAL_NUMBER, ASSET_ACTIVITY, MAINTENANCE_WORKORDER, ASSET_NUM, RESULTS_COMPLETION_DATE_TIME, RESULTS_COMPLETED_BY, 24_HOUR_ACCESS, SUBSTATION_TYPE,........

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
 

Solution

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