My Oracle Support Banner

Wildcard Search Returning Mixed Results (Doc ID 2071443.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Sales - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Using wildcard in the search returns mixed results: 

Sales User> Sales Dashboard> Customers > Customer Search > Search for a customer eg ABC%

Results are mixed with some starting with ABC but find others with the letters abc in the middle of their names etc.

Require that ABC% should return only customers starting with ABC. 

Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.