Simple or Quick Search for an Object with Slash (/) Gives 'Wildcard Query Resulted in Too Many Results, Please Refine Your Criteria and Try Again' (Doc ID 2037877.1)

Last updated on AUGUST 26, 2020

Applies to:

Symptoms

Quick Search or Simple Search for an object such as an item with slash (/), receives a message "Wildcard query resulted in too many results, please refine your criteria and try again."

For example, do a simple search for item 123-ABC1441512/2, it throws an error.
But, truncate the last two characters /2 and look for 123-ABC1441512 only, get the result for 123-ABC1441512/2.

ERROR

"Wildcard query resulted in too many results, please refine your criteria and try again."

STEPS

The issue can be reproduced at will with the following steps:

1. Search item 123-ABC1441512/2 in both quick search and Custom Search->Basic search
2. The error message is displayed.

Cause

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