PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

QAS_EXECUTEQRY_REST_GET Failing with "The number or the names of the prompts received do not match t

edited Nov 18, 2021 9:15PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered

When we use the QAS_EXECUTEQRY_REST_GET service operation without using any UniquePromptName we are not having any issue when going through SOA.

When we use the QAS_EXECUTEQRY_REST_GET service operation with Bind Variables it is failing with the error message, "The number or the names of the prompts received do not match the query (228,4)" when going through SOA.

The comma between the bind variables is being replaced with %2C.

The IB Info shows it coming in as prompt_uniquepromptname=BIND1%2CBIND2%2CBIND3.

The following is the URI Resource.

<URIResource><![CDATA[PUBLIC/MY_QUERY_NAME/JSON/NONFILE?isconnectedquery=N&maxrows=0&prompt_psqueryname=&prompt_uniquepromptname=BIND1%2CBIND2%2CBIND3&prompt_fieldvalue=LAST%2CFIRST%2CZIP&filterfields=&json_resp=true]

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center