Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex_web_service.parse_xml returning NULL value

ShjadhavNov 6 2019 — edited Dec 17 2019

Hi Team,

Below is the SOAP web service Response I am getting after calling the "apex_web_service.make_request". I am trying to parse this response and fetch the value of TransactionNumber using the sample code below and getting the NULL result. Can anyone help me to resolve this issue? I want to fetch actual value i.e. 42765

Sample Code -->

l_response := apex_web_service.parse_xml(

     p_xml => <Response XML>,

     p_xpath =>'//InvoiceService/createSimpleInvoiceResponse/InvoiceResult/TransactionNumber/text()'

     );

Web Service Response -->

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">

   <env:Header>

      <wsa:Action>http://xmlns.oracle.com/apps/financials/receivables/transactions/invoices/invoiceService//InvoiceService/createSimpleInvoiceResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:aa95f5dc-c774-4f0c-b628-96681dd700a1</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:createSimpleInvoiceResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/receivables/transactions/invoices/invoiceService/types/">

         <ns0:result xsi:type="ns2:InvoiceResult" xmlns:ns2="http://xmlns.oracle.com/apps/financials/receivables/transactions/invoices/invoiceService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns2:ServiceStatus>S</ns2:ServiceStatus>

            <ns2:TransactionNumber>42765</ns2:TransactionNumber>

            <ns2:CustomerTrxId>300000188532182</ns2:CustomerTrxId>

         </ns0:result>

      </ns0:createSimpleInvoiceResponse>

   </env:Body>

</env:Envelope>

Regards,

Sharad J

This post has been answered by fac586 on Nov 9 2019
Jump to Answer
Comments
Post Details
Added on Nov 6 2019
2 comments
265 views