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 NOVEMBER 23, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.3.0 and later
Information in this document applies to any platform.

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

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