What’s New for Oracle Integration 3

Learn about the new and changed features of Oracle Integration 3, which is the latest generation of Oracle Integration.

Additional information:

August 2023

Common Features

Feature Description Minimum Version Required

Ingress IP address change

The inbound IP address for the Oracle Integration instance now appears on the About menu. If you have network egress rules to connect to Oracle Integration, add a new rule using the inbound IP address. Ensure that you do not delete any of the existing egress rules.

23.08

New recipe

The following new recipe has been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

N/A

Integration and Connectivity Features

Feature Description Minimum Version Required

OCI object storage action in the integration canvas

You can invoke Oracle Cloud Infrastructure object storage from an integration without the need to configure an explicit connection. This functionality enables you to manage objects (upload, download, and delete) and manage buckets (create, list, and delete) in the Oracle Cloud Infrastructure Console from your integration canvas.

See Invoke Oracle Cloud Infrastructure Object Storage from an Integration with an OCI Object Storage Action and Manage Oracle Cloud Infrastructure Buckets and Objects from an Integration in Using Integrations in Oracle Integration 3.

23.08.2

Monitor event subscriptions

You can monitor event subscription integrations during runtime.

See Monitor Event Subscription Integrations in Using Integrations in Oracle Integration 3.

23.08

Maintain business identifier definitions during trigger connection/scheduled integration changes

When a trigger connection or a scheduled integration parameter changes, business identifier definitions are not removed. Instead, the definitions are validated based on the changes.

See Maintain Business Identifier Definitions During Trigger Connection/Schedule Integration Parameter Changes in Using Integrations in Oracle Integration 3.

23.08

Enable tracing when resubmitting an integration instance

When resubmitting an errored integration instance on the Errors page, you can change the level of tracing (production, audit, or debug) for the instance. Increasing this setting (for example, selecting Debug) lets you view more specific details about errors in the activity stream and downloaded logs and can aid in debugging errors in your instance.

See Resubmit Failed Messages in Using Integrations in Oracle Integration 3.

23.08

Certificate expiration notification

You can configure alerts to be sent when certificates you uploaded on the Certificates page have expired or are set to expire within seven days. The check for certificate status is performed daily.

See Configure Notification Emails in Using Integrations in Oracle Integration 3.

23.08

Project enhancements

Projects continue to be enhanced with new features:
  • Automatic merging of accelerator extensions at the project level during upgrade. This eliminates the need to manually merge each integration one by one. See Upgrade an Accelerator Project and Merge Extensions in Using Integrations in Oracle Integration 3.
  • Configuration editor support at the project level. This editor enables you to configure the dependent resources used by all integrations in a specific project. See Edit and Replace Dependent Resources in a Project in Using Integrations in Oracle Integration 3.
  • Accelerator extensibility updates to support invoke connections and the associated maps, ad-hoc maps, parent integration invocations of child integrations, and global variables. See Extend an Integration in an Accelerator Project in Using Integrations in Oracle Integration 3.
  • Viewing message processing status of your running integrations in a project (messages received and processed, successful messages and errors that occurred, and messages canceled). You can also view integration statistics (total counts and the minimum (quickest), maximum (slowest), mean, and standard (largest) deviation execution times of integrations over a selected time period). See Monitor the Message Processing Status of Integrations in Projects in Using Integrations in Oracle Integration 3.

23.08

Timeout session management

You can set the time limit for inactive sessions in an Oracle Integration instance. This setting automatically signs out a currently authenticated user after a specified period of inactivity. This setting impacts all the users of the instance and takes effect after a user signs out and signs back in.

See Set the Time Limit for Inactive Sessions in Using Integrations in Oracle Integration 3.

23.08

Search for business identifier values that include special characters and white spaces

You can search for business identifier values that include special characters and white spaces on the Instances page. Simply wrap the values in double quotes.

See Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

23.08

Copy-of support in design mode in the mapper

You can automatically perform a deep copy of all child elements of a source parent node to the child elements of a target parent node in the mapper. This eliminates the need to individually map each source child element to each target child element.


The Components list shows entries for Functions, Operators, and XSL Constructors. XSL Constructors is expanded to show Flow Control and Output. Output is expanded to show attribute and copy-of.

See Perform a Deep Copy of Elements with a copy-of Constructor in Using the Oracle Mapper with Oracle Integration 3.

23.08

Adapter Endpoint Configuration Wizard enhancements

The Adapter Endpoint Configuration Wizard has been enhanced. Some of the changes include the following:

  • The user interface has been updated to more reflect the Oracle Redwood look and feel.
  • The train at the top of each page has been removed.
  • Buttons at the bottom are always visible and do not require you to scroll to access.
  • Button names have changed. For example, previous step and next step icons have been replaced with Go back and Continue.
  • When a child page is opened, it is displayed similar to a pop-up window instead of opening in a separate page. That way, the parent page is always visible.
  • If you click Cancel, you are prompted with the opportunity to save your changes.
  • Excessive blank space has been reduced.

23.08

REST Adapter - AWS Signature Version 4 security policy support with the connectivity agent

You can use the AWS Signature Version 4 security policy with the connectivity agent. This policy is useful when you need to invoke AWS APIs that are available in on-premises environments.

See Configure Connection Security in Using the REST Adapter with Oracle Integration 3.

23.08

SOAP Adapter, Apache Kafka Adapter, and Oracle Cloud Infrastructure Streaming Service Adapter - Private endpoint support

You can configure the SOAP Adapter, Apache Kafka Adapter, and Oracle Cloud Infrastructure Streaming Service Adapter to connect to endpoints using a private virtual cloud network (VCN).

See Configure the Endpoint Access Type in Using the SOAP Adapter with Oracle Integration 3, Configure the Endpoint Access Type in Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle Integration 3, and Configure the Endpoint Access Type in Using the Apache Kafka Adapter with Oracle Integration 3.

23.08

Apache Kafka Adapter and Oracle Cloud Infrastructure Streaming Service Adapter - Inbound polling support without the connectivity agent

You can poll without use of the connectivity agent. Polling capabilities remain unchanged from previous releases, apart from connectivity agent selection on the Connections page.
  • If the messaging service to access is in a private network, you must first configure private endpoint support in the Oracle Cloud Infrastructure and then select Private endpoint on the Connections page to poll without the connectivity agent. See Connect to Private Resources in Provisioning and Administering Oracle Integration 3.
  • If the database to access is public, private endpoint configuration is not required and the adapter polls directly without the connectivity agent.
23.08

OData Adapter - Version 4 outbound enhancements

The OData Adapter now supports OData version 4 to go along with the existing support for version 2. Version 4 enables you to use the JSON message format.

See OData Adapter Capabilities in Using the OData Adapter with Oracle Integration 3.

23.08

Shopify Adapter - API version certification

The Shopify Adapter is certified to support API versions 2023-01 and 2023-04.

See the Adapter Certification Matrix.

23.08

Oracle Utilities Adapter - OAuth Client Credentials support

The Oracle Utilities Adapter now supports OAuth Client Credentials in both the inbound and outbound directions for SOAP catalogs. This functionality is supported for both the public gateway (supporting secured WSDLs) and connectivity agent (supporting nonsecured WSDLs) access types.

See Oracle Utilities Adapter Capabilities in Using the Oracle Utilities Adapter with Oracle Integration 3.

23.08

Oracle HCM Cloud Adapter - New Atom feeds support

The Oracle HCM Cloud Adapter supports new Atom feeds.

See Oracle HCM Cloud Adapter Capabilities in Using the Oracle HCM Cloud Adapter with Oracle Integration 3.

23.08

SAP Ariba Adapter - Integration toolkit (ITK) deprecation

The SAP Ariba integration toolkit (ITK) has been deprecated. ITK has been replaced with the term task/event in the documentation. In addition, the Ariba ITK Authentication Policy field has been renamed to Shared Secret-based Authentication on the Connections page.

See SAP Ariba Adapter Capabilities in Using the SAP Ariba Adapter with Oracle Integration 3.

23.08

PostgreSQL Adapter - Bulk data import operation and pagination support

The PostgreSQL Adapter has been enhanced to support bulk data import and pagination. The PostgreSQL Adapter also provides Secure Socket Layer (SSL) support through the connectivity agent. The PostgreSQL Adapter supports bulk data import for outbound invocations in Oracle Integration and enables you to import bulk data into a PostgreSQL database.

See PostgreSQL Adapter Capabilities and Implement Common Patterns Using the PostgreSQL Adapter in Using the PostgreSQL Adapter with Oracle Integration 3.

23.08

Netezza Adapter - Bulk data import operation and pagination support

The Netezza Adapter now provides support for bulk data import and pagination for outbound invocations in Oracle Integration. You can import bulk data into a Netezza database.

See Netezza Adapter Capabilities and Implement Common Patterns Using the Netezza Adapter in Using the Netezza Adapter with Oracle Integration 3.

23.08

FTP Adapter - Security enhancements

When configuring an sFTP connection, support for ECDSA host keys is provided.

See Configure an sFTP Connection in Using the FTP Adapter with Oracle Integration 3.

23.08

Zuora Adapter - New adapter

The Zuora Adapter is a new addition to Oracle Integration's growing list of connectivity adapters. The Zuora Adapter provides inbound trigger and outbound invoke connection support for performing operations on business objects. Custom fields for REST APIs are also supported.

See Zuora Adapter Capabilities in Using the Zuora Adapter with Oracle Integration 3.

23.08

Azure Event Grid Adapter - New adapter

The Azure Event Grid Adapter is another new addition to the enterprise messaging group of connectivity adapters in Oracle Integration. The Azure Event Grid Adapter enables you to create an integration in Oracle Integration that connects to an Azure Event Grid messaging service. The Azure Event Grid Adapter connects to the Azure Event Grid distributed publish-subscribe messaging system from Oracle Integration and provides for the publishing and consumption of messages from an Azure Event Grid topic/domain. The Azure Event Grid Adapter can be configured as a trigger and an invoke connection.

