My Oracle Support Banner

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.


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. 


To view full details, 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 a vibrant support community of peers and Oracle experts.