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

Ahsan Shah Expert
Currently Being Moderated

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.

    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="" xmlns:wsu="">
    <wsse:UsernameToken wsu:Id="UsernameToken-58">
    <wsse:Password Type="">sysadmin</wsse:Password>


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