DEV Community

Naveen
Naveen

Posted on

Calling OIC Integration from Oracle Fusion via HTTPS

Oracle Fusion Applications often require integration with external or internal services to extend business capabilities. Oracle Integration Cloud (OIC) serves as a powerful middleware platform to orchestrate such integrations.

One of the most common patterns is invoking an OIC integration from Fusion using an HTTPS connection, ensuring secure and reliable communication.

In this blog, we'll walk through the end-to-end process, including setup, configuration, and best practices

Step 1: Create an OIC Integration

  • Login to Oracle Integration Cloud
  • Navigate to Integrations → Create
  • Choose:REST Adapter (recommended for HTTPS calls)

  • Configure:

     * Resource URI (e.g., /customer/update)
 * HTTP Method (POST/GET)
 * Request/Response payload (JSON/XML)

    Reference

Request Payload:

Make sure you selected
What is the media-type of Request Body? (Content-Type Header)
URL-encoded for https call acceptance

Response Payload:
I drop the xml reference here for response payload

<?xml version="1.0" encoding="UTF-8"?>
<xm:schema xmlns:xm="http://www.w3.org/2001/XMLSchema">
<!-- Root element-->
<xm:element name="root" type="root"/>
<!-- Complex type-->
    <xm:complexType name="root">
      <xm:sequence>
        <xm:element name="outcome" type="xm:float"/>
        <xm:element name="Instance_ID" type="xm:string"/>
              </xm:sequence>
            </xm:complexType>
</xm:schema>
Enter fullscreen mode Exit fullscreen mode

Step 2: Create an JavaScript function using libraries

Navigations

Under Design -->libraries-->upload your js function


Under Design -->libraries-->upload your js function

Step 3:Call Js function in integration

  • call Js function in your designing & map respective inputs to your function

Step 4: Map the response of integration

As below maps the final response.

  • Map the primary business identifiers

  • Active the Integration

  • Try to run & collect your endpoint Metadata

Step 5: Fusion BIP https connection configuration
Now we will map the integration connection details in fusion .

So for that we will login fusion/analytics-->Under profile Icon right side [Administration]-->Publisher[Manage Publisher]

  • Under HTTP creation data source with OIC login details

Step 6: Fusion BIP Data Model creation

Now choose the Data Source as HTTPS connection

  • fill respective details as below

Step 7: Testing

  • Run the data model with passing parameters , it will hit the integration as Input which we earlier given as request payload.

  • The response will display as below, which is back from integration.

  • Now we will see the Integration track Instance

By following the steps above setting up OIC, configuring HTTPS calls, handling authentication, and securing communication you can build reliable and scalable integrations.

Top comments (0)