Call Fusion BIP Using ExternalReportWSSService Webservice

In this Post I will outline the steps to call a webservice using SOAP UI.

you need below components to get start with .

1. A report Created in ERP Cloud

2. An obsolete path of the report

3. Parameters if any

4. Credentials for ERP Cloud

WSDL: https://fa-esbcd-dev99-saasfademo1.ds-fa.oraclepdemos.com/xmlpserver/services/ExternalReportWSSService?WSDL

Sample payload looks like below .

Operation : runReport

I have given the Input Information Highlighted as below.

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soap:Header/>
   <soap:Body>
      <pub:runReport>
         <pub:reportRequest>
            <pub:attributeFormat>pdf</pub:attributeFormat>
            <!--Flatten XML should always be false when we have XML type of output to display the XML tags as mentioned in BIP Data Model and display XML structure in as expected format-->
            <pub:flattenXML>false</pub:flattenXML>
            <pub:parameterNameValues>
               <!--1st Parameter of BIP Report-->
               <pub:item>
                  <pub:name>P_Supplier_Name</pub:name>
                  <pub:values>
                     <pub:item>Building Management</pub:item>
                  </pub:values>
               </pub:item>
               <!--2ns Parameter of BIP Report-->
            </pub:parameterNameValues>
            <pub:reportAbsolutePath>/Custom/FUSIONGOEASY/AP Invoice Supplier Report.xdo</pub:reportAbsolutePath>
            <!--Setting sizeOfDataChunkDownload to -1 will return the output to the calling client-->
            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
         </pub:reportRequest>
      </pub:runReport>
   </soap:Body>
</soap:Envelope>

Add the Payload , Enter the Basic Credentials and Hit Run.

Received the Encoded Response :

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
   <env:Header/>
   <env:Body>
      <ns2:runReportResponse xmlns:ns2="http://xmlns.oracle.com/oxp/service/PublicReportService">
         <ns2:runReportReturn>
            <ns2:reportBytes>JVBERi0xLjYNCjUgMCBvYmoNCjw8DQovVHlwZSAvWE9iamVjdA0KL1N1YnR5cGUgL0ltYWdlDQov
