"Invalid Query Parameter Value" Error While Trying To Invoke RMS Rest API From SOA Rest Binding

(Doc ID 2339997.1)

Last updated on JANUARY 04, 2018

Applies to:

SOA Suite Cloud Service - Version N/A and later
Information in this document applies to any platform.


On : SOA / SOA Cloud

While invoking REST service through REST Binding in SOA, calls fail with below error 



<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<tracking:faultId xmlns:tracking="http://oracle.soa.tracking.core.TrackingProperty">270160</tracking:faultId>
<faultstring>Bad Request</faultstring>
"type": "https:/flowlogistics--tst.custhelp.com/services/rest/connect/exceptions/OSC-CREST-00019",
"title": "Invalid query parameter value",
"status": 400,
"detail": "This query is not supported: near \"*\": syntax error",
"instance": "https://testhost/services/rest/connect/v1.3/queryResults/?query=select+*+from+Incidents+where+Incidents.CustomFields.CO.status_set%3D1",
"o:errorCode": "OSC-CREST-00019"

The issue can be reproduced at will with the following steps:
1. Call REST Service from SOA Suite through REST Binding.



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