Oracle OIC Adapters Guide

Share

Introduction

In any enterprise integration landscape, Oracle Integration Cloud Adapters play a critical role in accelerating connectivity between applications. Whether you are integrating SaaS applications like HCM and ERP or connecting to on-premise systems, adapters in Oracle Integration Cloud (OIC Gen 3) simplify complex integration challenges by providing prebuilt connectivity.

From a consultant’s perspective, adapters are not just connectors—they are productivity enablers. Instead of writing custom APIs or handling low-level protocols, you configure adapters declaratively and focus on business logic.

In this article, we will go deep into how Oracle Integration Cloud adapters work, how to configure them, and how they are used in real-world projects.


What are Oracle Integration Cloud Adapters?

Oracle Integration Cloud Adapters are prebuilt connectors that allow seamless communication between OIC and external systems such as:

  • Oracle SaaS applications (ERP, HCM, SCM)
  • Third-party SaaS applications (Salesforce, ServiceNow)
  • On-premise systems (via connectivity agent)
  • Databases, FTP servers, REST/SOAP services

Each adapter abstracts the complexity of communication protocols like REST, SOAP, FTP, JDBC, etc.

Key Idea

Instead of writing code for:

  • Authentication
  • Data transformation
  • API communication

You configure:

  • Connection
  • Endpoint
  • Payload mapping

Key Features of Oracle Integration Cloud Adapters

1. Prebuilt Connectivity

Adapters come ready with predefined configurations for applications like:

  • ERP Cloud Adapter
  • HCM Cloud Adapter
  • REST Adapter
  • SOAP Adapter
  • FTP Adapter

2. Declarative Configuration

No coding required. You configure:

  • Authentication (Basic, OAuth, API Key)
  • Endpoints
  • Operations (GET, POST, etc.)

3. Metadata-Driven Design

Adapters automatically fetch:

  • Business objects
  • APIs
  • Data structures

This is especially useful for ERP and HCM integrations.

4. Security Integration

Adapters support:

  • OAuth 2.0
  • Basic authentication
  • Certificates
  • Integration with Oracle Cloud Infrastructure IAM

5. Reusability

Once a connection is created, it can be reused across multiple integrations.


Real-World Integration Use Cases

Use Case 1 – Employee Data Integration (HCM to Payroll System)

A company uses Oracle HCM but payroll is managed externally.

Flow:

  • HCM Adapter extracts employee data
  • REST Adapter sends data to payroll API

Consultant Insight: We used the HCM Adapter’s business object (Worker) to avoid manual API design.


Use Case 2 – Invoice Processing (ERP to External Vendor System)

Scenario:

  • ERP generates invoices
  • FTP Adapter sends invoice files to vendor

Adapters Used:

  • ERP Cloud Adapter
  • FTP Adapter

Use Case 3 – Real-Time Order Integration (E-commerce to ERP)

Scenario:

  • Orders placed on website
  • REST Adapter receives payload
  • ERP Adapter creates sales order

Key Benefit: Reduced latency using real-time REST-based integration.


Architecture / Technical Flow

A typical adapter-based integration flow in OIC Gen 3 looks like this:

  1. Trigger Adapter (Inbound)
  2. Integration Logic (Mapping, routing)
  3. Invoke Adapter (Outbound)
  4. Response handling

Example Flow

REST Adapter (Trigger) ↓ Data Mapping ↓ ERP Adapter (Invoke) ↓ Response

Important Components

Component Description
Trigger Adapter Starts the integration
Invoke Adapter Calls external system
Connection Holds credentials/config
Integration Orchestration logic

Prerequisites

Before working with adapters, ensure:

  • Access to Oracle Integration Cloud Gen 3 instance
  • Required roles:
    • Service Developer
    • Integration Specialist
  • Endpoint details:
    • API URLs
    • Credentials
  • Network setup (for on-prem):
    • Connectivity Agent installed

Step-by-Step Build Process

Let’s walk through a REST to ERP integration using adapters.


