In This Blog I will Show you How to call an OTBI report using Webservice .
Calling OTBI using Webservice is Slightly different then the BIP reports . Here first
We need to Generate the Session id using another method and the same Session id to be passed to Another Method along with OTBI report Path and parameters.
Setp1: Generate Session ID:
Method : logon
Sample Payload :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7">
<soapenv:Header/>
<soapenv:Body>
<v7:logon>
<v7:name>test.user</v7:name>
<v7:password>Dummy1234567</v7:password>
</v7:logon>
</soapenv:Body>
</soapenv:Envelope>
Response :
<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:sawsoap="urn://oracle.bi.webservices/v7">
<soap:Body>
<sawsoap:logonResult>
<sawsoap:sessionID xsi:type="xsd:string">1vqbi3ssfehkf59g58dsj2nia0vcl5hpccet77t47qqoqlt9zOr07UFe9WaTpOo</sawsoap:sessionID>
</sawsoap:logonResult>
</soap:Body>
</soap:Envelope>Capture the above Session Id String ...
Now Go to the Another Method
executeXMLQuery:
Request Payload :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7">
<soapenv:Header/>
<soapenv:Body>
<v7:executeXMLQuery>
<v7:report>
<v7:reportPath>/Shared/Custom/Demo/Fusiongoeasy Analysis Invoices</v7:reportPath>
<v7:reportXml></v7:reportXml>
</v7:report>
<v7:outputFormat>csv</v7:outputFormat>
<v7:executionOptions>
<v7:async></v7:async>
<v7:maxRowsPerPage></v7:maxRowsPerPage>
<v7:refresh></v7:refresh>
<v7:presentationInfo></v7:presentationInfo>
<v7:type></v7:type> </v7:executionOptions>
<v7:reportParams>
<!--Zero or more repetitions:-->
<v7:filterExpressions></v7:filterExpressions>
<!--Zero or more repetitions:-->
<v7:variables>
<v7:name>Supplier or Party Name</v7:name>
<v7:value>Epson Printers</v7:value>
</v7:variables>
<!--Zero or more repetitions:-->
<!--<v7:nameValues>
<v7:name>?</v7:name>
<v7:value>?</v7:value>
</v7:nameValues> -->
<!--Zero or more repetitions:-->
<v7:templateInfos>
<v7:templateForEach></v7:templateForEach>
<v7:templateIterator></v7:templateIterator>
<!--Zero or more repetitions:-->
<v7:instance>
<v7:instanceName></v7:instanceName>
<!--Zero or more repetitions:-->
<v7:nameValues>
<v7:name></v7:name>
<v7:value></v7:value>
</v7:nameValues>
</v7:instance>
</v7:templateInfos>
<!--Optional:-->
<v7:viewName></v7:viewName>
</v7:reportParams>
<v7:sessionID>1vqbi3ssfehkf59g58dsj2nia0vcl5hpccet77t47qqoqlt9zOr07UFe9WaTpOo</v7:sessionID>
</v7:executeXMLQuery>
</soapenv:Body>
</soapenv:Envelope>Report Path , Parameters and Session id is added to the Payload as Highlighted
Response Payload :
<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:sawsoap="urn://oracle.bi.webservices/v7">
<soap:Body>
<sawsoap:executeXMLQueryResult>
<sawsoap:return xsi:type="sawsoap:QueryResults">
<sawsoap:rowset xsi:type="xsd:string"><![CDATA[<rowset xmlns="urn:schemas-microsoft-com:xml-analysis:rowset">
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_11</Column2>
<Column3>2022-11-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_10</Column2>
<Column3>2022-10-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_9</Column2>
<Column3>2022-09-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_8</Column2>
<Column3>2022-08-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD112</Column2>
<Column3>2022-07-25</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>25000</Column6>
<Column7>0</Column7>
<Column8>25000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>DR01</Column2>
<Column3>2022-07-24</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-10000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>II120-INT1</Column2>
<Column3>2022-07-24</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20.83</Column6>
<Column7>0</Column7>
<Column8>20.83</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>MPINV 01</Column2>
<Column3>2022-07-24</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7>0</Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>MPINV1</Column2>
<Column3>2022-07-24</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>6000</Column6>
<Column7>0</Column7>
<Column8>6000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>SELF B INV01</Column2>
<Column3>2022-07-24</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>20000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>DI211</Column2>
<Column3>2022-07-22</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>2000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>DI222</Column2>
<Column3>2022-07-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>30000</Column6>
<Column7>4500</Column7>
<Column8>25500</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>II123</Column2>
<Column3>2022-07-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>20000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>ii150-INT1</Column2>
<Column3>2022-07-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>1724.29</Column6>
<Column7>0</Column7>
<Column8>1724.29</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CR1002</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-3000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CR1004</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>-2000</Column6>
<Column7>0</Column7>
<Column8>-2000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PP1003</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>20000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PP2</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>20000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD1000</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7>0</Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD1001</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>15000</Column6>
<Column7>300</Column7>
<Column8>14700</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD1004</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>25000</Column6>
<Column7>0</Column7>
<Column8>25000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD1005</Column2>
<Column3>2022-07-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>30000</Column6>
<Column7>0</Column7>
<Column8>30000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_7</Column2>
<Column3>2022-07-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_6</Column2>
<Column3>2022-06-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_5</Column2>
<Column3>2022-05-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>INT156-INT1</Column2>
<Column3>2022-04-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>1197.97</Column6>
<Column7>0</Column7>
<Column8>1197.97</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>int999</Column2>
<Column3>2022-04-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>11000</Column6>
<Column7>0</Column7>
<Column8>11000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>zcm110</Column2>
<Column3>2022-04-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>-2500</Column6>
<Column7>0</Column7>
<Column8>-2500</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>zcm123</Column2>
<Column3>2022-04-22</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>2500</Column6>
<Column7>0</Column7>
<Column8>2500</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>zinv112</Column2>
<Column3>2022-04-22</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-10000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>3RDP001</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>28000</Column6>
<Column7>0</Column7>
<Column8>28000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CC143</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>30000</Column6>
<Column7>0</Column7>
<Column8>30000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PPR001</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>25000</Column6>
<Column7>0</Column7>
<Column8>25000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCINV001</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>60000</Column6>
<Column7>0</Column7>
<Column8>60000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCINV111</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>60000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>inv556-INT1</Column2>
<Column3>2022-04-21</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>1067.97</Column6>
<Column7>0</Column7>
<Column8>1067.97</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CM124</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-4000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>FX1</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>1000</Column6>
<Column7>0</Column7>
<Column8>1000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PA111</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>5000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PA123</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>2000</Column6>
<Column7>0</Column7>
<Column8>2000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PA55</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>8000</Column6>
<Column7>0</Column7>
<Column8>8000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>PP123</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7>0</Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CM1</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-3000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>CR1</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-2000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>INVCR1</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-2000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD1</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>5000</Column6>
<Column7>0</Column7>
<Column8>5000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD2</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>20000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD3</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>25000</Column6>
<Column7>0</Column7>
<Column8>25000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>STD4</Column2>
<Column3>2022-04-18</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>30000</Column6>
<Column7>0</Column7>
<Column8>30000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_4</Column2>
<Column3>2022-04-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>INT156</Column2>
<Column3>2022-03-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>55000</Column6>
<Column7>0</Column7>
<Column8>55000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_3</Column2>
<Column3>2022-03-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>int 144</Column2>
<Column3>2022-03-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>50000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>int632</Column2>
<Column3>2022-03-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>35000</Column6>
<Column7>0</Column7>
<Column8>35000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>inv556</Column2>
<Column3>2022-03-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>50000</Column6>
<Column7>0</Column7>
<Column8>50000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>INTINV159</Column2>
<Column3>2022-02-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7>0</Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_2</Column2>
<Column3>2022-02-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>INT143</Column2>
<Column3>2022-01-03</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>50000</Column6>
<Column7>0</Column7>
<Column8>50000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>int222</Column2>
<Column3>2022-01-03</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>40000</Column6>
<Column7>0</Column7>
<Column8>40000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>II120</Column2>
<Column3>2022-01-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>25000</Column6>
<Column7>0</Column7>
<Column8>25000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>RCC01_1</Column2>
<Column3>2022-01-01</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>ii150</Column2>
<Column3>2022-01-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>30000</Column6>
<Column7>0</Column7>
<Column8>30000</Column8>
</Row>
<Row>
<Column0>AK SUPPLIER1</Column0>
<Column1>AK SUPPLIER</Column1>
<Column2>ii001</Column2>
<Column3>2021-03-01</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>40000</Column6>
<Column7>0</Column7>
<Column8>40000</Column8>
</Row>
<Row>
<Column0>AK WHD SUP</Column0>
<Column1>AK ROAD</Column1>
<Column2>PA124</Column2>
<Column3>2022-04-19</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>4500</Column6>
<Column7>0</Column7>
<Column8>4500</Column8>
</Row>
<Row>
<Column0>BPO Supplier 1</Column0>
<Column1>BPO Address 1</Column1>
<Column2>1234</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7>0</Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 1</Column0>
<Column1>BPO Address 1</Column1>
<Column2>2222</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>20000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>BPO Supplier 1</Column0>
<Column1>BPO Address 1</Column1>
<Column2>5555</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>20000</Column6>
<Column7>0</Column7>
<Column8>18000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 1</Column0>
<Column1>BPO Address 1</Column1>
<Column2>CM1</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>-1000</Column6>
<Column7>0</Column7>
<Column8>-900</Column8>
</Row>
<Row>
<Column0>BPO Supplier 1</Column0>
<Column1>BPO Address 1</Column1>
<Column2>DM1</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>-2000</Column6>
<Column7>0</Column7>
<Column8>-1800</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>145</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>1500</Column6>
<Column7>0</Column7>
<Column8>1500</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>257</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>17000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>258</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>14000</Column6>
<Column7>0</Column7>
<Column8>14000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>259</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>16000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>365</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>1000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>369</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>10000</Column6>
<Column7></Column7>
<Column8>10000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>456</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>13000</Column6>
<Column7>0</Column7>
<Column8>13000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>4896</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>22000</Column6>
<Column7>0</Column7>
<Column8>22000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>789</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>12000</Column6>
<Column7></Column7>
<Column8></Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>Prepayment</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>50000</Column6>
<Column7>0</Column7>
<Column8>50000</Column8>
</Row>
<Row>
<Column0>BPO Supplier 2</Column0>
<Column1>BPO Address 2</Column1>
<Column2>WHT 1</Column2>
<Column3>2022-05-12</Column3>
<Column4>Check</Column4>
<Column5>Fully paid</Column5>
<Column6>75000</Column6>
<Column7>0</Column7>
<Column8>75000</Column8>
</Row>
<Row>
<Column0>BPO Tax Authority</Column0>
<Column1>BPO Tax Address 1</Column1>
<Column2>Withholding tax-300000137203701-2</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>2000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>BPO Tax Authority</Column0>
<Column1>BPO Tax Address 1</Column1>
<Column2>Withholding tax-300000137203718-2</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>2000</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>BPO Tax Authority</Column0>
<Column1>BPO Tax Address 1</Column1>
<Column2>Withholding tax-300000137203720-2</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-200</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
<Row>
<Column0>BPO Tax Authority</Column0>
<Column1>BPO Tax Address 1</Column1>
<Column2>Withholding tax-300000137203722-2</Column2>
<Column3>2022-05-11</Column3>
<Column4>Check</Column4>
<Column5>Not paid</Column5>
<Column6>-100</Column6>
<Column7>0</Column7>
<Column8>0</Column8>
</Row>
</rowset>]]></sawsoap:rowset>
<sawsoap:queryID xsi:type="xsd:string">RSXS3_1</sawsoap:queryID>
<sawsoap:finished xsi:type="xsd:boolean">true</sawsoap:finished>
</sawsoap:return>
</sawsoap:executeXMLQueryResult>
</soap:Body>
</soap:Envelope>your report output is Here .
That's All.. Easy Right ! Happy Learning
Comments