APEX

Hi everyone, im new in apex and im trying to call and consume a soap webservice from oracle database using APEX_WEB_SERVICE, i have oracle 12.2.0.1 and APEX 19.1.

the webservice is working fine from SOAP UI, the wsdl file is attached "WS.txt"

i have created the b@elow function as a sample to test the call of this ws:

CREATE OR REPLACE FUNCTION LUAY_APEX_TRAINING.test (p_int_1  IN  NUMBER,

                                        p_int_2  IN  NUMBER)

  RETURN NUMBER

AS

  l_envelope  CLOB;

  l_xml       XMLTYPE;

  l_result    VARCHAR2(32767);

BEGIN

  -- Build a SOAP document appropriate for the web service.

  l_envelope := '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tcib="http://temenos.com/TCIBSelfReg">

   <soapenv:Header/>

   <soapenv:Body>

      <tcib:TCIBSelfRegistrationARRtst>

         <!--Optional:-->

         <WebRequestCommon>

            <!--Optional:-->

            <company>PS0010001</company>

            <password>Adham@321</password>

            <userName>U1007901</userName>

         </WebRequestCommon>

         <!--Optional:-->

         <OfsFunction>

            <!--Optional:-->

            <activityName></activityName>

            <!--Optional:-->

            <assignReason></assignReason>

            <!--Optional:-->

            <dueDate></dueDate>

            <!--Optional:-->

            <extProcess></extProcess>

            <!--Optional:-->

            <extProcessID></extProcessID>

            <!--Optional:-->

            <gtsControl></gtsControl>

            <!--Optional:-->

            <messageId></messageId>

            <!--Optional:-->

            <noOfAuth></noOfAuth>

            <!--Optional:-->

            <owner></owner>

            <!--Optional:-->

            <replace></replace>

            <!--Optional:-->

            <startDate></startDate>

            <!--Optional:-->

            <user></user>

         </OfsFunction>

         <!--Optional:-->

         <AAARRANGEMENTACTIVITYTCIBSELFRRRType id="">

            <!--Optional:-->

            <Arrangement>NEW</Arrangement>

            <!--Optional:-->

            <Activity>INTERNET.SERVICES-NEW-ARRANGEMENT</Activity>

            <!--Optional:-->

            <EffectiveDate>2018-04-04</EffectiveDate>

            <!--Optional:-->

            <Customer>12</Customer>

            <!--Optional:-->

            <Product>TCIB.PERSONAL</Product>

         </AAARRANGEMENTACTIVITYTCIBSELFRRRType>

      </tcib:TCIBSelfRegistrationARRtst>

   </soapenv:Body>

</soapenv:Envelope>';

  -- Get the XML response from the web service.

  l_xml := APEX_WEB_SERVICE.make_request(

    p_url      => 'http://10.60.60.61:8080/TCIBSelfReg/services',

    p_action   => 'http://10.60.60.61:8080/TCIBSelfReg/TCIBSelfRegistrationAAActivity',

    p_envelope => l_envelope

  );

  -- Display the whole SOAP document returned.

  DBMS_OUTPUT.put_line('l_xml=' || l_xml.getClobVal());

  -- Pull out the specific value of interest.

  l_result := APEX_WEB_SERVICE.parse_xml(

    p_xml   => l_xml,

    p_xpath => '//return/text()',

    p_ns    => 'xmlns:ns1="http://temenos.com/TCIBSelfReg"'

  );

  DBMS_OUTPUT.put_line('l_result=' || l_result);

  RETURN TO_NUMBER(l_result);

END;

when i call the function i always end up with the error attached "ws error.txt"

can anyone guide me plz.

really appreciated.

BR