1 2 Previous Next 19 Replies Latest reply: May 6, 2014 4:47 AM by Jani Rautiainen-Oracle RSS

    Need Help: Not able to invoke fusion crm webservice using SOAP UI

    2d19fbc5-9100-40cb-b0ee-e2498c465cd9

      Hi,

       

      I am trying to invoke fusion crm webservice by using SOAP UI, but I am getting Invalid seccurity tocken exception.

       

      I have followed below steps specified in the oracle support document.

       

      In Soap UI, Go to File>Preferences ,select the "HTTP Settings' tab on the lower left panel, then select the checkbox 'Authenticate Preemtively'.

       

      2. From the wsdl extract the content from above wsdl between the tag/elements <dsig:X509Certificate> and </dsig:X509Certificate>


      3. Create a file called certificate.cer ( in local Drive) with above encrypted data enclosed between -----BEGIN CERTIFICATE-----   and -----END CERTIFICATE-----, file content shown below ( note: encrypted data 

          for example
          -----BEGIN CERTIFICATE-----

      MIICCzCCAXSgAwIBAgIETy

          -----END CERTIFICATE-----


      4. Identifiy the java.home of SOAP UI , navigation (Help – System Properties) ,example ( it may be something like D:\SOAP UI download\soapui-4.5.1\jre)


      5.  Find the location of cacert file in SOAP UI ( example D:\SOAP UI download\soapui-4.5.1\jre\lib\security\cacert)


      6. Use following keytool command to add the certificate file certificate.cer into keystore cacert , sample command given below for reference


         keytool -importcert -alias rcpt-key-alias -file "D:\certificate.cer" -keystore "D:\SOAP UI download\soapui-4.5.1\jre\lib\security\cacerts"
         at command prompt when prompted enter password as changeit

       

      7. Restart SOAP UI and create a new project with https version of WSDL of organizationService


      8. In SOAP UI ,  in Auth tab , provide the user name and password.

       

      9. Invoke the Webservice

       

      I have used following request XML in SOAP UI

      ----------------------------------------------------------------------------------------------

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/types/" xmlns:opp="http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/" xmlns:rev="http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:not="http://xmlns.oracle.com/apps/crmCommon/notes/noteService" xmlns:not1="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:rev1="http://xmlns.oracle.com/oracle/apps/sales/opptyMgmt/revenues/revenueService/" xmlns:act="http://xmlns.oracle.com/apps/crmCommon/activities/activitiesService/" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:soap="soap" xmlns:ns1="http://xmlns.oracle.com/apps/fnd/soaprovider/plsql/fnd_user_pkg/">

         <soapenv:Header>

            <fmw-context xmlns="http://xmlns.oracle.com/fmw/context/1.0"/>

            <wsse:Security soap:mustUnderstand="1">

               <wsse:UsernameToken>

                  <wsse:Username>userName</wsse:Username>

                  <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">Password</wsse:Password>

               </wsse:UsernameToken>

            </wsse:Security>

         </soapenv:Header>

         <soapenv:Body>

            <typ:createOpportunity>

               <typ:opportunity>

                  <opp:BudgetedFlag>1</opp:BudgetedFlag>

               </typ:opportunity>

            </typ:createOpportunity>

         </soapenv:Body>

      </soapenv:Envelope>

       

      It would be great help if someone guide me on this...

       

      Thanks & Regards

      Samanta Mishra

        1 2 Previous Next