You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

26C Upgrade- Wildcard Search Using Leading % Returns EGP-2775668 Error

Hello All,

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/26b/fasrp/op-itemsv2-get.html

After the 26C release, we are seeing a change in wildcard search behavior.

Previously, we were able to use queries such as:

ItemNumber LIKE '%item%' OR ItemDescription LIKE '%itemdesc%'

After upgrading to 26C, this now returns the following error:

The remote server returned an error: (400) Bad Request. Keyword searches cannot begin with a wildcard character: percent sign (%), asterisk (*), or underscore (_). (EGP-2775668)

However, using * instead of % works successfully, for example:

ItemNumber LIKE '*item*' OR ItemDescription LIKE '*itemdesc*'

Is this an intentional change in

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!