See Azure Event Grid Adapter Capabilities in Using the Azure Event Grid Adapter with Oracle Integration 3.

23.08

GCP Pub Sub Adapter - New adapter

The GCP Pub Sub Adapter is a new addition to the enterprise messaging group of connectivity adapters in Oracle Integration. The GCP Pub Sub Adapter enables you to create an integration in Oracle Integration that connects to a GCP Pub/Sub messaging service. The GCP Pub Sub Adapter connects to the GCP Pub/Sub distributed publish-subscribe messaging system from Oracle Integration and provides for the publishing and consumption of messages to/from a GCP Pub/Sub topic. You can configure the GCP Pub Sub Adapter as a trigger or an invoke connection.

See GCP Pub Sub Adapter Capabilities in Using the GCP Pub Sub Adapter with Oracle Integration 3.

23.08

Snowflake Adapter - Stored procedure support

The Snowflake Adapter enables you to execute stored procedures in the Snowflake database.

See Snowflake Adapter Capabilities in Using the Snowflake Adapter with Oracle Integration 3.

23.08

ServiceNow Adapter - OAuth2.0 (two-legged) support

The ServiceNow Adapter now supports OAuth 2.0 two-legged authentication with the Resource Owner Password Credentials security policy.

See ServiceNow Adapter Capabilities ServiceNow Adapter Capabilities in Using the ServiceNow Adapter with Oracle Integration 3.

23.08

SAP ASE (Sybase) Adapter - SSL support

The SAP ASE (Sybase) Adapter provides support for using Secure Socket Layer (SSL). The SAP ASE (Sybase) Adapter provides one-way SSL for trigger and invoke connections.

See Prerequisites for Creating a Connection and Configure Connection Properties in Using the SAP ASE (Sybase) Adapter with Oracle Integration 3.

23.08

Oracle Enterprise Performance Management Cloud Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

The Oracle Enterprise Performance Management Cloud Adapter enables you to connect to Oracle Enterprise Performance Management Cloud. This enables organizations to:
  • Simplify the close process in Oracle Financial Consolidation and Close Cloud and Oracle Tax Reporting Cloud
  • Streamline the close process through automation
  • Leverage first-in-class consolidation and tax reporting functionality

See Oracle Enterprise Performance Management Cloud Adapter Capabilities in Using the Oracle Enterprise Performance Management Cloud Adapter with Oracle Integration 3.

23.08

File Server Features

Feature Description Minimum Version Required

Connect to File Server using a hostname

If you enable File Server after the 23.08 update, you can connect to File Server using File Server's hostname or IP address. Previously, the only option for connecting was using the IP address.

See Configure File Server Settings in Using File Server in Oracle Integration 3.

The hostname is not available for connecting if you enabled File Server before the update.

23.08

Visual Builder Features

Feature Description Minimum Version Required
Changed upgrade policy Our upgrade policy has been changed to support applications built on the current runtime version as well as the three previous versions. Previously, it was the current runtime version and the two previous versions. See Upgrade Policy. 23.10
JavaScript action chains

You can now create action chains in JavaScript. JS action chains allow you to debug them using the browser's developer tools; they are also easier to manage through Git actions. A Design view that reflects code structure helps you build functionality by dragging and dropping actions; you can also choose to work entirely in Code view.

With this update, all new action chains (including those created by Quick Starts) will default to JavaScript—though you can still create JSON action chains. Existing JSON action chains will continue to work as before.

As a part of this update, you'll notice a few usability improvements:
  • List view for Actions palette

    The Actions palette in the Action Chains editor now has a new List view, in addition to the default Grid view, allowing you to view available actions alphabetically in each category. Customizing the view saves your palette preferences separately for each action chain.

  • "Surround With" options

    When working with an action in Diagram mode, you can now use the Surround With options in an action's right-click menu to wrap the action in an If or Try-Catch action.

  • Code insights

    When working with an action in Code mode, you can now use Code Insight to quickly reference scoped artifacts and local variables. Simply enter $ to bring up the insights pop-up menu, then make your auto-fill selection.

See Work with JavaScript Action Chains.

23.10
Mobile apps deprecated

Mobile apps have been deprecated in favor of Progressive Web Apps (PWAs)—although mobile functionality won't be entirely removed from the product until July 2024. Starting with 23.10, you can no longer create a new mobile app, but you can import an existing mobile app and deploy it as a PWA for use on mobile devices.

Functionality relating to hybrid mobile applications (deprecated since April 2021) has also been removed from the product. This means that the use of build configurations to build native .ipa and .apk files for distribution to iOS and Android devices—as well as the Cordova custom plug-in option—are no longer available. You can no longer create new hybrid mobile apps or new build profiles for existing apps; build configurations for existing apps will be ignored. For apps that target mobile devices, enabling PWA support is the recommended approach for distribution. See Run Mobile Applications as PWAs.

You can continue to use your existing mobile apps until July 2024 when mobile apps (including PWA-enabled ones) reach End of Life (EOL). To be able to use your mobile PWAs beyond July 2024, we strongly urge you to transition your mobile app as a web app and deploy it as a PWA.

23.10
Improved diagnostics for IDCS client apps We've made it easier for you to identify and troubleshoot issues with your visual application's client apps created in IDCS. A new IDCS Details tab, available under Application Profiles in the app-level Settings editor, provides details to help you inspect IDCS details and identify any configuration issues. See How Do I View Details of Client App in IDCS? 23.10
Variable enhancements
  • Variable tracking to detect unsaved changes

    You can now track a variable's state to detect unsaved changes in your app. Tracking a variable marks it as "dirty" any time its value changes. You can then query for dirty variables using a new JavaScript-based Get Dirty Data Status action. If you don't want a change to be considered dirty, you can reset variable state using the Reset Dirty Data Status action (also based on JavaScript). See Track Variables to Detect Unsaved Changes.

  • Filter for input parameters

    A new Show Input Parameters only option on the Variables editor now allows you to filter variables used as input parameters. See Enable Variables as Input Parameters.

23.10
Fragment enhancements
  • Slots in fragments

    A new Fragment Slot component, available in the Components palette, now allows you to add slots to a fragment where users can drop in their own content. A fragment with slots, when used on a page, reveals its slots on the canvas, the page structure, and as part of the fragment's properties. Fragment slots are similar to component slots and users work with them in much the same way. See Add Slots to a Fragment.

  • Autowiring of fragment variables

    To simplify the process of creating pages with fragments, we've added a new property for fragment variables enabled as input parameters to be automatically created on the page where the fragment is used and wired back to the fragment variable's value. See Automatically Create and Wire a Fragment Variable on Its Container.

  • Design Time support to display an enhanced UI for fragment input parameters

    A new Design Time tab in a fragment variable or constant's Properties pane now allows you to customize the UI component shown in the Properties pane when the fragment is selected on a page or container. Previously, you had to do this by editing the JSON metadata. See Customize How a Fragment Variable is Displayed in the Properties Pane.

  • Support to display fragment input parameters in sections

    You can now group a fragment's input parameters and dynamic components by sections using a new Design Time editor that appears in the fragment's toolbar. Use this option to display a fragment's most important properties in the Properties pane when the fragment is selected on a page or container. See Section Fragment Properties for Display in the Properties Pane.

    If the fragment is used as a page template to create a page, the sectioned view also shows on the page's Properties pane and the Structure view, with the fragment considered the root element instead of the page. See Create Pages From Fragments.

23.10
Service/backend enhancements
  • Backends mandatory for new service connections

    If you're looking to create a new service connection by providing a specification document or an endpoint URL, you now need an existing backend to be able to create the service connection. If a backend doesn't exist, you'll be prompted to create one as part of the Create Service Connection workflow.

    With this update, all new service connections will require a backend. Making backends mandatory simplifies the task of managing server connection attributes, especially credentials, across environments. Service connections created previously without a backend will continue to work and their configuration settings can be changed as well.

  • Default service name change

    New service connections no longer include a default name. You can now specify your own service name for easier identification. See Create a Service Connection from the Catalog, Create a Service Connection from a Service Specification, and Create a Service Connection from an Endpoint.

23.10
Support for pinning columns in dynamic tables You can now "freeze" table columns in dynamic tables, so that a column will remain visible when horizontally scrolling within a table. See Configure How Columns Render in a Dynamic Table's Layout. 23.10
Other enhancements We've made several updates (including performance enhancements) to improve your design experience. Here are the key updates:
  • Multiple undo and redo options in the Designer

    When working in the Designer, you can now undo and redo multiple actions at one shot; previously, you could undo and redo only your most recent change. See Tour the Designer.

  • Audit improvements

    As a part of performance improvements to enhance application auditing, a new Opened Artifacts setting only audits artifacts that are currently open. To audit the entire application, change this setting to All Artifacts.

    Further, results in the Audits pane now show in a tree view, instead of a column view. With this change, issues are grouped by artifact, helping you view all issues in a particular artifact. See Audit Application Code.

23.10

July 2023

Common Features

Feature Description Minimum Version Required
New region availability

Oracle Integration 3 is now available for provisioning in the Monterrey (MTY) region.

See Availability in Provisioning and Administering Oracle Integration 3.

23.04.1
New recipes The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

June 2023

Common Features

Feature Description Minimum Version Required

Connect to private resources

You can now secure the traffic to private resources that are in your virtual cloud network (VCN) using a private endpoint. With a private endpoint, all traffic goes through a private channel that is set up within Oracle Cloud Infrastructure and never goes over the public internet.

23.06

New recipes

The following new recipes have been added to Oracle Integration to help you jump start your integration development. Simply install, configure, and activate.
N/A

Integration and Connectivity Features

Feature Description Minimum Version Required

JDK 11 use with the connectivity agent

After November 15, 2023, Oracle Integration 3 connectivity agents running on JDK 11 will no longer be supported, and automatic upgrade will no longer be available for these connectivity agents. Upgrade to JDK 17. See System Requirements in Using Integrations in Oracle Integration 3.

N/A

Integration project enhancements