Step 1 – Create Connection

Navigation:

Navigator → Integrations → Connections → Create

Select Adapter:

  • REST Adapter

Provide Details:

  • Name: REST_EMPLOYEE_API
  • Role: Trigger

Configure Security:

  • Authentication: Basic Auth
  • Username/Password

Test Connection


Step 2 – Create ERP Connection

Select Adapter:

  • ERP Cloud Adapter

Provide Details:

  • Name: ERP_EMPLOYEE_CREATE

Configure:

  • URL: ERP Instance URL
  • Credentials

Test Connection


Step 3 – Create Integration

Navigation:

Integrations → Create → App Driven Orchestration

Trigger:

  • REST Adapter

Configure:

  • Method: POST
  • Request Payload: JSON structure

Step 4 – Configure Invoke Adapter

Add ERP Adapter as Invoke.

Select Operation:

  • Import Bulk Data
  • Or specific business object

Configure:

  • Business Object: Worker / Employee

Step 5 – Data Mapping

Map fields:

Source (REST) Target (ERP)
name personName
email emailAddress
department departmentName

Use drag-and-drop mapper.


Step 6 – Activate Integration

Click Activate

Provide:

  • Version
  • Tracking fields

Testing the Technical Component

Test Scenario

Send request via Postman:

{ “name”: “John Doe”, “email”: “john.doe@test.com”, “department”: “Finance” }

Expected Results

  • REST Adapter receives payload
  • ERP Adapter creates employee record
  • Response returns success message

Validation Checks

  • Check instance tracking
  • Verify record in ERP UI
  • Confirm no mapping errors

Common Errors and Troubleshooting

1. Connection Failure

Issue:

  • Authentication error

Solution:

  • Verify credentials
  • Check roles in target system

2. Payload Mapping Issues

Issue:

  • Null or incorrect values

Solution:

  • Validate mapping logic
  • Use default values

3. Adapter Timeout

Issue:

  • Long-running API calls

Solution:

  • Use asynchronous patterns
  • Optimize payload size

4. Connectivity Agent Issues

Issue:

  • On-prem system not reachable

Solution:

  • Restart agent
  • Check firewall rules

Best Practices

1. Use Reusable Connections

Avoid creating duplicate connections.


2. Naming Conventions

Use structured names:

  • REST_EMP_CREATE
  • ERP_INV_IMPORT

3. Secure Credentials

  • Use OCI Vault where possible
  • Avoid hardcoding sensitive data

4. Optimize Payloads

  • Avoid unnecessary fields
  • Use filtering

5. Error Handling Framework

Implement:

  • Fault handlers
  • Logging
  • Retry mechanisms

6. Use Lookup Tables

For:

  • Code conversions
  • Dynamic mappings

Real Consultant Tips

  • Always start with business flow understanding before choosing adapters
  • Use REST Adapter for flexibility and scalability
  • ERP/HCM adapters are powerful but require proper role configuration
  • Always test connections independently before building integrations
  • Use tracking fields wisely for debugging production issues

Summary

Oracle Integration Cloud Adapters are the backbone of any integration solution in modern Oracle Cloud implementations. They reduce development effort, improve reliability, and provide standardized connectivity across systems.

In real-world projects, adapters significantly accelerate delivery timelines while ensuring secure and scalable integrations.

For anyone working with OIC Gen 3, mastering adapters is not optional—it’s essential.

For more details, refer to Oracle official documentation:
https://docs.oracle.com/en/cloud/saas/index.html


FAQs

1. What is the difference between Trigger and Invoke adapters?

Trigger adapters start the integration (inbound), while invoke adapters call external systems (outbound).


2. Can we use multiple adapters in a single integration?

Yes, a single integration can use multiple adapters for complex orchestration scenarios.


3. Which adapter is most commonly used in OIC?

REST Adapter is widely used due to its flexibility and compatibility with modern APIs.


Share

Leave a Reply

Your email address will not be published. Required fields are marked *