My Oracle Support Banner

Pricing And Availability Form: FRM-40502: ORACLE Error: Unable To Read List Of Values (Doc ID 2132996.1)

Last updated on FEBRUARY 17, 2019

Applies to:

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


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.

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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.