Integration projects continue to be enhanced with new features:

  • You can control the users and groups that edit, view, and monitor a project with role-based access control (RBAC). You select who can access a set of project resources while restricting (or hiding) those same resources from others (for example, providing an HCM group of users with access to some project resources while restricting an ERP group of users from accessing those same project resources). See Control Who Can Edit, View, and Monitor in a Project in Using Integrations in Oracle Integration 3.
  • You can clone projects and lookups. See Clone a Project and Clone a Lookup in a Project in Using Integrations in Oracle Integration 3.
  • You can add a for-each action to an extension group and add an extension group after an invoke connection. See Extend an Integration in an Accelerator Project in Using Integrations in Oracle Integration 3.

23.06

Large payload support

The supported sizes for payloads have increased for the following adapters:

  • The REST and SOAP SaaS-based adapters, Oracle Autonomous Transaction Processing Adapter, Oracle Autonomous Data Warehouse Adapter, Oracle Database Cloud Service Adapter, and FTP Adapter in the cloud can process 100 MB structured payloads and 50 MB payloads with the connectivity agent.
  • The stage file action can process 100 MB structured payloads.
  • Exceptions:
    • Non-Oracle database adapters can support 10 MB structured payloads for both the connectivity agent and the cloud.
    • Messaging adapters such as IBM MQ Series JMS Adapter, Oracle WebLogic JMS Adapter, Oracle Advanced Queuing (AQ) Adapter, Apache Kafka Adapter, and others can support 10 MB structured payloads.

See Service Limits in Provisioning and Administering Oracle Integration 3.

23.06

Private endpoints - Adapter support

You can configure the REST Adapter, FTP Adapter, Oracle CPQ Adapter (REST-based APIs only), Oracle Autonomous Data Warehouse Adapter, Oracle Autonomous Transaction Processing Adapter, and Oracle Database Cloud Service Adapter to connect to endpoints using a private virtual cloud network (VCN).

See Configure the Endpoint Access Type in Using the REST Adapter with Oracle Integration 3, Configure the Endpoint Access Type in Using the FTP Adapter with Oracle Integration 3, Configure the Endpoint Access Type Using the Oracle CPQ Adapter with Oracle Integration 3, Configure the Endpoint Access Type in Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration 3, Configure the Endpoint Access Type in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration 3, and Configure the Endpoint Access Type in Using the Oracle Database Cloud Service Adapter with Oracle Integration 3.

23.06
Publishing and subscribing to events in integrations

You can create events in Oracle Integration and then publish those events in integrations. Once published, you can create an integration that subscribes to the events.

See Create Integrations to Publish and Subscribe to Events and Publish Events in an Integration with a Publish Event Action in Using Integrations in Oracle Integration 3.

23.06
Observability section enhancements

The Observability section continues to be enhanced with new features:

23.06

Self-diagnosing Oracle Fusion Applications business event delivery - user interface enhancements

The Fusion Applications page has been updated with the following enhancements:
  • The Name column shows the connection name and its Oracle Fusion Applications hostname that was specified in the Properties section of the Connections page. This enables you to identify the host on which the event was generated.
  • The Project id column shows the name of the project to which a connection belongs. If the connection is not part of any project (known as a connection that is globally available), the column cell is empty.

See Diagnose and Manage Event-Based Oracle Fusion Applications Integrations in Using Integrations in Oracle Integration 3.

23.06

Wait action - Synchronous integration support

You can add a wait action to a synchronous integration.

See Delay Integration Processing for a Specified Time Period with a Wait Action in Using Integrations in Oracle Integration 3.

23.06
Oracle Autonomous Transaction Processing Adapter, Oracle Autonomous Data Warehouse Adapter, and Oracle Database Cloud Service Adapter - Inbound polling support without the connectivity agent
You can poll Oracle Autonomous Transaction Processing, Oracle Autonomous Data Warehouse, Oracle Database Cloud Service databases without use of the connectivity agent. Polling capabilities remain unchanged from previous releases, apart from connectivity agent selection on the Connections page.
  • If the database to access is behind a firewall, you must first configure private endpoint support in the Oracle Cloud Infrastructure and then select Private endpoint on the Connections page to poll without the connectivity agent.
  • If the database to access is public, private endpoint configuration is not required and the adapter polls directly without the connectivity agent. See Connect to Private Resources in Provisioning and Administering Oracle Integration 3.

Note: The FTP Adapter, Oracle CPQ Adapter, and REST Adapter do not support inbound polling with private endpoints.

See Perform Inbound Database Polling Without the Connectivity Agent in Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration 3, Perform Inbound Database Polling Without the Connectivity Agent in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration 3, and Perform Inbound Database Polling Without the Connectivity Agent in Using the Oracle Database Cloud Service Adapter with Oracle Integration 3.

23.06

OData Adapter enhancements
The OData Adapter provides the following new features with this release:
  • On-premises support with the connectivity agent
  • JSON and ATOM-XML message formats support
  • Custom queries support with the Query operation
  • User interface enhancements

See OData Adapter Capabilities in Using the OData Adapter with Oracle Integration 3.

23.06
IBM DB2 Adapter - AS400 support

The IBM DB2 Adapter is certified on AS400.

See the Connectivity Certification Matrix.

23.06
Oracle Hospitality Adapter enhancements

The Oracle Hospitality Adapter endpoint configuration provides a new level of useability in which the available operations and their business objects are mapped dynamically according to what's available in OPERA Cloud for that user/application. You no longer need to specify JSON sample messages for request/response and endpoint URLs are no longer required.

See Add the Oracle Hospitality Adapter Connection to an Integration in Using the Oracle Hospitality Adapter with Oracle Integration 3.

23.06

B2B for Oracle Integration Features

Feature Description Minimum Version Required

B2B for Oracle Integration

B2B for Oracle Integration continues to be enhanced with new features:

23.06

May 2023

Common Features

Feature Description Minimum Version Required
Oracle Identity Cloud Service (IDCS) cross region support

For tenancies that use IDCS, you can now create the Oracle Integration 3 instance in a different region than your IDCS stripes.

23.04.1

Oracle Integration 3 on US Government Cloud

Oracle Integration 3 on US Government Cloud is now available in the following location:

  • The West (Phoenix) region for the OC2 realm (Oracle Cloud Infrastructure US Government Cloud with FedRAMP Authorization)

See Get Started with Oracle Integration on Oracle Cloud Infrastructure US Government Cloud in Using Oracle Integration 3 on Oracle Cloud Infrastructure US Government Cloud.

23.04

New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

B2B for Oracle Integration Features

Feature Description Minimum Version Required

B2B for Oracle Integration

New REST APIs have been added for document customization, monitoring, and trading partners.

See What's New in REST API for Oracle Integration 3.

23.04

Oracle Cloud Infrastructure Process Automation Features

Feature Description Minimum Version Required

Oracle Cloud Infrastructure Process Automation

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

Oracle Cloud Infrastructure Process Automation is now supported in Oracle Integration 3. With the Oracle Cloud Infrastructure Process Automation design-time (Designer) and the runtime (Workspace) environments, you can rapidly design, automate, and manage business processes in the cloud. When you use Oracle Cloud Infrastructure Process Automation with Oracle Integration, the power to integrate and work with cloud applications increases manifold in your process applications with access to integrations that are designed in Oracle Integration. See Use Process Automation with Oracle Integration 3 in Using Oracle Cloud Infrastructure Process Automation.

To use Process Automation with Oracle Integration, you must first enable it with an Oracle Integration instance from the Oracle Cloud Infrastructure (OCI) Console. See Enable Process Automation with Oracle Integration 3 in Administering Oracle Cloud Infrastructure Process Automation.

The following Oracle Cloud Infrastructure Process Automation documentation is available in the Oracle Help Center:

23.04.1

Insight Features

Feature Description Minimum Version Required

Insight capability

The Insight capability was previously available in Oracle Integration 3 for previewing purposes. The preview period has now ended, and Insight is no longer available in Oracle Integration 3.

N/A

April 2023

Common Features

Feature Description Minimum Version Required

JDK 17 support

The connectivity agent has been certified to support JDK version 17. Oracle recommends that you upgrade to version 17. Using the connectivity agent, you can create hybrid integrations and exchange messages between applications in private or on-premises networks and Oracle Integration.

See System Requirements in Using Integrations in Oracle Integration 3.

23.04.1

Additional instances are ready for upgrade

Upgrades for additional adapters

Instances containing integrations that use the following adapters can now be upgraded to Oracle Integration 3:

  • Oracle Intelligent Advisor Adapter

  • Oracle Intelligent Track and Trace Adapter

  • AS2 Adapter

    If your connections use identity certificates, you must complete some steps before and after the upgrade. See below.

See Upgrade from Oracle Integration Generation 2 to Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

Upgrades for instances with identity certificates

Instances with identity certificates cannot be upgraded to Oracle Integration 3. However, a workaround is now available if you'd like to upgrade soon: Delete the identity certificate before the upgrade and then upload a new identity certificate after the upgrade.

Identity certificates establish client identity during two-way SSL communication. You can create connections that use identity certificates based on the AS2 Adapter and the REST Adapter.

You must complete some tasks before and after the upgrade. See Update Allowlists and Complete Pre-Upgrade Tasks and Complete the Post-Upgrade Tasks in Provisioning and Administering Oracle Integration 3.

23.04

New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

Integration and Connectivity Features

Feature Description Minimum Version Required

Integration project enhancements

Integration projects continue to be enhanced with new features:

  • You can configure a parent integration in a project to invoke child integrations in other projects or outside of projects (known as globally available integrations). You can set which project integrations you want to make public (visible) for selection as child integrations in other projects. Setting a project integration as public enables that integration to be invoked by a parent integration in a different project. If you don't set a project integration as public, it can only be invoked by a parent integration in the same project. See Invoke Child Integrations Inside or Outside of Projects and Invoke a Child Integration from a Parent Integration.
  • You can extend (customize) an integration in an accelerator project by adding a switch action. See Extend an Integration in an Accelerator Project.
  • You can view the design-time audit log for a project. See View the Design-Time Audit Log of a Project.
  • You can view the instances under the Observe tab in chart view. See Track Instances in a Project.
  • You can create a new integration in a project on the Home page in either of two ways:
    • Select an existing project in which to include the integration.
    • Enter a new project name, which creates a new project that includes your integration.
    See Get Familiar with the Home Page.
  • You can convert an existing package and its resources (integrations, connections, lookups, and JavaScript libraries) to a project. See Convert a Package to a Project.
  • You can search on the last updated project by selecting Last updated from the Filter Filter icon on the Projects page.

