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>