Collection Element LOV Giving Error

(Doc ID 2211481.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

User has created a new Collection Element and has associated it with a SQL Validation Statement. User expects that upon Entering Quality Results the LOV should open up for these Collection Elements based on the SQL statement. However the following error comes up

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

The SQL statements execute just fine when executed on SQL prompt.
 

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