Wildcard Search Returning Mixed Results (Doc ID 2071443.1)

Last updated on MARCH 08, 2017

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

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