FRM-40502 and/or ORA-01007 When Entering or Updating Quality Results

(Doc ID 2315979.1)

Last updated on OCTOBER 10, 2017

Applies to:

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

Symptoms

When attempting to enter data into a quality plan, the following error occurs.

ERROR

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



STEPS

The issue can be reproduced at will with the following steps:
1.  Responsibility = Quality (QA)
     Navigation = Setup-> Collection elements-> Create a collection element with a SQL validation statement:
     The SQL validation statement returns one column. For example,
                SELECT column1
               FROM table
               WHERE ........


2.  Responsibility = Quality (QA)
     Navigation = Setup-> Collection Plans -> Create a collection plan using the element from Step 1


3. Responsibility = Quality (QA)
    Navigation = Results-> Entry-> Enter Quality Results

4.  Query on the plan from 2 -> Click on the LOV for the user-defined collection element from Step 1.
5.  Now try to enter data....   ORA-01007: variable not in select list


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