My Oracle Support Banner

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 MAY 10, 2022

Applies to:

Oracle iStore - Version 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


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

The possible messages that can be received are :


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


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



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
Information required if logging a Service Request with Oracle Support for this issue:

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