See About Integration Projects and Design, Manage, and Monitor Integrations in Projects in Using Integrations in Oracle Integration 3.

23.04

Self-diagnosing Oracle Fusion Applications business event delivery

You can self-diagnose the delivery of business events between Oracle Fusion Applications and Oracle Integration to determine where delivery problems occurred.

See Diagnose and Manage Event-Based Oracle Fusion Applications Integrations in Using Integrations in Oracle Integration 3.

23.04

Observability pages enhancements

The Observability part of Oracle Integration has been enhanced with the following features:

  • The activity stream data available when you select the Debug (not recommended) option as your tracing level in the Activate integration panel is retained for 24 hours before being purged. However, you can view minimal details about the instances for up to 32 days in the Instances page and Errors page. See View Minimal Details About Debug Tracing Level Instances for 32 days.
  • The Monitor integrations page's filter has been enhanced to let you select the integration type (all integrations, only integrations in a project, or only integrations not in a project). If you select to show integrations in a project, you are prompted to begin entering the project name and select from the matching suggestions. See Monitor the Message Processing Status of Integrations.
  • The Connections with errors section on the Dashboard page enables you to click a section in the connection errors graph to access the Errors page. The Errors page lists the integration instances that use this connection. The connection name appears in the filtered search at the top of the Errors page. See View the Dashboard.
  • The Filter Filter icon on the Errors page and Instances page enables you to select the integration state (all, retained, or purged). See View Error Messages and the Message Payload in the Activity Stream of Failed Instances and Filter the Display of Integration Instances
  • If you select the Errors by connection and the Errors by integration options on the Errors page, the Filter Filter icon shows errors alphabetically by name or by error count in descending order. See View Errors By Integration and Connection.

23.04

Invoke Oracle Cloud Infrastructure functions directly from an integration

You can directly invoke Oracle Cloud Infrastructure functions from an integration in the integration canvas.

See Invoke Oracle Cloud Infrastructure Functions Directly from an Integration with an OCI Function Action in Using Integrations in Oracle Integration 3.

23.04

Expression support in wait actions

You can use the Expression Builder to configure the value for a wait action in an integration. The wait action enables you to delay the processing of an integration for a specified period of time. You can also continue to hard code the values. You can also override the value at runtime through use of an integration property.

See Delay Integration Processing for a Specified Time Period with a Wait Action and Override Design-Time Properties in an Integration in Using Integrations in Oracle Integration 3.

23.04

Stage file action - Configure the segment size to a value greater than 200 records.

The Read File in Segments operation in the stage file action enables you to set a segment size larger than 200 records.

See Configure a Stage File Action in Using Integrations in Oracle Integration 3.

23.04

ServiceNow Adapter - OAuth Three-Legged Authorization Code Credentials security policy support

The ServiceNow Adapter supports REST APIs protected using OAuth 2.0 three-legged authentication with the Authorization Code Credentials security policy.

See ServiceNow Adapter Capabilities in Using the ServiceNow Adapter with Oracle Integration 3.

23.04

OData Adapter - New adapter

The OData Adapter (short for Open Data Protocol) enables you to integrate a cloud application that exposes data by OData services with Oracle Integration.

See OData Adapter Capabilities in Using the OData Adapter with Oracle Integration 3.

23.04
Primavera Unifier Adapter - New adapter

The Primavera Unifier Adapter enables you to set up a connection with Primavera Unifier or Unifier Essentials. This connection can integrate with Unifier and other Oracle and non-Oracle applications or endpoints.

Use the Primavera Unifier Adapter to fetch, create, or update a Business Process (BP) record (without attachments) in Unifier. It provides for an easy selection of the BP needed for integration.

See Primavera Unifier Adapter Capabilities in Using the Oracle Primavera Unifier Adapter with Oracle Integration 3.

23.04
SAP S/4HANA Cloud Adapter - Client Certificate-based security policy support

The SAP S/4HANA Cloud Adapter supports SAP S/4HANA OData APIs protected using client certificate-based authentication.

See SAP S/4HANA Cloud Adapter Capabilities in Using the SAP S/4HANA Cloud Adapter with Oracle Integration 3.

23.04

PostgreSQL Adapter - Polling and SQL statement execution support
The PostgreSQL Adapter has been enhanced to support the following:
  • For trigger endpoints:
    • Support for polling new and updated records.
    • Support for a logical delete polling strategy.
    • Support for processing message payloads up to 10 MB in size.
  • For invoke endpoints:
    • Execution of DML statements such as Select, Insert, Update, and Delete using the Run a SQL Statement option.

See PostgreSQL Adapter Capabilities in Using the PostgreSQL Adapter with Oracle Integration 3.

23.04
Netezza Adapter - Stored procedure and polling support
The Netezza Adapter has been enhanced to support the following:
  • For trigger endpoints:
    • Support for polling new and updated records.
    • Support for a logical delete polling strategy.
    • Support for processing message payloads up to 10 MB in size.
  • For invoke endpoints:
    • Support for invocation of stored procedures.

See Netezza Adapter Capabilities in Using the Netezza Adapter with Oracle Integration 3.

23.04

Oracle Intelligent Track and Trace Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

The Oracle Intelligent Track and Trace Adapter enables you to create an integration between Oracle Intelligent Track and Trace and Oracle Integration.

See Oracle Intelligent Track and Trace Adapter Capabilities in Using the Oracle Intelligent Track and Trace Adapter with Oracle Integration 3.

23.04

Oracle Intelligent Advisor Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

Use the Oracle Intelligent Advisor Adapter in an integration to allow web interviews to trigger Oracle Integration integrations as the endpoints for data operations, and to allow Intelligent Advisor decision assessments to be invoked at any point in an integration.

See Oracle Intelligent Advisor Adapter Capabilities in Using the Oracle Intelligent Advisor Adapter with Oracle Integration 3.

23.04

File Server Features

Feature Description Minimum Version Required

Support for additional algorithms

File Server now supports additional algorithms. The following RSA algorithms are available in the Signature Algorithms field on the File Server Settings page.

  • rsa-sha2-256

  • rsa-sha2-512

The new algorithms are selected by default only if you've never saved the File Server Settings page. Otherwise, you must enable them if you want to use them. After enabling one or more new algorithms, you must update your known_hosts file, or a warning prevents you from connecting to File Server. See Update the List of Supported Algorithms in Using File Server in Oracle Integration 3.

23.04

B2B for Oracle Integration Features

Feature Description Minimum Version Required

B2B for Oracle Integration

B2B for Oracle Integration continues to be enhanced with new features:

23.04

March 2023

Common Features

Feature Description Minimum Version Required
Tenancy migration to identity domains

Starting this month, Oracle begins a region-by-region migration of all tenancies to use identity domains. Tenancy owners will be notified two weeks prior to the migration of their tenancy. All IDCS instances in the tenancy will be converted at the same time regardless of the IDCS home region.

Your tenancy already uses identity domains if Oracle updated your region to use identity domains before you created your tenancy. However, if Oracle updated your region to use identity domains after you created your tenancy, then your tenancy will be migrated. If you are not sure if your tenancy uses identity domains, see Differences Between Tenancies With and Without Identity Domains in Provisioning and Administering Oracle Integration 3.

The migration to identity domains includes the migration of all users, groups, and roles. Once your tenancy has been migrated to use identity domains, subsequent maintenance of users, groups, and roles is done in Oracle Cloud Infrastructure Identity and Access Management (IAM). You will no longer use Oracle Identity Cloud Service (IDCS) or federation to manage users, groups, and roles. See Manage Access in an Identity Domain in Provisioning and Administering Oracle Integration 3.

N/A
New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A
Improved Recipes and Accelerators page in the Oracle Help Center

The Recipes and Accelerators page on the Oracle Help Center has been updated to provide two views: a card view and a list view. In both views, you can search on keywords to filter for only those recipes and accelerators of interest to you. The adapters used by each recipe are represented by product icons, which you can click to open the associated adapter documentation.


Recipes and Accelerators page in the Oracle Help Center

N/A

Visual Builder Features

Feature Description Minimum Version Required

Visual Builder support

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

New versions of Visual Builder are now supported in Oracle Integration 3.

Use Visual Builder to quickly create and publish custom web and mobile applications using a visual development tool. Build the pages in your application using components that you place on a canvas, and integrate with other services.

To use Visual Builder in Oracle Integration, you must first complete prerequisite tasks. See Use Visual Builder in Oracle Integration in Provisioning and Administering Oracle Integration 3.

The following Visual Builder documentation is available on the Oracle Help Center:

  • Administering Oracle Visual Builder in Oracle Integration 3
  • Developing Applications with Oracle Visual Builder in Oracle Integration 3
  • Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  • Managing Data Using Oracle Visual Builder Add-in for Excel
  • Oracle Visual Builder Page Model Reference
  • Accessing Business Objects Using REST APIs

Want to know the status of upgrading Visual Builder instances from Oracle Integration Generation 2 to Oracle Integration 3. See Upgrade from Oracle Integration Generation 2 to Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

23.02.2

February 2023

Common Features

Feature Description Minimum Version Required

Additional instances are ready for upgrade

The following Oracle Integration Generation 2 instances can now be upgraded to Oracle Integration 3:

  • Instances that use B2B for Oracle Integration.

    You must complete some steps before the upgrade, and be aware that your data retention settings impact whether you can upgrade. See Upgrade Considerations for Capabilities in Provisioning and Administering Oracle Integration 3.

  • Instances that use the connectivity agent.

    You must complete some steps before the upgrade. See Upgrade Considerations for Capabilities in Provisioning and Administering Oracle Integration 3.

  • Instances that use the Oracle Unity Adapter.

