Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is is possible to invoke OIC (APP driven orchestration) from BIP report?

Accepted answer
1939
Views
23
Comments
2

Answers

  • Nikil Varadharaj
    Nikil Varadharaj Rank 1 - Community Starter

    Hi Everyone,

    Is there any solution for not getting the Error "HTTP Process error, no response returned" while triggering OIC through BIP. In OIC the Integration is getting Triggered but getting the Exception mentioned "Error while processing authentication at Trigger. Failed due to - 401 : Unauthorized".

    Do we need to add any roles ?

    Regards,
    Nikil Vardharaj

  • Hima_V
    Hima_V Rank 1 - Community Starter

    i also faced same issue, its issue with OIC Credentials passed in oracle fusion.

    Check those connection details.

  • Suprit
    Suprit Rank 3 - Community Apprentice
    edited Mar 4, 2025 5:53PM

    I am trying to invoke a OIC Integration from BIP and get the error 'HTTP Process error, no response returned'.

    Note: There is no parameters for the OIC that is defined.

    Below is the setup.

    Step:1

    image.png

    Step 2: I have made sure there is no forward slash in the beginning.

    image.png

    Step:3

    image.png
  • Mike Giffard
    Mike Giffard Rank 1 - Community Starter

    @Suprit Try running with a GET method

  • Suprit
    Suprit Rank 3 - Community Apprentice

    @Mike Giffard

    Thank you very much.

    Changing it to 'GET' works. However, we have multiple OIC's in place and majority of them are POST requests. Just wanted to check if there are any limitations in Oracle BIP to trigger REST call with POST requests?

  • Mike Giffard
    Mike Giffard Rank 1 - Community Starter

    @Suprit It should work the same - you just need to use the action in your BIP call that you have defined when creating your REST trigger in the integration.

  • Suprit
    Suprit Rank 3 - Community Apprentice
    edited Mar 5, 2025 11:59AM

    @Mike Burnett Yeah, that is how I expect the system to work ideally.

    Upon your request when I change the OIC as GET and updated the same in BIP it worked.

    Unfortunately, When OIC is of type POST and I call the POST from BIP I see the below error

    "Error while processing at Trigger. Failed due to - 415 : Unsupported Media Type"

     

  • Mike Burnett
    Mike Burnett Rank 3 - Community Apprentice

    @Suprit i think you mentioned the wrong "Mike."