Reporting and Analytics for SCM Cloud

Get Involved. Join the Conversation.

Topic

    Zoran Kovač
    Invoke web service - BI agent or action
    Topic posted May 17, 2019 by Zoran Kovač, last edited May 17, 2019, tagged Business Intelligence, OBIEE Answers 
    14 Views
    Title:
    Invoke web service - BI agent or action
    Summary:
    Can we use Supplier Model Web service (SOAP) with "Invoke Web Service"
    Content:

    Hello guys!

    I was trying to use invoke web service in an BI agent, but keep getting the error:
    Action rerun ID 8ACE181585706CF2CB0AA9D84431733D, execution service ID ea681ade-e0e3-4318-a27b-9a79ec6e03ea:Error invoking web service SupplierService at endpoint https://******.fa.em2.oraclecloud.com:443/fscmService/SupplierServiceV2
    Client received SOAP Fault from server : InvalidSecurityToken : The security token is not valid.

    Steps:

    1. Create an analysis

    2. Create an BI agent

    3. Add Invoke web service to BI agent

    4. Run BI agent returns error

    I'm using SupplierServiceV2 web service call which is functional when used through SOAP UI or PLSQL call. Main difference is that with SOAP UI or PLSQL I'm sending credentials of user which can use SupplierServiceV2. This is what I can identify as a problem, but don't know how to resolve. In BI "Invoke web service" doesn't have an option to set credentials for a web service.

    I did find some notes in the documentation that something has to be set in the security to browse web services, but we don't have access to web logic in SaaS sourcing and I'm not sure that browsing web services will help.

    I'm attaching screentshot of my steps.

    Zoran

    Version:
    Oracle Business Intelligence 11.1.1.9.0