When selecting for Quality Collection Plan receive FRM-40502:ORACLE error: unable to read list of values

(Doc ID 2307175.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

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

Symptoms

When attempting to enter results the List of Values (SQL Validation Statement) is not functioning for quality collection plan

ERROR

ORA-01007:variable not in select list
---------------------------------------
FRM-40502:ORACLE error: unable to read list of values




STEPS

1. Navigate to Quality >Query up plan > Enter Results > Click on LOV symbol and get error

Changes

 

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