This discussion is archived
1 Reply Latest reply: Sep 19, 2012 3:06 PM by kmacpher67 RSS

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

AhsanShah Expert
Currently Being Moderated
All,

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
    kmacpher67 Newbie
    Currently Being Moderated
    This is discussed in the docs, it's suggested to use ASADMIN account, not SYSADMIN, your call.

    http://docs.oracle.com/cd/E18727_01/doc.121/e12169/T511175T517162.htm

    Create the grants for that EBS User:
    http://docs.oracle.com/cd/E18727_01/doc.121/e12169/T511175T513044.htm#sigig_nativeadmingrants

    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.

    <soapenv:Header>
    <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:Username>SYSADMIN</wsse:Username>
    <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">sysadmin</wsse:Password>
    </wsse:UsernameToken>
    </wsse:Security>

Legend

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