My Oracle Support Banner

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.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.