Cloud ERP: Launch OIC integrations from the Oracle Cloud ERP ESS job

There’s a straightforward and speedy way to initiate Oracle Cloud Integration (OIC) integrations right from Oracle Cloud ERP. This document highlights the key information needed to make it happen.

Prerequisites:

1. HTTP connection to connect Oracle Cloud ERP and Oracle Integration Cloud.
2. AppDriven OIC integration that returns an XML payload.
3. An ESS job paired with a BIP report that can initiate an HTTP request

Approach:

OIC Changes

Develop an OIC Integration

Develop an AppDriven integration capable of producing a response that looks like the following XML.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="qualified">
  <xs:element name="integrationResponse">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="integrationStatus" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

The following is a basic integration created for demo purposes, which can be enhanced to a more advanced level based on business requirements.

Once the AppDriven integration is developed, we need to find the Endpoint URL for the AppDriven integration, which can be utilized in BIP reports to initiate integrations.

ERP Changes

Configure HTTP Connection

Configure HTTP Connection in Oracle Cloud ERP Data Sources comprised of the OIC base URL

Navigation: Oracle Cloud ERP → Tools → Reports and Analytics → Administration → Manage Publisher → Data Sources → HTTP Connect

Note: To establish an HTTP connection, Oracle Cloud ERP requires a basic username and password. As of now, there are no other authentication options, such as OAuth, that can be used for this connection. Thus, we need a dedicated service user with limited permissions to trigger OIC integrations.

We’ve proposed an enhancement in the Oracle Idea Lab to improve security options for HTTP sources. If you’re interested in more secure configuration choices, we’d love your support with an upvote!

Design a BIP Report

Develop a BIP Report by leveraging an HTTP data source created in previous step

Note: Few things to keep in mind while designing BIP report

1. Since the base OIC URL is configured in the HTTP connection, we should specify the endpoint URL by leaving out the base URL.
2. We should create all the parameters required to call the OIC integrations as BIP parameters and map the parameters accordingly.

Configure an ESS job

Create an ESS job to trigger BIP report

Testing

Submit the ESS job from ERP

Review the integration submitted in OIC

I've included some sample code (Sample Code.zip) for your reference. Please make any necessary configurations to ensure it works in your environment.