OBIEE - SoapUI - Unable to send a parameter in SOAP XML using executeXMLQuery
<p>I am using SoapUI to send a request to (OBIEE) Oracle BI EE Web Services.</p>

<p>I am trying to send a parameter in an OBIEE SOAP XML.</p>

<p>I am using executeXMLQuery() Method, and trying to send a parameter to a report, but it doesn't work.</p>

<p>I am trying to send the parameter in the 'variables' node like so: </p>

<pre><code>&lt;v6:variables&gt;
    &lt;v6:name&gt;PARAMETER_NAME&lt;/v6:name&gt;
    &lt;v6:value&gt;PARAMETER_VALUE&lt;/v6:value&gt;
&lt;/v6:variables&gt;
</code></pre>

<p>But this does not work, what am I doing wrong?</p>

<p>Can someone send me example (that works) of how to send a parameter to a report in the XML?</p>

<p>Here is my SOAP XML:</p>

<pre><code>    &lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6"&gt;
   &lt;soapenv:Header/&gt;
   &lt;soapenv:Body&gt;
      &lt;v6:executeXMLQuery&gt;
         &lt;v6:report&gt;
            &lt;v6:reportPath&gt;/shared/XXXXXX/Projects details&lt;/v6:reportPath&gt;
            &lt;v6:reportXml&gt;&lt;/v6:reportXml&gt;
         &lt;/v6:report&gt;
         &lt;v6:outputFormat&gt;&lt;/v6:outputFormat&gt;
         &lt;v6:executionOptions&gt;
            &lt;v6:async&gt;false&lt;/v6:async&gt;
            &lt;v6:maxRowsPerPage&gt;500&lt;/v6:maxRowsPerPage&gt;
         &lt;/v6:executionOptions&gt;
         &lt;v6:reportParams&gt;
            &lt;!--Zero or more repetitions:--&gt;
            &lt;v6:filterExpressions&gt;
            &lt;/v6:filterExpressions&gt;
            &lt;!--Zero or more repetitions:--&gt;
            &lt;v6:variables&gt;
               &lt;v6:name&gt;Project Name&lt;/v6:name&gt;
               &lt;v6:value&gt;XXXX&lt;/v6:value&gt;
            &lt;/v6:variables&gt;
         &lt;/v6:reportParams&gt;
         &lt;v6:sessionID&gt;XXXX&lt;/v6:sessionID&gt;
      &lt;/v6:executeXMLQuery&gt;
   &lt;/soapenv:Body&gt;
&lt;/soapenv:Envelope&gt;
</code></pre>

<p>I get the following response:</p>

<pre><code>&lt;soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:saw-SOAP="com.siebel.analytics.web/soap/v6"&gt;
   &lt;soap:Body&gt;
      &lt;soap:Fault&gt;
         &lt;faultcode&gt;soap:Server&lt;/faultcode&gt;
         &lt;faultstring&gt;Sax parser returned an exception.
Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 2, Column number: 4&lt;/faultstring&gt;
         &lt;detail&gt;
            &lt;sawsoape:Error xmlns:sawsoape="com.siebel.analytics.web/soap/error/v1"&gt;
               &lt;sawsoape:Code&gt;UH6MBRBC&lt;/sawsoape:Code&gt;
               &lt;sawsoape:Message&gt;Sax parser returned an exception.
Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 2, Column number: 4&lt;/sawsoape:Message&gt;
               &lt;sawsoape:File&gt;project/webxml/saxreader.cpp&lt;/sawsoape:File&gt;
               &lt;sawsoape:Line&gt;681&lt;/sawsoape:Line&gt;
               &lt;sawsoape:LogSources&gt;
                  &lt;sawsoape:LogSource&gt;saw.soap.xmlviewservice&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.SOAP&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.httpserver.request.soaprequest&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.rpc.server.responder&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.rpc.server&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.rpc.server.handleConnection&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.rpc.server.dispatch&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.threadpool.socketrpcserver&lt;/sawsoape:LogSource&gt;
                  &lt;sawsoape:LogSource&gt;saw.threads&lt;/sawsoape:LogSource&gt;
               &lt;/sawsoape:LogSources&gt;
               &lt;sawsoape:Error&gt;
                  &lt;sawsoape:Code&gt;E6MUPJPH&lt;/sawsoape:Code&gt;
                  &lt;sawsoape:Message&gt;Xml parsed:&lt;/sawsoape:Message&gt;
               &lt;/sawsoape:Error&gt;
            &lt;/sawsoape:Error&gt;
         &lt;/detail&gt;
      &lt;/soap:Fault&gt;
   &lt;/soap:Body&gt;
&lt;/soap:Envelope&gt;
</code></pre>

<p>Please help.</p>

<p><strong>Update:</strong><br>
Thanks <strong>Rao</strong>, I fixed one mistake, now I have the following error: </p>

<pre><code>line 13: Expected element 'refresh@urn://oracl‌​e.bi.webservices/v6' before the end of the content in element executionOptions@urn‌​://oracle.bi.webservi‌​ces/v6 
</code></pre>

<p>Line 13 is <code>&lt;/v6:executionOptio‌​ns&gt;</code> I don't understand, what should I do?</p>

<p>Thanks</p>