Sandeep Satyavolu

Apr 7, 20221 min

Call Fusion BIP Using ExternalReportWSSService Webservice

Updated: Apr 14, 2022

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..

    46720
    0