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