"Invalid Query Parameter Value" Error While Trying To Invoke RMS Rest API From SOA 12.2.1.2.0 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.

Symptoms

On : 12.2.1.2.0 SOA / SOA Cloud

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

 

ERROR
-----------------------

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Header>
<tracking:faultId xmlns:tracking="http://oracle.soa.tracking.core.TrackingProperty">270160</tracking:faultId>
</env:Header>
<env:Body>
<env:Fault>
<faultcode>env:Server</faultcode>
<faultstring>Bad Request</faultstring>
<faultactor/>
<detail>
<exception>{
"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"
}</exception>
</detail>
</env:Fault>
</env:Body>
</env:Envelope>


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

 

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