11 Replies Latest reply: Jan 31, 2014 7:08 AM by Jani Rautiainen RSS

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

2d19fbc5-9100-40cb-b0ee-e2498c465cd9 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points