See Upgrade from Oracle Integration Generation 2 to Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

Note: During upgrade, the Generation 2 connectivity agent is automatically converted from using basic authentication to using OAuth 2.0 token-based authentication to invoke Oracle Integration endpoints. See Considerations for Capabilities in Provisioning and Administering Oracle Integration 3.

23.02

New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

Integration and Connectivity Features

Feature Description Minimum Version Required

Integration project enhancements

Integration projects continue to be enhanced with new features:

  • You can create project deployments. During creation, you select the integrations and their specific versions to include. After creation, you can activate, deactivate, and export deployments. You can also edit, clone, and delete deployments of user-developed projects. See Create and Manage a Project Deployment in Using Integrations in Oracle Integration 3.
  • You can install recipe projects and accelerator projects from the Oracle Integration Store.
  • You can extend (customize) an integration in an accelerator project to process custom objects. See Extend an Integration in an Accelerator Project.
  • You can easily upgrade to a newer version of an accelerator project that is available in the Oracle Integration Store without losing your customizations. During upgrade, you are prompted to automatically merge any customizations that you made to your initial accelerator project into the newer version. See Upgrade an Accelerator Project.
  • You can search for integrations, connections, lookups, and JavaScript libraries in the project with the View all link at the bottom of each resource. You can also refine your search with the Filter Filter icon icon.
  • You can clone integrations, create new versions of an integration, view and edit the integration properties in integrations, and view a calendar of future scheduled integration runs. See Clone an Integration in a Project, Create a Version of an Integration in a Project, Update Property Values of an Integration in a Project, and View the Scheduled Integration Runs Calendar in a Project.
  • You can import user-developed, accelerator, and recipe projects into your instance. See Create or Import a Project in Using Integrations in Oracle Integration 3.
  • You can use the connectivity agent in integrations in a project. The connectivity agent manages all on-premises resources (credentials, artifacts) within the respective project or global (nonproject) context. The connectivity agent gets the project or global context information for each runtime and design-time request and reads resources, respectively.

See About Integration Projects and Design, Manage, and Monitor Integrations in Projects in Using Integrations in Oracle Integration 3.

23.02

Large payload support

The connectivity agent has been enhanced to support SaaS-to-SaaS connectivity with 50 MB structured payloads (JSON and XML).

See Service Limits in Provisioning and Administering Oracle Integration 3.

23.02

Dashboard and Error pages enhancements

The Observability part of Oracle Integration has been enhanced with the following features:

  • A Connections with error card is displayed on the Dashboard page. When you click this card, a graph of the connections with the most errors is displayed.

    See View the Dashboard in Using Integrations in Oracle Integration 3.

  • When a message is not accepted for resubmission on the Errors page, the Resubmission summary panel provides details about why this occurred.

    See Resubmit Failed Messages in Using Integrations in Oracle Integration 3.

23.02

Certificates page support for uploading signed key certificates

The Certificates page now enables you to upload signed key certificates. A common scenario for this certificate is when you must invoke a service that does not regard an OAuth client secret as secure. Instead, JWT assertions can be used to authenticate the client application without the use of a client secret. Oracle Integration instead uses the signing key to generate the JWT assertion.

See Upload an SSL Certificate in Using Integrations in Oracle Integration 3 and Invoke a Service API with a JWT Assertion in Using the REST Adapter with Oracle Integration 3.

23.02

Parallel action enhancements

The parallel action has been enhanced with the following features:
  • You can add scope, switch, logger, JavaScript, and notification actions inside a parallel action.
  • You can add a parallel action inside scope and switch actions.
  • If you attempt to add more than five branches to a parallel action, the menu option for adding a branch is disabled.

See Process Tasks in Parallel with a Parallel Action in Using Integrations in Oracle Integration 3.

23.02

REST Adapter - JWT assertion support for outbound invocations

You may have a business need to invoke a service that does not regard an OAuth client secret as secure. For these scenarios, you can use JWT assertions. JWT assertions supplement all flavors of OAuth by authenticating the client application without the use of a client secret.

See JWT Assertion Support for Outbound Invocations and Invoke a Service API with a JWT Assertion in Using the REST Adapter with Oracle Integration 3.

23.02

REST Adapter - RPST outbound security policy support

The REST Adapter supports the Resource Principal Session Token (RPST). RPST enables an Oracle Integration instance (the resource) to authenticate itself with and consume the resources of other Oracle Cloud Infrastructure service resources

See Resource Principal Session Token Support and Invoke a Service Provider API with a JWT Assertion in Using the REST Adapter with Oracle Integration 3.

23.02

SOAP Adapter - OAuth Client Credentials and OAuth Authorization Code Credentials security policy policies support

SOAP Adapter invoke connections now support OAuth authentication with the addition of two new security policies:
  • OAuth Client Credentials
  • OAuth Authorization Code Credentials

See Configure Connection Security and SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration 3.

23.02

Netezza Adapter - New adapter

The Netezza Adapter is the latest addition to the database group of adapters. The Netezza Adapter enables you to integrate Oracle Integration with a Netezza database residing behind the firewall of your on-premises environment through use of the on-premises connectivity agent.

See Netezza Adapter Capabilities in Using the Netezza Adapter with Oracle Integration 3.

23.02

IBM MQ Series JMS Adapter - SSL support

You can configure the IBM MQ Series JMS Adapter to use SSL if your IBM MQ Series instance is SSL-enabled.

See IBM MQ Series JMS Adapter Capabilities in Using the IBM MQ Series JMS Adapter with Oracle Integration 3.

23.02

SAP Concur Adapter - Regeneration support

The SAP Concur Adapter supports artifact regeneration. For example, when a new custom property is added in SAP Concur, you can view it in the mapper for an existing integration after clicking the SAP Concur Adapter and selecting Refresh Endpoints.

See SAP Concur Adapter Capabilities in Using the SAP Concur Adapter with Oracle Integration 3.

23.02

SAP ASE (Sybase) Adapter - Bulk data import and pagination support

The SAP ASE (Sybase) Adapter supports the import of bulk data into an SAP ASE (Sybase) database. You can also implement pagination when fetching a large number of records for a Select query and receive sorted data in chunks.

See SAP ASE (Sybase) Adapter Capabilities in Using the SAP ASE (Sybase) Adapter with Oracle Integration 3.

23.02

Oracle Unity Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

The Oracle Unity Adapter is the newest addition to the CX group of adapters in Oracle Integration 3. The Oracle Unity Adapter enables you to create an integration between Oracle Unity using Oracle Integration seamlessly without any complexities.

See Oracle Unity Adapter Capabilities in Using the Oracle Unity Adapter with Oracle Integration 3.

23.02

File Server Features

Feature Description Minimum Version Required

Support for additional algorithms

File Server now supports additional algorithms. These algorithms are available in the Signature Algorithms field on the File Server Settings page. Previously, only the ssa-rsa algorithm was available.

New EdDSA algorithm

  • ssh-ed25519

New ECDSA algorithms

  • ecdsa-sha2-nistp256
  • ecdsa-sha2-nistp384
  • ecdsa-sha2-nistp521

The new algorithms are selected by default only if you've never saved the File Server Settings page. Otherwise, you must enable them if you want to use them. After enabling one or more new algorithms, you must update your known_hosts file, or a warning prevents you from connecting to File Server. See Update the List of Supported Algorithms in Using File Server in Oracle Integration 3.

23.02

B2B for Oracle Integration Features

Feature Description Minimum Version Required

B2B for Oracle Integration support

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

B2B for Oracle Integration is now supported in Oracle Integration 3. B2B for Oracle Integration provides for the secure and reliable exchange of business documents between Oracle Integration and trading partners. Oracle Integration supports the EDI X12 and EDIFACT business protocols for the exchange of business documents between Oracle Integration and trading partners.

See Introduction to B2B for Oracle Integration in Using B2B for Oracle Integration 3.

23.02

AS2 Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

The AS2 Adapter is now supported in Oracle Integration 3. Applicability Statement 2 (AS2) is a very popular HTTP-based protocol to transfer files or messages securely over the internet. AS2 is predominantly used in B2B communications to exchange electronic documents between companies.

See AS2 Adapter Capabilities in Using the AS2 Adapter with Oracle Integration 3 .

23.02

Visual Builder Features

Feature Description Minimum Version Required

Visual Builder support

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

New versions of Visual Builder are now supported in Oracle Integration 3.

Use Visual Builder to quickly create and publish custom web and mobile applications using a visual development tool. Build the pages in your application using components that you place on a canvas, and integrate with other services.

To use Visual Builder in Oracle Integration, you must first complete prerequisite tasks. See Use Visual Builder in Oracle Integration in Provisioning and Administering Oracle Integration 3.

The following Visual Builder documentation is available on the Oracle Help Center:

  • Administering Oracle Visual Builder in Oracle Integration 3
  • Developing Applications with Oracle Visual Builder in Oracle Integration 3
  • Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  • Managing Data Using Oracle Visual Builder Add-in for Excel
  • Oracle Visual Builder Page Model Reference
  • Accessing Business Objects Using REST APIs

Want to know the status of upgrading Visual Builder instances from Oracle Integration Generation 2 to Oracle Integration 3. See Upgrade from Oracle Integration Generation 2 to Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

23.02.2

January 2023

Common Features

Feature Description Minimum Version Required
New recipes The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

December 2022

Common Features

Feature Description Minimum Version Required

Additional instances are ready for upgrade

Oracle Integration Generation 2 instances that use File Server can now be upgraded to Oracle Integration 3.

Additionally, instances that use the Oracle Responsys Adapter can also be upgraded.

Previously, instances that used File Server or the Oracle Responsys Adapter were not ready for upgrade.

See Upgrade from Oracle Integration Generation 2 to Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

Latest version of Oracle Integration Generation 2

Stop and start an instance

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

