My Oracle Support Banner

iStore Product Search With Wildcard % Is Not Working After Database Upgrade to 11g (Doc ID 1351173.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle iStore - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Goal

  iStore Product Search with only wildcard search critieria of  (percent sign) -
   %

Is not working after Database upgrade to 11g (version: 11.2.0.2 ).  
This returns message:    'No items were found matching your search criteria'.

Items are available in the search table for other search criteria such as below do return records -
   A3%
   A4%
   LKS%



Solution

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
Goal
Solution
References


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