1 Reply Latest reply: Sep 19, 2012 5:06 PM by kmacpher67 RSS

    How to add credentials to SOAP header from OBIEE 11g->EBS SOA Web Service

    Ahsan Shah

      I am trying to invoke a webservice that I successfully exposed as a WSDL Web Service using EBS Integrated SOA Gateway. I am using OBIEE 11g Action Framework which uses WebLogic.

      Here are the steps I completed:

      - I exposed a WSDL web service in EBS R12 via Integrated SOA Gateway
      - I granted the access to this service in EBS R12 to user SYSADMIN
      - I used OBIEE 11g to make a Action to call the Web service (using Action Framework) by searching for the WSDL
      - When I try to execute the action: I get the error:

      Action could not be invoked.
      ServiceExecutionFailure :
      Error invoking web service HR_PHONE_API_Service at endpoint http://ip-10-87-33-3.ec2.internal:8000/webservices/SOAProvider/plsql/hr_phone_api/ Missing <wsse:Security> in SOAP Header

      PROBLEM: I am unsure how to add the credentials for SYSADMIN user and password to add the SOAP username/pwd to the outgoing call. Anyone on this forum know how to set up the SOAP to call with the correct credentials? I have been looking at the documentation but it is not clearly explained.
        • 1. Re: How to add credentials to SOAP header from OBIEE 11g->EBS SOA Web Service
          This is discussed in the docs, it's suggested to use ASADMIN account, not SYSADMIN, your call.


          Create the grants for that EBS User:

          Assuming you configured the WSDL to use 2 factor authentication and not SAML. I generated this from SOAPUI and copy it to all my requests. I could never find it so I put it in here for the next guy.

          <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
          <wsse:UsernameToken wsu:Id="UsernameToken-58">
          <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">sysadmin</wsse:Password>