You can now start and stop an Oracle Integration 3 instance.

See Stopping and Starting an Instance in Provisioning and Administering Oracle Integration 3.

22.12

New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

Integration and Connectivity Features

Feature Description Minimum Version Required
Project support in Oracle Integration

You can create integration projects in Oracle Integration. An integration project consists of self-contained assets (integrations, connections, lookups, and JavaScript libraries) bundled into a solution that can be developed, managed, and monitored as a single unit from a single workspace.

A top-level Projects option is provided in the navigation pane. The Projects option includes all the necessary design, management, and monitoring tasks. You do not need to navigate to the Design and Observability options when working in a project workspace. All assets created in a project (integrations, connections, lookups, and JavaScript libraries) are visible and usable only in that project. This provides you with an uncluttered view; you only see the assets in which you are interested.

See About Integration Projects and Designing, Managing, and Monitoring Integrations in Projects in Using Integrations in Oracle Integration 3.

22.12
Support for parallel actions in integrations

You can add parallel actions to integrations. A parallel action processes tasks in parallel to improve integration performance and response times. A parallel action allows the path of an integration to be split into multiple branches. Each branch is processed in parallel due to their independence from each other. Messages are sent to each service endpoint in parallel. When all tasks are completed, all branches are synchronized at their termination points in the parallel action and the main path of the integration is resumed.

See Process Tasks in Parallel with a Parallel Action in Using Integrations in Oracle Integration 3.

22.12
Improved monitoring user experience The Observability section continues to be improved:
  • The state of scheduled integrations is displayed in a label on the Monitor integrations page (for example, running, stopped, paused, and other states). Based on the state, applicable tasks are displayed under the Actions Actions icon menu (for example, if the scheduled instance state is stopped, selections for Edit Schedule, Run, Schedule, and Start Schedule are displayed).
  • The Filter Filter icon option on the Instances page now includes an Integration style option to search for all, app driven orchestration, or scheduled orchestration integrations.
  • Invoke messages for an instance have been consolidated into a single invoke milestone in the activity stream. You can expand the invoke milestone to display more specific details about invoke activities, such as message received. message sent to a local integration, message received by a local integration, and message processing completed.

See Monitor the Message Processing Status of Integrations, Filter the Display of Integration Instances, and Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

22.12
Refresh integration endpoints

The Regenerate Artifacts option has been renamed to Refresh endpoints in the Actions Actions icon menu on the Integrations list page. In addition to refreshing integration endpoints on the Integrations list page, you can now also refresh endpoints directly from a Refresh endpoints Refresh endpoints icon icon within the integration canvas.

See Refresh Endpoints for Integrations in Using Integrations in Oracle Integration 3.

22.12
Snowflake Adapter - New adapter

The Snowflake Adapter is a new addition to the database group of adapters. The Snowflake Adapter enables you to integrate the Snowflake cloud database with Oracle Integration. The Snowflake Adapter supports bulk import of data from cloud storages such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP) into the table of the Snowflake cloud database. Likewise, the Snowflake Adapter supports bulk export of data into cloud storages such as AWS, Azure, and GCP from the table of a Snowflake Cloud database.

See Snowflake Adapter Capabilities in Using the Snowflake Adapter with Oracle Integration 3.

22.12
PostgreSQL Adapter - New adapter

The PostgreSQL Adapter is a new addition to the database group of adapters. The PostgreSQL Adapter enables you to integrate a PostgreSQL cloud database with Oracle Integration. The PostgreSQL Adapter also enables you to integrate a PostgreSQL database residing behind the firewall of your on-premises environment with Oracle Integration through use of the on-premises connectivity agent.

See PostgreSQL Adapter Capabilities in Using the PostgreSQL Adapter with Oracle Integration 3.

22.12
Oracle Primavera Cloud Adapter - New adapter

The Oracle Primavera Cloud Adapter is a new addition to the industries group of adapters. Oracle Primavera Cloud brings together office and field teams, synchronizing schedules and resources and empowering the decisions that engineering and construction professionals make every day on projects through the world. The Oracle Primavera Cloud Adapter enables you to create an integration in Oracle Integration. The Oracle Primavera Cloud Adapter allows for connection setup between Oracle Primavera Cloud and other Oracle or third-party applications or endpoints. You can read a project schedule from Primavera Cloud in a single call, select the business objects needed for integration, map data across multiple business objects, read and write data in Primavera Cloud in a single call, and automatically create or update data without specifying if the data already exists.

See Oracle Primavera Cloud Adapter Capabilities in Using the Oracle Primavera Cloud Adapter with Oracle Integration 3.

22.12
Workday Adapter - Authorization Code Credentials security policy support

The Workday Adapter supports the Authorization Code Credentials security policy. You register an API client in Workday to generate the client ID and client secret that you use to configure a connection.

See Register an API Client to Use the Authorization Code Credentials Security Policy in Using the Workday Adapter with Oracle Integration 3.

22.12
Salesforce Adapter - Bulk 2.0 support

The Salesforce Adapter supports Bulk 2.0 operations. You can perform Create, Update, Upsert, Delete, and other operations on business objects supported by Salesforce. For example, you can process large data sets asynchronously with different Bulk 2.0 data operations or get successful, failed, and unprocessed records using the Bulk 2.0 operations.

See Salesforce Adapter Capabilities in Using the Salesforce Adapter with Oracle Integration 3.

22.12
Jira Adapter - Trigger connection support for events

The Jira Adapter provides trigger connection support for the Project Created, Project Updated, and Project Deleted events.

See Jira Adapter Capabilities in Using the Jira Adapter with Oracle Integration 3.

22.12

Oracle Responsys Adapter - Oracle Integration 3 support

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

Use the Oracle Responsys Adapter to extract customer profile data from customer relationship management, sales automation, and commerce applications.

See Oracle Responsys Adapter Capabilities in Using the Oracle Responsys Adapter with Oracle Integration 3.

22.12

November 2022

Common Features

Feature Description Minimum Version Required
New region availability
Oracle Integration 3 is now available for provisioning in the following regions.
  • Ashburn
  • Madrid
  • Queretaro

See Availability in Provisioning and Administering Oracle Integration 3.

22.10
Upgrade to Oracle Integration 3

Upgrades to Oracle Integration 3 have begun! When your instance becomes eligible for upgrade, you receive an email from Oracle about the timing.

Resources in Provisioning and Administering Oracle Integration 3:

Latest version of Oracle Integration Generation 2

New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

Integration and Connectivity Features

Feature Description Minimum Version Required
Customer tenancy use for notification emails

You can increase the number of emails you send in a rolling 24-hour window by using your own customer tenancy instead of the default method. The email limit allowed is determined by the Oracle Cloud Infrastructure Email Delivery Service. You also manage the approved senders and the suppression list from your customer tenancy.

See Configure Notification Emails and Monitor the Number of Emails Sent from Oracle Integration in Using Integrations in Oracle Integration 3.

22.10
Improved monitoring user experience

The Dashboard page includes enhanced charts for instance status and design time.

See View the Dashboard in Using Integrations in Oracle Integration 3.

22.10
View the calendar of scheduled integration runs

You can view the calendar of scheduled integration runs by day (by minute or hour), week, or month on the Future runs page.

See View the Scheduled Integration Runs Calendar in Using Integrations in Oracle Integration 3.

22.10
JavaScript functions to implement hash-based message authentication code (HMAC) encryption

You can include crypto libraries in JavaScript actions in app driven orchestration integrations. Crypto libraries enable you to create functions to achieve HMAC encryptions.

See Write JavaScript in Using Integrations in Oracle Integration 3.

22.10
Connectivity agent support for OAuth 2.0 token-based authentication

The on-premises connectivity agent now uses OAuth 2.0 token-based authentication when invoking endpoints in Oracle Integration. Basic authentication is not supported. Connectivity agent installation has also been simplified. Most installation parameters are now automatically configured for you and an OAuth client application is automatically created in Oracle Identity Cloud Service for facilitating OAuth 2.0 token-based authentication.

See Create an Agent Group and Agent Download and Installation in Using Integrations in Oracle Integration 3.

22.10
View the reason for instance termination in the activity stream

The reasons for instance terminations are displayed in the activity stream for asynchronous and scheduled integrations. This provides you with a clear reason for why instances have been terminated.

See View the Reason for Terminated Integration Instances in the Activity Stream in Using Integrations in Oracle Integration 3.

22.10
Microsoft Office 365 Calendar Adapter, Microsoft Office 365 People Adapter, and Microsoft Office 365 Outlook Adapter - Microsoft Outlook REST APIs unsupported

Microsoft has decommissioned the Microsoft Outlook REST APIs in November 2022. You must now use the Microsoft Graph REST APIs.

See:
22.10
simpleType element support in the REST Adapter

The REST Adapter supports schemas with simpleTypes having the restriction facet enabled. Both named and anonymous types are supported.

See REST Adapter Capabilities in Using the REST Adapter with Oracle Integration 3.

22.10
Perform integration tasks in panels

The user interface for integration design continues to be redesigned to use panels that slide open on the right side of the page. Panels are now displayed when performing the following tasks:

  • Creating, importing, or cloning an integration, or creating a new version (draft) of an integration
  • Importing a library file
  • Importing, creating, or cloning a lookup

See Create an Integration, Manage Integrations, Use JavaScript Libraries in Integrations, and Manage Lookups in Using Integrations in Oracle Integration 3.

22.10
Oracle WebLogic JMS Adapter - Filter out weighted distributed queues

The Oracle WebLogic JMS Adapter doesn't support weighted distributed queues. Oracle Integration filters out weighted distributed queues in order to ensure successful agent connectivity with the on-premises JMS WebLogic cluster. Oracle recommends that you use uniform distributed queues instead of weighted distributed queues.

See Oracle WebLogic JMS Adapter Restrictions in Using the Oracle WebLogic JMS Adapter with Oracle Integration 3.

22.10
Local integration invocations handled separately in the activity stream

