Problem To Search On Item Description Which Includes '%' Wild Card Character (Doc ID 1087447.1)

Last updated on APRIL 26, 2016

Applies to:

Oracle Product Hub - Version 11.5.10.0 and later
Information in this document applies to any platform.

Goal

Customer uses "%" in their item description, since % is also wildcard, while doing advance search results are per application design but do not meet customer expectation.
One such example: when search criteria is 
Item starts with = 02Feb%2010
Description contains = %
This will return all items starting with 02Feb2010, including any characters between the 'b' and the '2' ; customer expects only items starting with 02Feb%2010 and, and only and, those containing '%' symbol.

Solution

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