Pricing And Availability Form: FRM-40502: ORACLE Error: Unable To Read List Of Values

(Doc ID 2132996.1)

Last updated on MAY 16, 2018

Applies to:

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

Symptoms

On : 12.2.3 version,

When attempting to enter information on the Pricing & Availability form for a Customer-based Item Cross Reference, the following error occurs. This happens when attempting to enter a valid cross reference item and when doing a blind query on the field. If the query is done on the Description, the list of values (LOV) is displayed and can be selected as expected.

ERROR
-----------------------
FRM-40502: ORACLE error: unable to read list of values


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to Order Management Super User responsibility
2. Go to Pricing and Availability
3. Under Item Identifier Type, enter 'Customer Item Number'
4. Click on the Item and do a Query
5. Error occurs


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