Exploring The Advanced Features Of Oracle Integration Cloud (OIC) Gen 3
By Bala Sai Tilak.Thalla, HEXstream data integrations engineer
Oracle Integration Cloud (OIC) is a powerful cloud-based PaaS platform designed to integrate heterogeneous and homogeneous applications seamlessly. Known for its ease of use, OIC supports a wide variety of systems via prebuilt adapters, making it a go-to solution for enterprise integration.
Traditionally, OIC receives updates on a quarterly basis. However, in August 2022, Oracle introduced a major upgrade with the release of ‘OIC Gen 3’, a new generation of the platform packed with advanced capabilities and a modern interface.
In this blog, we will explore the standout features of OIC Gen 3 and how it empowers developers to build robust and scalable integrations.
A fresh new look: redwood-inspired interface
One of the most noticeable differences in OIC Gen 3 is the user interface. While Gen 2 featured a blue-themed design, OIC Gen 3 introduces a Redwood-inspired UI, aligning with Oracle’s latest design system. This cleaner, more modern look enhances the overall user experience and makes navigation more intuitive.
Introducing projects to organize Integrations
OIC Gen 3 introduces a concept called Projects, which act like workspaces that house related integration assets in a structured manner.
Each project can contain:
- Up to 100 Integrations
- 50 Deployments
- 50 Connections
- 50 Lookups
- 20 JavaScript Libraries
Project tabs:
- Design: Where integrations are built
- Deploy: Deploy multiple integrations together
- Observability: Monitor integrations by instance, schedule, or audit trail
Projects also support role-based access control, allowing users to edit, view, or monitor components based on their roles.
Extended retention period
In OIC Gen 2, the retention period for viewing integration instances (success/faulted) was three days by default, configurable up to 30 days.
In OIC Gen 3, this limit has been increased to 32 days, allowing developers and support teams to track integration histories for longer durations.
Tracing levels: debug, audit and production
OIC Gen 3 introduces three levels of tracing to balance visibility and performance:
Tracing Level | Purpose |
Debug | Captures full payloads for detailed testing and debugging |
Audit | Records trigger/invoke input-output payloads with moderate detail |
Production | Optimized for performance with minimal logging to ensure security and speed |
These options offer better control over how much runtime data is stored and when.
Increased payload sizes
A major improvement in Gen 3 is the increase in payload size limits for key adapters:
Adapter | Gen 2 Limit | Gen 3 Limit |
REST | 10 MB | 100 MB |
SOAP | 10 MB | 100 MB |
Similarly increased the payload limits for the database, FTP and other adapters for both trigger and invokr levels. This enhancement enables handling of large files and complex data structures with ease.
Enhanced actions and new sections
OIC Gen 3 revamps the action palette by introducing new action categories and capabilities, including:
OCI AI services section
Dedicated to Oracle AI integrations such as:
- OCI Generative AI
- OCI Vision
- OCI Speech
- OCI Documentation AI
- OCI RAG (Retrieval Augmented Generation)
These allow you to build AI-powered integrations directly within OIC.
Parallel action: Found under the Logic section, this new action enables parallel processing, allowing
multiple endpoints to be called simultaneously—improving performance and response times.
Increased iteration capabilities
- For-each Loop: Increased from 5,000 iterations to unlimited
- While loop: Remains at 5,000 iterations
This change enables handling of large datasets without artificial loop limits.
Advanced mapping capabilities
OIC Gen 3 enhances the Mapping editor with a new Import Mapping feature.
You can now:
- Import .XSL files directly into your mappings
- Reuse complex transformation logic across multiple integrations
- Standardize mapping logic across similar scenarios
Richer function library for mappings: Mapping transformations have been significantly improved with a broader set of built-in functions, making it easier to manage complex logic. This reduces the need for external scripting or additional transformation steps.
Increased integration limits
Oracle has raised the active integration count from 700 to 800, supporting organizations with larger-scale integration requirements.
Oracle Integration Cloud Gen 3 is not just a cosmetic upgrade, it’s a major architectural and functional enhancement. By leveraging the new features in OIC Gen 3, integration developers can build lightweight, high-performing, and future-ready integrations for any enterprise need.
