Simple Search Using Wildcard Is Not Working as Expected for Item Number With Space (Doc ID 1957126.1)

Last updated on JANUARY 24, 2024

Applies to:

Symptoms

Actual Behavior
Simple search using wildcard is not working as expected for item number with space.
For example, trying to search for item with number "9" at the 5th digit, but item with number "9" at the 5th digit after the space is searched

Expected Behavior
Can search only for the item with number "9" at the 5th digit

Steps
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Create below items (this are sample numbers)
10A563 00849
10A604 00859
10A699 00929     ---> This is the only item with number "9" at the 5th digit
10A689 00921
3. Run Simple Search with below string：
????9*

4. See below items are returned:
10A563 00849
10A604 00859
10A699 00929

Instead of only returning the item with "9" at the 5th digit, it is returning item with "9" at the 5th digit after the space also.

Cause

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