You can view a child integration being invoked by a parent integration in a separate activity stream. You can also view the separate activity streams for one integration that invokes another integration, which then invokes a child integration. Each activity stream is connected by a Back icon button that provides easy access.

See Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

22.10
SAP ASE (Sybase) Adapter

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

Oracle Integration 3 now supports the SAP ASE (Sybase) Adapter. The SAP ASE (Sybase) Adapter is the newest addition to the database group of adapters. The SAP ASE (Sybase) Adapter enables you to integrate with the SAP ASE database residing behind the firewall of your on-premises environment through use of the Oracle Integration on-premises connectivity agent. You can use the SAP ASE (Sybase) Adapter to poll for new and updated records for further processing in Oracle Integration. For example, any new row added to the Customer table in your SAP ASE database can be synchronized with a target CRM application with Oracle Integration. The SAP ASE (Sybase) Adapter also supports executing SQL queries and stored procedures in your SAP ASE database.

See SAP ASE (Sybase) Adapter Capabilities in Using the SAP ASE (Sybase) Adapter with Oracle Integration 3.

22.10
Shopify Adapter - Access token authentication support

This Oracle Integration Generation 2 feature is now available in Oracle Integration 3.

The Shopify Adapter now supports Shopify access token-based authentication. You must create a custom application in Shopify and provide the Admin API access token in the Shopify Adapter to successfully connect to the Shopify application. This is now necessary because Shopify deprecated private applications starting in January 2022 (therefore, the need to create a custom application).

The Shopify Adapter is now certified with Shopify API version 2022-04.

See Shopify Adapter Capabilities in Using the Shopify Adapter with Oracle Integration 3.

22.10

File Server Features

Feature Description Minimum Version Required

Increase in maximum concurrent connections

For File Server, the maximum number of concurrent connections per service instance has increased from 20 to 50.

22.10

October 2022

Common Features

Feature Description Minimum Version Required

New region availability

Oracle Integration 3 is now available for provisioning in the following regions.
  • Frankfurt
  • Johannesburg
  • London
  • Mumbai
  • Sao Paulo
  • Sydney

See Availability in Provisioning and Administering Oracle Integration 3.

22.08

New recipe

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

September 2022

Common Features

Feature Description Minimum Version Required

New workshops

The following LiveLabs workshops are now available:

N/A

New recipe

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A

Logging activity stream data

Capturing the activity stream in the Oracle Cloud Infrastructure Console is now supported. This capability was previously available in Oracle Integration Generation 2.

See Capture the Activity Stream in Oracle Cloud Infrastructure Console in Provisioning and Administering Oracle Integration 3.

22.08

Integration and Connectivity Features

Feature Description Minimum Version Required
Automatic saving of mapper updates

Changes you make in the mapper are automatically saved, eliminating the need to click Validate or Save.

See Save Changes Automatically in Using the Oracle Mapper with Oracle Integration 3.

22.08
Keyboard shortcuts

Keyboard shortcuts are available for use in the integration canvas.

See Keyboard Shortcuts in the Integration Canvas and the Mapper in Using Integrations in Oracle Integration 3.

22.08
JavaScript file editor

You can edit JavaScript file code in Oracle Integration without the need to export the code to an external editor for editing.

See Update JavaScript Files in Using Integrations in Oracle Integration 3.

22.08
Filter the display of errors in the activity stream

You can filter the activity stream to quickly show error content only. This option can be useful for instances in which a logic action such as a for-each loop or while loop with many iterations has failed. This option enables you to jump quickly to the iteration that failed instead of scrolling through each iteration of the loop.

See View Error Messages and the Message Payload in the Activity Stream of Failed Instances in Using Integrations in Oracle Integration 3.

22.08
Separate display of HTTP headers and payload in the activity stream

The HTTP headers and payload in the activity stream are now displayed separately. This makes for an easier viewing experience.

See Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

22.08
Enforcement of 700 active integrations limit

You can activate up to 700 integrations per instance. When the limit is exceeded, you are prevented from activating additional integrations.

See Activate an Integration and View the Dashboard in Using Integrations in Oracle Integration 3.

22.08
NAT gateway IP address (outbound IP address) in the About menu

You can obtain the NAT gateway IP address (outbound IP address) of your Oracle Integration instance from the About menu. The outbound IP address is required to allowlist the instance. This feature eliminates the need to file a service request to obtain the outbound IP address.

See Obtain the NAT Gateway IP Address of the Oracle Integration Instance in Provisioning and Administering Oracle Integration 3.

22.0.8

August 2022

Common Features

Feature Description Minimum Version Required
New recipes

The following new recipes have been added to Oracle Integration 3 to help you jump start your integration development. Simply install, configure, and activate.

See Recipes and Accelerators on the Oracle Help Center for a list of all Oracle Integration recipes.

N/A
Oracle Redwood theme

The Oracle Integration user interface reflects the Oracle Redwood look and feel. All screenshots, icons, and terminology has been updated in the Oracle Integration library accordingly.

22.06

Oracle Cloud Infrastructure Console

Version information appears when applicable

The user interface for the Oracle Cloud Infrastructure Console shows version information, so you can tell the version of each instance, either Oracle Integration Generation 2 or Oracle Integration 3. Version information appears only if you have or can create instances for both versions.

Find version information when you create an instance, view a list of instances, and view instance details.

22.06

Oracle Cloud Infrastructure Console

Ability to provision an Oracle Integration 3 instance

If you are a new customer to Oracle Integration 3, you can provision an Oracle Integration 3 instance at any time.

If you are an existing Oracle Integration Generation 2 customer, you can provision an Oracle Integration 3 instance only after Oracle upgrades at least one of your instances to Oracle Integration 3.

Provision new instances in the Oracle Cloud Infrastructure Console.

22.06

Oracle Cloud Infrastructure Console

Shape determines your upgrade window

When you create an instance in the Oracle Cloud Infrastructure Console, you must choose a shape, either Production or Development.

The shape determines when the instance receives monthly and quarterly updates. Instances with a Development shape receive updates two weeks before instances with a Production shape.

Note: You can't change the shape after you create the instance. However, you can move data to another instance using the export and import capabilities.

22.06

Oracle Cloud Infrastructure Console

Real-time billing and usage data

Make informed decisions about the number of message packs to purchase, thanks to real-time billing and usage data that is now available in the Oracle Cloud Infrastructure Console. On the Metrics Explorer page, the new graphs show the number of messages that you purchased and that you've used. View data for a single instance or all instances in a compartment, and examine the data using sophisticated analysis tools.

In Oracle Integration Generation 2, you monitored billable messages in the Oracle Integration interface, on the Usage Metrics page. The Usage Metrics page is no longer available; the data that was visible on the Usage Metrics page is now available in the Oracle Cloud Infrastructure Console.

See Viewing Message Metrics in Provisioning and Administering Oracle Integration 3.

22.06

Oracle Integration Home page metrics

On the home page, you can see the total number of messages, total errors, and the number of failed integrations. You can also view existing integrations or create new ones from the home page and view recent activities with their status. You can select recipes or prebuilt integrations to solve your business needs and filter recipes by the applications they use.

See Navigate and Explore in Getting Started with Oracle Integration 3.

22.06

Integration and Connectivity Features

Feature Description Minimum Version Required
Configuration Editor wizard

A new Configuration Editor wizard is provided that enables you to configure the resources to include in a standalone integration or package of integrations, such as connections, lookups, libraries, and PGP certificates. You can edit all resources and replace connections and PGP certificates. You can also unlock any locked resources within the wizard instead of navigating to the individual pages of the resources.

See Edit and Replace Dependent Resources in Using Integrations in Oracle Integration 3.

22.06
Support for cutting and pasting elements in the integration canvas

You can cut and paste elements (actions and invokes) in the integration canvas. This enables you to move elements to other places in your integration and eliminates the need to recreate them.

See Cut and Paste Elements in the Integration Canvas in Using Integrations in Oracle Integration 3.

22.06
Expandable and collapsible actions

You can expand and collapse logic actions in the integration canvas (for example, a scope, while, for-each, switch, and others) to see child actions and view errors.

See Expand and Collapse Actions in the Integration Canvas in Using Integrations in Oracle Integration 3.

22.06
Menu simplification

The navigation pane has been simplified to include all tasks in three categories: Design, Observability (previously Monitoring), and Settings.

See Navigate Oracle Integration in Using Integrations in Oracle Integration 3.

22.06
Managing integration components in panels You now manage many integration components in a panel that slides open on the right side of the page, such as:
  • Designing integrations
  • Creating connections
  • Configuring adapter endpoints
  • Viewing the activity stream during runtime
  • Uploading certificates
  • Editing the email suppression list

See Create Application-Driven Orchestrated Integrations, Create a Connection, Understand Trigger and Invoke Connections, Track Integration Instances, Upload an SSL Certificate, and Remove Email Addresses from the Suppression List in Using Integrations in Oracle Integration 3.

22.06
Control activity stream data retention during integration activation
When you activate an integration, you can select the tracing level. The level you select determines how long your data is available in the activity stream:
  • Production: 32 days
  • Audit: 8 days
  • Debug (Not recommended): 24 hours

See Activate an Integration in Using Integrations in Oracle Integration 3.

22.06
Activity stream enhancements

The activity stream has received the following enhancements:

  • To improve performance, message payloads are accessible differently in the activity stream based on their size.
  • You can navigate to child integration instances on the Instance Details page.
  • Binary payloads can be downloaded from the activity stream.

See Understand Supported Activity Stream Payloads, Manage Errors, and Track Integration Instances in Using Integrations in Oracle Integration 3.

22.06
Instance ID change from integer to string

The system-generated instance ID that is displayed on the Instances page and in the activity stream for an integration instance has changed from an integer to a string.

22.06
Scheduled integration enhancements

The scheduler has received the following enhancements:

  • Future integrations are displayed as queued and the time at which the integration is scheduled to run is listed on the Instances page and in the activity stream.
  • The user interface has been enhanced. For example, when you run a scheduled integration, the activity stream panel opens on the right side of the page to show instance progress.

