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
Tagged:
0