RmlsdGVyIC9GbGF0ZURlY29kZQ0KL0xlbmd0aCAxMjIxDQovV2lkdGggMTU1DQovSGVpZ2h0IDIw
DQovQml0c1BlckNvbXBvbmVudCA4DQovQ29sb3JTcGFjZSAvRGV2aWNlUkdCDQo+Pg0Kc3RyZWFt
DQp4nMWaPU9UQRSGf62draWNnTba2CiFJtpoYaERDdFEExNNICgJZo0bviKQhQC7usDCCvjAkJOX
mbuzM3Nv3MkplsvM3HPOez5nbnt9px3Qvedfnr1f/PB1NYWYyfxrd16F+0C3Hn1M3Efpwcu563df
V244im4+nJldXGmtdl58bGUthGAeEViYyN7057ZbyA9TQu5LQ0JkBE9nw17KKn4/fvPNQ4ENed4f
HJ/lj4PjIZyEKPCugt0Y3YMBSk5UxY37b3uHR7YWYdN1CCgHg2EWb1PT8275Tu/APfn5qxaU8A/P
J6en6Tww+fbTT877nswsIAWAql1h4RvbvSy5wrHT28clGwHUDfOFOC20N72FKcYAq4ZI+iAI2A6N
AAqruEMuG+/mlt1yQESQ78sdF2QMTTxC5w9PTlY2uyl0NPyrC7F2xVQB3er2Uzb0pBsLTaXNdHb/
xIM2THqc82cKe+iqQUCRLmQez4rz8GNt26RDEMweb3VO2r7IIOqbIIsLp6cwF/n3fh8qcLZctc3v
lA3hB95s1VqnF3+7muLSRtd+R7ybVR7DBVm7PqDYhhoVRpioIo8cmrYWP1XbIJ4X7MmqSmUWAOqI
GGILIyyRemwaUYiZ5uBkGS/+GzFTbaAAykYAVRlnW+ujCsssYhO18FEaSCHsjUDt9sHwnJaKASVK
2EKX/UPSeLW7f+jeqAvx7lBLTDM+kb3MgOsDiqrVjxpBs33hraFbFZM6u4OvGFDdqhJQcCFGhZuj
GbKMPQ+7GGWpZrtRB1BNK2WRdqze6rinI6zdM48yQD2wKkOiKoQqV/+FINYCECu0jGlfjdJ13LMm
oBpviSSJJaiRVbkeaTZpxOstmtHmFwAKD/ijupgHVggZSTPEReWiJtR/WY/DwprC1gG0TpOIkj0r
NVJzbQRQK9vI8pWAZrVd7BbGDS+oVoZNr4519bwHKJtPElAJQbkjcho2kZDLi6hhxrJNS1vZhIKg
zaksexzpq/uDY/Nidd4JhlzihrGRdS4K/xHXm1RRhCbjMQcHr9Q2oUYdHP4xj1EE3LphCHTBwW9T
gIa6aoS0bYlE5hRC/4PhparR+di2hQlqpQzqBGJjPFBoLeFsdWtvP2IYOpy/817LC+q5/xlQVG2M
jT3XyiJt3FBOWeD1joLN8uNFEVJoEh/rMrobKdIpQYNMfNgSrZBhu9iMax4s6BE0v5vC1Ksx8FO0
mm637o7GO8LKOvpT9Z5dJJRK0Xio1yKaXj2riAxX7bOV+jXMI8JEjv5UIuyNANUIrMCnNaHhMrYb
CvMgQUwNPrFtmZqet37n7KLRCC2KPsgmWEI0rCOZFBe2O0G7deJ5eFE49lTcyLFngJJisrrIpY2u
q1gwSxXcDbZN2USP6Csx1cPYshGGr/Q+9LydEXNFKA3+espX2XjGSdMK/YKrEmG1U9Q7WFNfcPtm
Ipii1N6yBkLFpUZMXL6MSdoQolZYTmcdLHgXlEhtZcxWt58uSKVoWvFapnb5wrs6jA9LxOdBo7Ve
oKuzoHe+vGfPuRUlyKefG6BYkLXvK+IfYzBz1OF5++onKCnlFq6H/WvPxRP21zeWHYAoJ2ErxysS
RVZh3dVh7gc2o0RwX8LARsomowq5f133ax0NCmVuZHN0cmVhbQ0KZW5kb2JqDQo5IDAgb2JqDQo8
PC9UeXBlL1hPYmplY3QvU3VidHlwZS9Gb3JtL0Zvcm1UeXBlIDEvQkJveFswIDAgNjEyLjAgNzky
LjBdIC9MZW5ndGggMTIzIC9GaWx0ZXIgL0ZsYXRlRGVjb2RlID4+DQpzdHJlYW0NCnic07MwM1PQ
gxNB7rxceqhCRem8XAYKIBjkrgBhgIScQni5DME8QwUTY2M9I1MFc2MzPTMzY4WQXF4ufTdDXi4F
S4WQNF4ujYDE9FQFzZAsJB2mZnrmQMORtWgYoioxMwQqsURVouCfhmaQuZmekTlWg1yBLgQAg+sq
Xg0KZW5kc3RyZWFtDQplbmRvYmoNCjcgMCBvYmoNCjw8IC9MZW5ndGggMjU5IC9GaWx0ZXIgL0Zs
YXRlRGVjb2RlID4+DQpzdHJlYW0NCniclVDNSsNAEL4H9h2+Yz10szs7k01yLFXpQaySF6gl9YcG
MSr4+M4maCBKUWaZWWaY72c8vMbt5VA8+nuThYgY2DITvCtB3gYtfYuDyV5QVDYKnIZ31glCtCSI
LJYF+w75pnNYP+PGZF47X0hUzpDcgKHE4ycRrxrdGaFB4iwlJRytKyKazmT5hTcZKjS6vrjud/tj
i9UG2/e74+PrQ9ufNU8J4Iehc8XlECZXzP/Sorujx0nKYr17a2uQI1o6XroITzVLTQHbq0FHIs0P
H+kWJrNlUWBKyjTrJEqJRTptUukrgpUksvwWGU5O1dOpMQf6A7aIDoSdZn2/0c6GnzhSc7ENCmVu
ZHN0cmVhbQ0KZW5kb2JqDQoxIDAgb2JqDQo8PA0KL1R5cGUgL0NhdGFsb2cNCi9QYWdlcyAzIDAg
Ug0KPj4NCmVuZG9iag0KMiAwIG9iag0KPDwNCi9UeXBlIC9JbmZvDQovUHJvZHVjZXIgKE9yYWNs
ZSBCSSBQdWJsaXNoZXIpDQo+Pg0KZW5kb2JqDQozIDAgb2JqDQo8PA0KL1R5cGUgL1BhZ2VzDQov
S2lkcyBbDQo2IDAgUg0KXQ0KL0NvdW50IDENCj4+DQplbmRvYmoNCjQgMCBvYmoNCjw8DQovUHJv
Y1NldCBbIC9QREYgL1RleHQgXQ0KL0ZvbnQgPDwgDQovRjEgOCAwIFINCj4+DQovWE9iamVjdCA8
PCANCi9JbTAgNSAwIFINCi9meDAgOSAwIFINCj4+DQo+Pg0KZW5kb2JqDQo2IDAgb2JqDQo8PA0K
L1R5cGUgL1BhZ2UNCi9QYXJlbnQgMyAwIFINCi9SZXNvdXJjZXMgNCAwIFINCi9Db250ZW50cyA3
IDAgUg0KL01lZGlhQm94WyAwIDAgNjEyLjAgNzkyLjAgXQ0KL0Nyb3BCb3hbIDAgMCA2MTIuMCA3
OTIuMCBdDQovUm90YXRlIDANCj4+DQplbmRvYmoNCjggMCBvYmoNCjw8DQovVHlwZSAvRm9udA0K
L1N1YnR5cGUgL1R5cGUxDQovQmFzZUZvbnQgL0hlbHZldGljYQ0KL0VuY29kaW5nIC9XaW5BbnNp
RW5jb2RpbmcNCj4+DQplbmRvYmoNCjEwIDAgb2JqDQpbIDYgMCBSIC9YWVogMzAuNiA3MzQuMTky
IG51bGwgXQ0KZW5kb2JqDQoxMSAwIG9iag0KWyA2IDAgUiAvWFlaIDMwLjYgNzM0LjE5MiBudWxs
IF0NCmVuZG9iag0KeHJlZg0KMCAxMg0KMDAwMDAwMDAwMCA2NTUzNSBmDQowMDAwMDAyMDEyIDAw
MDAwIG4NCjAwMDAwMDIwNjcgMDAwMDAgbg0KMDAwMDAwMjEzOCAwMDAwMCBuDQowMDAwMDAyMjA2
IDAwMDAwIG4NCjAwMDAwMDAwMTAgMDAwMDAgbg0KMDAwMDAwMjMyNCAwMDAwMCBuDQowMDAwMDAx
Njc1IDAwMDAwIG4NCjAwMDAwMDI0ODIgMDAwMDAgbg0KMDAwMDAwMTQxNSAwMDAwMCBuDQowMDAw
MDAyNTg3IDAwMDAwIG4NCjAwMDAwMDI2MzkgMDAwMDAgbg0KdHJhaWxlcg0KPDwNCi9TaXplIDEy
DQovUm9vdCAxIDAgUg0KL0luZm8gMiAwIFINCi9JRCBbPGFkMjIwM2ZhNTk5OTIzZTFhNjMxZTg0
YzQwNGRjZjU1PjxhZDIyMDNmYTU5OTkyM2UxYTYzMWU4NGM0MDRkY2Y1NT5dDQo+Pg0Kc3RhcnR4
cmVmDQoyNjkxDQolJUVPRg0K</ns2:reportBytes>
            <ns2:reportContentType>application/pdf</ns2:reportContentType>
            <ns2:reportFileID xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns2:reportLocale xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns2:metaDataList xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
         </ns2:runReportReturn>
      </ns2:runReportResponse>
   </env:Body>
</env:Envelope>

Lets Decode the same using https://base64.guru/converter/decode/file

you can see that the actual file contains the data decoded as below.

Hope this Helps .

Happy learning..