See Create Scheduled Integrations and Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

22.06
Scheduled integration performance improvements

Changes to the scheduler implementation may result in shorter wait times for scheduled integrations to execute when compared to Oracle Integration Generation 2.

See Service Limits in Provisioning and Administering Oracle Integration 3

22.06
Asynchronous integration regeneration

All integration regenerations are handled asynchronously. This reduces the chance for timeouts during regeneration.

See Regenerate a WSDL File for Integrations in Using Integrations in Oracle Integration 3.

22.06
Resubmission paths on Instance Details page

Resubmission paths for the looping iterations in logic actions such as a switch, for-each, while, and others are shown on the Instance Details page.

See Track the Status of Integration Instances in Using Integrations in Oracle Integration 3.

22.06
Instances page and Error page enhancements
  • Activity stream messages can be selected inside looping iterations of logic actions such as a for-each, while, and switch.
  • The Instances page shows scheduled integrations waiting in the queue to run, along with the Scheduled on label and the time at which the queued integration is scheduled to run.
  • Failed integration instances can be resubmitted up to 10 times.

See Track the Status of Integration Instances and Manage Errors in Using Integrations in Oracle Integration 3.

22.06
Mapper function, operator, and XSLT statement embedded help

Embedded online help for the mapper is provided. Click a specific function, operator, and XSLT statement in the mapper to show online help.

See Get Online Help for Functions, Operators, and XSLT Statements in Using the Oracle Mapper with Oracle Integration 3.

22.06
New mapper functions

Three new string functions are available for use in the mapper:

  • matches: Returns true if the supplied string matches a given regular expression.
  • replace: Returns a string created by replacing the given pattern with the replace argument.
  • tokenize: Returns a sequence of strings constructed by splitting the input whenever a separator is found.

Click each function in the mapper to show online help that describes its signature, parameters, and return values.

See Get Help for Functions in Using the Oracle Mapper with Oracle Integration 3.

22.06
Test mapper enhancements

The test mapper supports the testing of mappings you created with tracking variables and local variables in assign actions.

See Test Your Mappings in Using the Oracle Mapper with Oracle Integration 3.

22.06

Differences from Prior Versions of Oracle Integration

Features that are available in prior versions of Oracle Integration may not be available in Oracle Integration 3. These features may be permanently removed, replaced, enhanced, or not currently supported in Oracle Integration 3.

This page is updated when features become available in Oracle Integration 3.

Changes Between Oracle Integration Generation 2 and Oracle Integration 3

Audience Features in Prior Versions of Oracle Integration Equivalent or Enhanced Features in Oracle Integration 3

Administrator

User interface pages for:

  • Billed messages
  • Data retention

Administrator

Specifying how long to retain data and whether to purge data when low space is reached (available under Settings, then Data Retention in Oracle Integration Generation 2).

Oracle now handles this responsibility. See Oracle and Customer Responsibilities in Oracle Integration 3 in Provisioning and Administering Oracle Integration 3.

Administrator

Choosing the update window for an instance using tags.

The shape of an instance now determines its update window.

For new instances created in Oracle Integration 3, the person who created the instance chooses the shape during provisioning. For instances that you upgrade from Oracle Integration Generation 2, an administrator chooses the shape while scheduling the upgrade.

Administrator

Creating an instance in a region other than your home region.

To create an Oracle Integration Generation 2 instance in a region other than your home region, you first had to subscribe to the region in the Oracle Cloud Infrastructure Console.

For Oracle Integration 3 instances, the ability to create instances outside your home region depends on several factors. See Restrictions in Provisioning and Administering Oracle Integration 3.

Developer

Activity stream download API and download option on the Integration dashboards page under the View menu.

The activity stream has been greatly enhanced and can be viewed and downloaded from the Instances page, Instance Details page, and Errors page.

Developer

In Oracle Integration Generation 2, the on-premises connectivity agent is certified with JDK 8, 11, and JDK 17.

In Oracle Integration 3, the on-premises connectivity agent is certified only with JDK 11 and JDK 17.

Developer

When making an API call with the REST Adapter, you encode the integration identifier with %7C. For example:
ORCL-BA-ERP_OPERA_TRIGG_SYNC%7C01.00.0000
When making an API call with the REST Adapter, you encode the integration identifier with a pipe (|) symbol. For example:
ORCL-BA-ERP_OPERA_TRIGG_SYNC|01.00.0000

Not Currently Available in Oracle Integration 3

Audience Features in Prior Versions of Oracle Integration

All

Insight capability

Administrator

User interface pages for:

  • Import or export
  • Storage
  • Recommendations
  • API management

Administrator

Setting up custom endpoint URLs for an instance in the Oracle Cloud Infrastructure Console, as well as the following UpdateIntegrationInstance parameters in the REST API for Instance Management:

  • customEndpoint
  • alternateCustomEndpoints

Administrator

Creating an allowlist in the Oracle Cloud Infrastructure Console.

Developer

You cannot invoke a process from an integration.

Developer

The following recipes:

Note: Select another recipe from the Integration Store. See Recipes and Accelerators.

Developer

The continuous integration/continuous delivery (CI/CD) capabilities for integrations in Visual Builder Studio.

Not Supported in Oracle Integration 3

Audience Features in Prior Versions of Oracle Integration Alternatives in Oracle Integration 3

Administrator

Visual Builder instance administrator tasks:

  • Starting, stopping and deleting a Visual Builder instance.
  • Changing the node count.
  • Moving an instance to different compartment.

No alternative.

Administrator

B2B instance administrator tasks:

  • Using tags to set an instance's update window

No alternative.

Administrator

The REST API, command line interface (CLI) tool, and terraform script for creating an Oracle Integration instance include a parameter for enabling the file server. This parameter is not applicable in Oracle Integration Generation 3.

Enable the file server from the Oracle Cloud Infrastructure Console after creating the Oracle Integration instance.

Developer

Reporting incidents for problematic issues that occur during design time.

No alternative.

Developer

Basic routing integration style.

Create scheduled or app driven orchestration integrations.

Before you can upgrade from Oracle Integration Generation 2 to Oracle Integration 3, you must migrate your basic routing integrations to app driven orchestration integrations.

If you attempt to manually import an exported Oracle Integration Generation 2 basic routing integration into Oracle Integration 3, it is automatically converted to an app driven orchestration integration.

Developer

File transfer integration style.

Create a scheduled orchestration integration.

Developer

REST Adapter - Metadata Catalog URL, Swagger Definition URL, and RAML Definition URL connection types.

Developers with a REST API that is described using RAML or the Oracle metadata catalog must take the following action:

  1. Consult your REST service provider and ask for a Swagger definition (if available). Oracle Fusion Applications should have a Swagger option available. This is a guideline for all Oracle Fusion Applications.
  2. If an alternative spec is not available, use the basic template in the REST Adapter by selecting REST API Base URL as the connection URL and defining the target API request using the Adapter Endpoint Configuration Wizard.

Another option is to convert RAML into an OpenAPI specification to use with the REST Adapter connection.

To provide more robust and complete support for the Swagger/OpenAPI specifications, the REST Adapter includes a unified option to specify all OpenAPI specifications in a single field. This option also replaces the option to provide a Swagger definition URL, which is no longer available.

See Configure Connection Properties for Invoke Connections in Using the REST Adapter with Oracle Integration 3.

Developer

The following adapters are not available in Oracle Integration 3:

  • Automation Anywhere Adapter
  • Evernote Adapter
  • Oracle Monetization Cloud Adapter
  • Oracle Taleo Business Edition (TBE) Adapter
  • UiPath Robotic Process Automation Adapter

For the Automation Anywhere Adapter and UiPath Robotic Process Automation Adapter, use the REST API-based approach available with the technical adapters.

You can also select another adapter to use from our growing portfolio of hundreds of adapters. See Adapters.

Developer

Oracle NetSuite Adapter TBA authorization flow security policy support.

No alternative.

Developer

Delayed (asynchronous) response support in the following adapters:

  • Oracle CX Sales and B2B Service Adapter
  • Oracle ERP Cloud Adapter
  • Oracle HCM Cloud Adapter
  • Oracle Field Service Cloud Adapter
  • Salesforce Adapter
  • ServiceNow Adapter

No alternative.

Note the following behavior in Oracle Integration 3:

  • For new integrations created in Oracle Integration 3 or upgraded integrations from Generation 2, create the following invoke connections to achieve delayed response functionality:
    • Create a simple invoke for success callbacks.
    • Create an additional invoke for failure callbacks under the fault handler to catch the correct fault.

Developer

The AS2 Adapter available in the Standard edition can only be used in standalone mode in existing integrations upgraded from Oracle Integration Generation 2 (for example, for file transfer protocol use cases not using B2B features). You cannot create new integrations in standalone mode in Oracle Integration 3.

Use the AS2 Adapter with B2B features such as the B2B action, B2B design time, and B2B runtime. These features require use of the Enterprise edition in Oracle Integration 3.

Developer

Use of basic authentication with the Oracle-provided REST APIs.

Use OAuth with the Oracle-provided REST APIs instead.

See APIs and CLI.

About the Minimum Required Version

Many changes in this guide include the minimum required version, which is the minimum version that you must have to use the feature. Version numbers use the following convention: YY.MM. For example, the 23.02 update occurs in February 2023.

Patch Numbers

Sometimes the version number includes a patch number, too. For example, 23.02.1 for a patch that was applied after the 23.02 release. Patches typically include bug fixes and security improvements.

Changes Without a Minimum Version

Changes without a minimum required version are generally available to everyone, regardless of whether the update has been applied.

Determine Your Version

Updates are delivered to regions on a rolling schedule. You can determine whether the latest update has been applied by checking the version in the About dialog box.

Note:

Process Automation and Visual Builder have separate version numbers. You can follow these steps within either service to determine its version.

To determine whether an update has been applied to your instance:

  1. In the top pane, click your initials, and then select About.
    The About dialog appears.
  2. Check the number next to Version.
    In the About dialog, the Version field lists 23.02.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.