Last updated on JANUARY 01, 2017
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
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