Cannot Find Items to Add to a Quote/Cart or when search in the iStore catalog Error: "No Records Found Matching the Given Criteria" (Doc ID 340933.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle iStore - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Quoting - Version 11.0 to 12.1.3
Information in this document applies to any platform.
No records found matching the given criteria.
FRM-40502: ORACLE error: unable to read list of values
advanced search
basic search
simple search

Symptoms

User cannot find and select items to add to quote in Quoting.

The possible messages that can be received are :

Error

In HTML receive 'No records found matching the given criteria.'

In Forms Quoting, this could result in any of the following errors
   FRM-40502: ORACLE error: unable to read list of values.
   FRM-40212: Invalid value for field INVENTORY_ITEM
   FRM-41830: List of Values contains no entries

 

Note: If the category drop down field does not have any categories categories available to search from in the ADD PRODUCT page in HTML Quoting, please refer to <Note 1231434.1> - Drop-Down List For Categories is Blank When Adding a Line On HTML Quoting

 OR


User does not find any items or expected items when searching in the iStore catalog section using Quick Search nor Advanced Search.

 

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