Oracle® Cloud

What's New for Oracle Integration

E84902-47

November 2019

What’s New for Oracle Integration

Learn about the new and changed features of Oracle Integration.

Note:

The information in this guide applies to all of your Oracle Integration instances. It doesn’t matter which edition you’re using, what features you have, or who manages your cloud environment. You’ll find what you need here, including notes about any differences between the various flavors of Oracle Integration when necessary.

Environment differences are highlighted by the following badges:

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Not Integration Classic Does not apply to Oracle Integration Classic (user-managed).

November 2019

New Features
Common Features
Feature Description Published

New to Oracle Integration?

  • If you have created an Oracle Cloud account on or after November 13th in one of the following seven regions, you can create instances in Oracle Cloud Infrastructure Gen 2. To get started, see Provisioning and Administering Oracle Integration on Oracle Cloud Infrastructure.

    • US East (Ashburn)

    • US West (Phoenix)

    • Canada Southeast (Toronto)

    • India West (Mumbai)

    • South Korea Central (Seoul)

    • Australia East (Sydney)

    • Japan East (Tokyo)

  • For all other customers, see the provisioning steps described in Ready, Set Up, Go.

November 13, 2019

Process Features
Feature Description Published

Web forms

We've added the following enhancements to web forms:

  • Clear error: A new action called Clear Error lets you clear error messages in form fields.

  • Side by side controls: You can now place form controls beside each other inside form containers such as panels, tabs, tables, sections, and repeatable sections.
  • Append and delete values: You can append and delete values to/from a select control. See Add an Option to a List of Value Field and Clear All Options From a List of Value Field in Using Processes in Oracle Integration.

  • Date functions: We've added new functions for data manipulation. See Specify Functions in Using Processes in Oracle Integration.

  • Reorder actions in events: You can now easily reorder actions within form control events. See Configure Events in Using Processes in Oracle Integration.

  • Reorder columns in tables: You can now easily reorder table columns.

November 13, 2019

New bot activity in the structured process editor

Drag the new Bot element onto the BPMN canvas to add an RPA (Robotic Process Automation) native activity to your process.

See Work with Bot Activities in Using Processes in Oracle Integration.

November 13, 2019

Migrating basic forms to web forms

Here's a reminder that when you migrate process applications that contain basic forms from Oracle Process Cloud Service to Oracle Integration, a placeholder web form is created automatically. Opening the imported form completes the transformation from basic form to web form. The new web form contains business objects, presentations, and layouts identical to the original form. Note that certain features of basic forms aren't supported or supported differently in web forms.

See Processes Migration Restrictions and Perform Post Import Steps for Processes in Migrating Oracle Integration Cloud Service and Process Cloud Service Instances to Oracle Cloud Infrastructure.

November 13, 2019

Dynamic Process on screen text enhancements

We've improved our overall terminology consistency for dynamic process modeling.

November 13, 2019

Resolved Issues
Integration Resolved Issues
Issue Resolution
Sample request payloads Sample request payloads have been added to the Open API/Swagger definition for integration endpoints.
Oracle HCM Cloud Adapter AbsoluteEndpointURI element The Oracle HCM Cloud Adapter AbsoluteEndpointURI element in the mapper correctly overrides configured endpoints at runtime.
REST Adapter JSON sample The formatting is retained when pasting an inline JSON sample in the REST Adapter.
EFF element descendant types EFF element descendant types successfully appear in the mapper after re-editing and regeneration.
Integration deactivation An integration with an active schedule can be deactivated without causing performance issues.
Faulted instances Faulted instances are created in monitoring for any authentication failures while calling integration endpoints.
Activity stream The activity stream does not throw an ICSLogReader:readLogLines() error when data is not present.
Instance execution status Instance execution status is not reported as both a success and failure when the instance has faulted on the Monitoring page.
REST Adapter request and response Integrations in which the REST Adapter is configured with a multipart/form-data request and JSON or XML sample response are successfully activated.
Oracle Database Adapter operation change You can change the operation configured for the Oracle Database Adapter during editing in the Adapter Endpoint Configuration Wizard.
Instance tracking data When there is a large amount of instance tracking data, an EclipseLink error does not appear on the Monitoring page.
XPath validation issues in the Expression Builder A NullPointerException error due to XPath validation issues in the Expression Builder no longer occurs.
Oracle Database Cloud Service Adapter-based integrations Existing Oracle Database Cloud Service Adapter-based integrations can connect to a migrated Oracle Autonomous Transaction Processing database. It is recommended that you use the Oracle Autonomous Transaction Processing Adapter for new connections and integrations created after migration to the Oracle Autonomous Transaction Processing database.
Low database space When underlying database space is low, an EclipseLink-related error is not displayed on the Monitoring page.
FTP Adapter with PGP encrypted and signed files PGP encrypted and signed files with the FTP Adapter are processed successfully.
xsi:nillable attribute in the REST Adapter The xsi:nillable attribute in the provided JSON sample for the REST Adapter is supported.
FTP Adapter and PASV mode PASV mode for the Microsoft IIS FTP server in the FTP Adapter is supported.
REST Adapter translation of array elements Translation of array elements having empty strings in XML to JSON in the REST Adapter is supported.
Oracle HCM Cloud Adapter Atom feed entries The Oracle HCM Cloud Adapter does not miss Atom feed entries with identical update dates.
Artifact propagation during activation Artifact propagation during activation through an automatic retry is successful.
REST Adapter and empty JSON arrays An issue with generation of empty JSON arrays in the REST Adapter has been resolved.
Tracking instance for a scheduled orchestrated integration You can view the tracking instance for a scheduled orchestrated integration whose scheduled parameters did not have default values.
Lookups referenced in the integration Lookups referenced in the integration are packaged in the IAR file.
Process Resolved Issues
Issue Resolution

Decision model overwrite

To prevent undesired side effects, a warning now displays when you activate a decision model runtime version that contains interface changes.

Invalid taskid resulting in 500 error

A 500 error that displayed when calling /tasks/{taskId}/payload REST API endpoint with an invalid taskId was resolved.

Email notification issue

An issue registering email addresses when setting up email notification has been resolved.

REST connector trimmed leading zeros

An issue has been resolved where values retrieved via connectors to display in form select controls removed prefixed zeros for numeric values represented as strings.

Activation cleared role membership

An issue was resolved where activation cleared BPMN role memberships for existing activated process applications.

Attachment names with white spaces

An issue was resolved where email notifications with attachment files containing white spaces in them weren't delivered.

Dynamic process activities corrupted

An issue that occurred when two concurrent tasks called from a dynamic process were executed at the same time was resolved.

Human task expiration incorrectly set

An issue was resolved where all human tasks in a cloned BPMN process were set to 1 day expiration.

Improperly populated connector select controls

An issue where web form select controls backed by connector information were not properly populated has been resolved.

Attachment names containing spaces

Implemented a consistent way of displaying attachment names containing white spaces using the process and task REST API endpoints.

Incorrect .exp file created

Exporting an application snapshot via REST API created an incorrect export file.

Null field incorrectly rendered

An issue where a null keyword used in email notifications still rendered has been resolved.

Attachments panel can't be closed

An issue where the Attachments panel couldn't be closed after downloading an attachment from the Process details page has been resolved.

Process Applications page not loading

An issue where the Process Applications list page did not load has been resolved.

October 2019

New Features
Integration Features
Feature Description Published
REST Adapter - Payload format name change in the Adapter Endpoint Configuration Wizard When creating an invoke connection in the Adapter Endpoint Configuration Wizard, the Raw request and response payload format selection is now called Binary on the Request and Response pages. October 14
REST Adapter - Oracle Cloud Infrastructure (OCI) Signature Version 1 security policy support

You can call the OCI REST API by configuring the REST Adapter connection to use the OCI Signature Version 1 security policy. This policy enables you to use Oracle Cloud Infrastructure services. For example, you can create an integration that calls Oracle Cloud Infrastructure to create a storage bucket.

See REST Adapter Concepts in Using the REST Adapter with Oracle Integration.

October 11
Monitoring pages - Custom time range with which to filter the search for instances You can specify a custom time range with which to filter the search for instances with the From and To buttons on the monitoring pages for Integrations. This enables you to select a time range as small as a minute and track only those instances processed within that specified time range. The specified time range is preserved by default and applied to the data being displayed when you navigate from one monitoring page to another (for example, when you move from the Track Instances page to the Integrations, Track Runs, or Errors page).

See Track Business Identifiers in Integrations During Runtime in Using Integrations in Oracle Integration.

October 11
Orchestrated integrations - Pseudo view and layout view Multiple layouts of an orchestrated integration are provided. Pseudo view enables you to view the integration vertically with child nodes indented. Details about each node in the integration are displayed to the right. You can edit the integration by selecting the + sign to invoke an inline menu for adding invokes and actions. Layout view enables you to view the integration horizontally or vertically.

See Create an Orchestrated Integration in Using Integrations in Oracle Integration.

October 11
Process Features
Feature Description Published

Improved activation experience

The override option when activating a process application is no longer available. This is to avoid accidentally selecting it and losing all the instances for the version that you are activating.

  • If you want to delete all the existing instances for testing purposes, select the test partition when you activate your process application. If you use the test partition, the existing instances are deleted each time you activate.

  • To keep existing instances, activate using the production partition, and use incremental version numbers each time you activate. To delete all the existing instances in a production partition, deactivate the process version and then reactivate it again using the same version number. When you deactivate a version of a process, that version ceases to exist.

See Activate Applications in Using Processes in Oracle Integration.

October 30, 2019

September 2019

New Features
New Common Features
Feature Description Published

My Services replaced with Platform Services in the Oracle Cloud Infrastructure Console

After signing into Oracle Cloud, account administrators use the Oracle Cloud Infrastructure Console to access Integration under Platform Services. Previously you accessed these services from the My Services Dashboard.

See Access Oracle Integration in Administering Oracle Integration and the Oracle Cloud Infrastructure Blog.

September 9

Integration Features
Feature Description Published
Scheduled parameters - business identifier assignment

You can create and assign scheduled parameters as business identifiers that enable you to track fields in messages during runtime.

See Create Parameters in Scheduled Integrations in Using Integrations in Oracle Integration.

September 20
Visual Builder Features
Feature Description Published
Upgrade Oracle JET design time and runtime

The Visual Builder design-time was upgraded to use JET 7.0.1 and the JET runtime was upgraded to version 7.1.0.

September 27
New declarative actions

The following new actions have been added:

  • A new geolocation action has been added to allow declarative access to the user's current location.
  • A new Share action allows mobile applications to invoke the native sharing capabilities of the host platform and share content with other applications, such as Facebook, Twitter, and Slack.
  • Support for Cordova's pause and resume events (vbPause, vbResume) was added. The vbPause event fires when the native platform puts the application into the background, typically when the user switches to a different application. The vbResume event fires when the native platform pulls the application out from the background.
  • A "video" option was added to the list of mediaType parameters of the TakePhoto action. Selecting "video" will record a video or allow an existing videos to be selected. In web apps, selecting the video mediaType will open a dialog where non-video files are filtered out. In PWA apps on iOS and Android and iOS native apps, the option allows video recording using the camera, or selecting a video file. In Android native apps, only file selection is allowed. Recording using the camera is not supported.
September 27
New Custom Event contract

A new "navigateToItem" custom event is declared by default in new mobile and web applications created with templates using navigation items (drawer/tab) on the root page (or Shell Page). The custom event provides an easy way for you to configure navigation between items/tabs. An event listener for switching the item/tab is defined by default in the root or shell page.

September 27
New UI for building filters

A new UI has been added in the mapper to help with creating FilterCriterion to filter the output for SDP (Service Data Provider) variables and call REST actions.

September 27
Added support for registering your own Oracle DB instance

An administrator can now use a wizard in the Tenant Settings to switch the Tenant schema to another Oracle DB instance that has more space. By using your own Oracle DB instance you will also have direct SQL access to the tables created for your business objects.

In the wizard, the administrator can specify a DBaaS or Autonomous Database instance. The wizard includes a tool for selecting which projects in the tenant are downloaded prior to switching to the new DB instance.

September 27
New UI for managing user roles

The UI in the Settings editor for creating and managing user roles in a visual application has been updated and streamlined. When creating a user role, the user role and the users and groups assigned to it, are now created directly in the IDCS application.

The "virtual roles" mechanism used in earlier releases is no longer supported. If you are developing an application that used virtual roles, you will need to use the new UI to replicate those users and roles because the virtual roles won't be converted to the new role mapping mechanism.

September 27
Improvements in Action Chain editor

The following improvements and features were added to support for Actions:

  • The action chain editor is now displayed as a tab within the artifact tab in the Designer. This makes it easier to switch between the action chain and other artifact editors.
  • The action chain editor now includes an overview window that shows the entire diagram when in diagram view. The visible part of the diagram is highlighted. When zooming or panning the diagram, the overview window updates its highlighted area to match. Also clicking on the overview window or dragging the highlighted area pans the diagram.
September 27
Improved templates and wizards for mobile apps

The following improvements were made to the wizards and templates for mobile apps:

  • A new wizard was added for creating root pages, allowing you to select the nav style and page template. When creating a new root page, you can choose to create new flows or select existing flows for the new root page. If the nav-style of the new root page is None, you can choose to create a flow or page, and choose page templates.
  • The wizard for creating apps now allows you to select from multiple nav styles (Horizontal, Vertical and None), page templates for individual flows can be selected, and the UI was improved for Nav styles that need multiple items.
  • The application no longer has a single scrollbar enabled at the root of the application. Instead, the scrollbar is within the content of the template.
  • The tab bar at the top of an application can be locked in place, and the content in a tab can now be scrolled. This is implemented by default in new mobile applications. Existing applications can add it by simply slotting the tab bar to the "navigationBarTop" slot and moving it directly into the "oj-ext-mobile-page-template" parent node.
  • Scrolling now supports momentum scrolling for a more native feel on iOS.
  • Safe margins for iPhone X (R, S, SMAX) are correct in portrait and landscape modes.
  • New pages created with the "Summary with Content" template now use content scrolling, and the summary is locked in place.
  • Two new template pages can now be created with the wizards: Form and List. Sample code is provided as starting points for the ListView and Form layouts commonly used in mobile applications.
September 27
Improved templates and wizards for web apps

The following improvements were made to the wizards and templates for web apps:

  • The wizard for creating web apps now supports two navigation styles: None and Tabbed.
  • The tabbed web application template is responsive, providing a shell that displays the navigation drawer in smaller screen sizes (like phones), and a tabbed display in desktop/tablet form factors.
  • The wizard for creating root pages allows you to select existing flows or create a new flow. When nav-style None is selected you can choose if you want to create a flow.
September 27
Added PWA loading spinner

The starter mobile application template now adds a spinner to the index.html. This spinner is taken down once the application is initialized and content is displayed.

September 27
Extra Headers for Basic Auth in Mobile apps

It is now possible to specify extra HTTP headers when using Basic Auth authentication in Mobile apps, enabling integration with Oracle Mobile Hub (OMH).

September 27
Improvements to the Events editor

The following improvements were made to the Events editor:

  • The event listeners UI has been updated to show more information about where events are fired and which components are firing them.
  • Events and their payloads can now be defined in the Events editor and fired using the Fire Custom Event action. This allows the runtime to propagate events to their desired listeners and to help you configure when the events are fired.
September 27
Improvements to the Page Designer

The following improvements and features were added to the Page Designer:

  • The Component Palette, Page Structure and Property Inspector panels are now visible in Code view. Switching between Design and Code modes only swaps the canvas and code editor. Component selection and changes are now synced across all panels and views.
  • You can now drag and drop components from the Components Palette directly into the Code view and reposition them in Code view using the Page Structure view.
  • Cut/Copy/Paste is now supported for selected components in the Page Structure view and Design mode. The actions can be invoked using standard shortcuts (ctrl+x, ctrl+c and ctrl+v, CMD key on macOS), and are also available in the component's popup menu. When a component is pasted into a page it is automatically assigned a unique ID. When a component is pasted on a different page, all property values that are expressions are removed.
  • A "Temporary Override" option has been added to some properties in the Property Inspector which allows you to set a temporary value for the property. The value is only applied during design time. For boolean-type properties, you can select a Temporary Override option of Off, True or False in the component's popup menu. In the Page Structure view, an orange badge is used to indicate when a Temporary Override is currently used on a component. The Temporary Override settings are only valid until the page designer is reloaded or the page's code is edited in Code mode. The Temporary Override option is available for the following component properties:

    • "test" property of oj-bind-if component. Using this enables the contents wrapped by the IF to be displayed in the page designer. The option allows you to override a default value of false that would otherwise be the result of the IF condition.
    • "expanded" property of oj-collapsible
    • "expanded" property of oj-ext-mobile-navigation-bar-drawer
    • "initial-visibility" property of oj-dialog
  • The oj-dialog component is now supported in the Design mode and has been added to the Components Palette. When designing an app, you can choose to keep dialog components open in the canvas while designing its contents by using the Temporary Override option in the Property Inspector or the component's popup menu to set the initial-visibility property. In Live mode you can invoke the action that opens the dialog, for example, if the dialog opens when a button is clicked.

    When the dialog is open in the canvas, only the components inside the dialog on the canvas are selectable and drop indication feedback is enabled for them.

  • Unused component import is removed from the page model when the last instance of the component is deleted from the page.
  • Components dropped into a parent's slot are wrapped with a template element if the slot's metadata includes attribute data.
  • Non-field components dropped into a form layout container are now all accompanied by a label component to allow default column alignment with regular field components.
  • Layout helpers have been added for simple non-component HTML elements (for example, <div>). This enables children (deleting, moving, adding child components) inside the element to be easily manipulated.
September 27
Improvements to the Property Inspector in Page Designer

The following improvements and features were added to the Property Inspector in the Page Designer:

  • Docs hyperlink has been added to the help popups on properties and slots of the component in its Property Inspector. The link leads to the particular JSdoc page in the component's documentation based on its metadata.
  • Menu components in Slots sections now offer Divider and Menu Multi-Select subcomponents in the Add Action drop-down.
  • In the Table Columns customizer, the drop-down list of identified column fields has been renamed from "Fields" to "Simple Field Columns". The list includes only the fields which are not represented by separate components in the column templates' code.
  • Basic support for a mobile application's Drawer component (available in New Mobile Application wizard as Vertical navigation style option) was added to the Property Inspector. In the Page Structure view, you can now see a "Mobile Navigation Bar - Drawer" component after opening the Page Designer for an application's root page (root pages / app).

    In the Property Inspector, the Drawer component contains:

    • A Navigation Items section which helps you customize the navigation items in the drawer, similar to customizing items of the Bottom Bar component
    • An Expanded property with a Temporary Override section that allows you to force a value to be True in the design time. This enables you to make the Drawer visible on the canvas so that you can work with it visually.
  • The Styling section in the General tab now displays classes for components that have a predefined set of styling classes listed in its styleclasses metadata.
September 27
Improvements to Quick Starts

When using a Quick Start, the following improvements were made to help locate data in the Endpoint Selector:

  • improvements to how the focus is shown for single items
  • improved tooltip for switch between simplified and advanced mode
  • the search keyword is now highlighted
September 27
Enhancements to Business Object editor

The following improvements and features were added to the Business Objects editor:

  • In the Diagrams view, when no objects are selected in the diagram you can now select which business objects are displayed in the Property Inspector. When a business object is selected, you can use the Property Inspector to edit the business object, its fields and relationships.
  • The business object directory structure has changed. All json files for the artifacts (business objects and diagrams) are now under the businessObjects directory. Business object metadata defined in Application Settings is now stored in businessObjects.json instead of settings/security.json.
September 27
Enhanced business object security definitions

Enhancements were made to the Data Security Rules section that you use to define business object security. Support for Groovy expressions has been improved. You can now use a Groovy expression to identify the current user instead of a JavaScript expression, and you can use any expression that can be evaluated to a literal constant when the business object REST API is called. When creating conditions, you can now also choose fields from a related object in the Field drop-down list.

September 27
Added support for constant variables Constant variables are now supported when you add a new variable. A constant can have a value specified via it's default value or when provided as an input parameter, but it cannot be changed at runtime. September 27
Improved UI for Service Catalog

Catalog settings can now be defined both for the tenant and at the application level. When editing the catalog settings at the application level, you can view the current tenant settings and choose to override them.

September 27
Improvements to connecting to Fusion Applications catalogs in the Tenant Settings

In the Tenant Settings editor, specifying the base URL for a Fusion Applications catalog for the tenant has been simplified:

  • You now only need to supply a valid Fusion Applications base URL. The path to the interface catalog will now be resolved automatically.
  • When you enter the FA base URL, the connection is tested to ensure that the endpoint is accessible without authentication and is CORS compliant. The catalog will not be created if these criteria are not met. .

The alternative to setting the catalog at the tenant level is to set it at the visual application level where more options are available.

September 27
Improvements to the External Build process

The following improvements were made to support using the external build tools:

  • Support was added for creating custom requirejs module bundles for visual applications. You can use this to help improve application performance by creating multiple bundles and customizing the content of each bundle. You can then control which bundles are loaded initially and which are loaded when they are needed.
  • The external build can be configured to produce bundles that conform to the pure EcmaScript 5 standard supported by older browsers and also produce an ES6 set of bundles. This allows you to write more modern code (EcmaScript 6) in your application and also have an application that can run on IE11 and other old browsers.
September 27
EcmaScript 2018 support

The code editor for .js files now has editing and audit support for EcmaScript 2018 (ES2018) in mobile apps and when using the external build process. ES2018 is not supported in web apps, which continue to use ES5.

September 27
JET Audit tool added

The JET audit tool has been integrated into the design time. The tool currently works on all HTML files, and can help produce pages that conform to the JET guidelines.

September 27
Added settings for JET and runtime versions

It is now possible to specify a Visual Builder runtime and JET version in web and mobile application settings.

September 27
Added support for IDCS multi-stripe

Visual Builder can now be used in IDCS accounts which use multiple stripes.

September 27
Improved Who am I dialog The UI of the Who am I dialog is streamlined to be more intuitive, and to disallow some combinations of selected items. September 27

August 2019

New Features
Integration Features
Feature Description Published
FTP Adapter - FTP server operating system selection

You can select either Unix or Windows on the Connections page as the operating system of the host on which the FTP server is installed.

See Configure Connection Properties in Using the FTP Adapter with Oracle Integration.

August 22
Orchestrated integrations - Wait action enhancement

In addition to hours and minutes, you can delay the execution of an integration for seconds with a wait action.

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

August 22
Oracle Database Cloud Service Adapter - Instance connection using SSL

Support is provided for connecting to the Oracle Database Cloud Service instance with SSL, thus avoiding the need to install and configure the connectivity agent. You select and configure Oracle Wallet as the security policy on the Connections page.

See Prerequisites for Creating a Connection in Using the Oracle Database Cloud Service Adapter with Oracle Integration.

August 22
Oracle Engagement Cloud Adapter - New name Oracle Sales Cloud Adapter is renamed to Oracle Engagement Cloud Adapter. August 22
Process Features
Feature Description Published

REST API updates

We've made improvements to Process Instance APIs in the Oracle Integration REST APIs.

See the What’s New topic under Get Started in Oracle Integration REST API.

August 22

Resolved Issues
Integration Resolved Issues
Issue Resolution Publication Date
Activity stream The activity stream for notification and wait actions has been improved. August 22
Oracle Engagement Cloud Adapter When using the Oracle Engagement Cloud Adapter (formerly the Oracle Sales Cloud Adapter), the Oracle Engagement Cloud client (through SOA Composer) can now call an Oracle Integration service without an endpoint security policy error. August 22
Oracle Engagement Cloud Adapter The Oracle Engagement Cloud Adapter is successfully listed/filtered in the Create Connection - Select Adapter dialog.  
Oracle Cloud Customer Connect forum Messages and cross-linking to the Oracle Cloud Customer Connect forum during integration activation failures have been improved. August 22
Oracle Autonomous Transaction Processing Adapter The Oracle Autonomous Transaction Processing Adapter now accepts case insensitive connection names. August 22
Oracle Database Adapter When using the Oracle Database Adapter, you no longer receive an error when you click SQL Edit and add a parameter to query by clicking Add New. August 22
Integration activation New integration activation attempts are now handled successfully when the server is down. August 22
List of errors page The created/last updated date is shown in the list of errors page. August 22
Recoverable errors You can search, view, or filter by recoverable errors. August 22
Expression Builder An Expression Builder expression containing a function call with an incorrect number of parameters now shows as invalid. August 22
Lookup cloning Cloning a lookup through the REST API when the lookup does not exist no longer results in an HTTP 500 error. August 22
Mapper performance Performance when closing the mapper and returning to the canvas has been improved. August 22
Integration activation You can now activate an integration when a stage read action is used alongside an application adapter. August 22
Oracle Integration Oracle Integration REST API performance for listing lookups and connections has been improved. August 22
Redirect URLs Redirect URLs are successfully resolving on Oracle Integration instances. August 22
Host key security The host key security between Oracle Integration and Oracle Managed File Transfer no longer fails with a CASDK-0004 Host Key Verification error. August 22
ServiceNow Adapter All plugins that are activated in a ServiceNow instance are enabled. You can send attachments using the ServiceNow Adapter. The labels have also been modified for describing operations. August 22
Process Resolved Issues
Issue Resolution Published

Space sharing error

When editing a space, users couldn't share a space on the space details page.

August 22

Application unlock

Improved the message shown when users unlock a process application on the design-time Administration page.

August 22

July 2019

New Features
Integration Features
Feature Description Published
Throw New Fault action - New orchestrated integration action You can create and throw your own faults in an integration with a throw new fault action. During configuration of this action, you define the condition under which to throw the fault and the point in the integration at which to throw the fault. You can add this action at the end of a block (for example, a for-each action, switch action, and so on). Nothing can be dropped after this action in the block.

See Throw Faults with a Throw New Fault Action in Using Integrations in Oracle Integration.

July 26
Scheduled integrations - Override scheduled parameters You can override schedule parameter values set at design-time when submitting an ad-hoc schedule request or starting a schedule in an activated integration. This feature enables you to provide parameter values while invoking an integration without deactivating it.

See Override Schedule Parameter Values in Using Integrations in Oracle Integration.

July 26
Oracle Field Service Adapter - OAuth security policy support

Support is provided for configuring the Oracle Field Service Adapter to use the OAuth security policy. Recommendations are also provided for when to use Basic Authentication or OAuth (Client Credentials) as your security policy.

See Configure Connection Security and Migrate to Oracle Field Service Cloud Version 19c in Using the Oracle Field Service Adapter with Oracle Integration.

July 19
Salesforce Adapter - OAuth Three-Legged security policy support Support is provided for selecting the Salesforce OAuth Three-Legged security policy when configuring the adapter on the Connections page.

See Use the Salesforce OAuth Three-Legged Security Policy in Using the Salesforce Adapter with Oracle Integration.

July 19
Stage file action - File reference and schema support You can specify a file reference to process when you select to read the entire file, read a file in segments, or unzip a file. Support is also provided for ZIP/JSON/XML-based schemas.

See Process Files in Scheduled Integrations with a Stage File Action in Using Integrations in Oracle Integration.

July 19
Business identifiers - Primary and secondary values search You can search for values across both primary and secondary business identifier values on the Tracking page.

See Track Business Identifiers in Integrations During Runtime in Using Integrations in Oracle Integration.

July 19
Scheduled integrations - Initiating an instance You can select how to initiate an instance of an activated integration when prompted.
  • Ad hoc request: The instance is executed independently of the scheduled run for the integration (if any).
  • As part of schedule: The instance runs in sequence with the scheduled run and shares schedule parameters (if any)

See Create a Schedule in Using Integrations in Oracle Integration.

July 19

June 2019

New Features

Common Features

Feature Description
New Oracle Integration user roles Two new user roles are available with instances provisioned after May 8th:
  • ServiceInvoker:

    This role enables you to execute an integration from outside the Oracle Integration user interface. The user cannot log in to the Oracle Integration user interface with this role.

  • ServiceViewer:

    This role enables you to navigate to all Integrations resource pages (for example, integrations, connections, lookups, libraries, and so on) and view details. The user cannot edit any resources or navigate to the administrative setting pages.

Quiesced mode

We improved error messaging for administrators when Oracle Integration is in a quiesced mode.

Integration Features

Feature Description
SurveyMonkey Adapter - API version support The SurveyMonkey Adapter now supports API version 3.
New adapter - Oracle Autonomous Transaction Processing Adapter The Oracle Autonomous Transaction Processing Adapter enables you to integrate the Oracle Autonomous Transaction Processing database with Oracle Integration through use of direct connectivity. Use the Oracle Autonomous Transaction Processing Adapter to execute SQL queries or stored procedures in the Oracle database.

See Oracle Autonomous Transaction Processing Adapter Capabilities in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration.

Oracle Utilities Adapter - Secure WSDL, REST, and OAuth 2.0 support. The Oracle Utilities Adapter provides support for the following:
  • Secure WSDL support
  • An enhanced REST interfaces user interface
  • REST catalog parsing enhancements if the adapter is running with the connectivity agent

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

FTP Adapter - Signing support Supports signing verification and validation during the download of PGP-encrypted files from an sFTP server. Signing provides a method for authenticating the sender of the file.

See FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration.

Scheduled integrations canvas - Defining the schedule You can click the Schedule icon at the top of a scheduled integration to display an option for invoking the Edit Schedule page to define the schedule details.

See Create a Scheduled Integration in Using Integrations in Oracle Integration.

Unlocking an integration You can unlock an integration that you own. For example, when an integration you created is in edit mode and the browser crashes, the integration becomes locked. You can unlock this integration and resume re-editing.

See Unlock an Integration in Using Integrations in Oracle Integration.

SOAP Adapter- OAuth security policy support You can configure inbound SOAP endpoints with the OAuth 2.0 security policy.

See SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration.

Process Features

Feature Description

Canvas changes

We've introduced unified and better color coded icons in our structured process modeling canvas. You'll see new toolbars and icons in the elements palette.

See New Process Icons for a side-by-side comparison of new and old icons.

  • Icons: Many items stay the same color: Human tasks are still green, Decisions are yellow, and System and Integrations are still blue. But we've introduced new colors:
    • Events, such as Form Start and End, are purple.

    • Gateways are orange.

    • Note icons (Other category) are pink.

  • Toolbar: All icon functionality stays the same, but they've been repositioned and updated.

Common expression builder in Decision modeling editor

We’ve enhanced the design-time interface of decision models for consistency and ease of use. Entering expressions in decision tables, decision input data, or type definition is now a uniform, intuitive experience. Additionally, new modes are now supported in decision table cells that make populating tables quick and simple.

See Define Decision Input and Type and Define Decision Table Input in Using Processes in Oracle Integration.

Conditional expressions in data association

You can now control data execution in runtime for both structured and dynamic processes by applying conditions while mapping data from the Data Association editor. In such cases, data executes in runtime only when the defined condition is met. See Define Conditions for Data Associations Using Processes in Oracle Integration.

Smart sentries in dynamic processes

Define smart sentries as conditions that decide if an activity, stage, or process gets activated or terminated.

  • Add a decision to a dynamic process: Apply an activated decision to a stage or activity’s condition so that it activates or terminates the stage or activity.

    See Smart Sentries in Dynamic Processes in Using Processes in Oracle Integration.

  • Add a REST connector to activate or terminate a stage, activity, or process in a dynamic process.

    See Configure a REST Sentry in a Dynamic Process in Using Processes in Oracle Integration.

Promote process application samples to the gallery for easy sharing

The QuickStart gallery has expanded to include samples in addition to QuickStart Apps. From any regular process application, developers can promote it to the gallery. Other users can then browse the gallery, select a sample, and create their own copy of the sample application.

See Promote Applications as Samples to the Gallery in Using Processes in Oracle Integration.

QuickStart Apps enhancements

We've made it easier for users to create process applications from QuickStart Apps and added flexibility for developers:

  • When users create by starting from the gallery, items now display a QUICKSTART or SAMPLE label to easily distinguish them.

  • We made usability improvements to QuickStart Apps. Developers can better order artifacts of different types (such as approvals, submits, roles, integrations, and others) and users can more easily configure apps.

See Create Your First Application (a Quick Start) in Using Processes in Oracle Integration.

Robotic process automation adapter for Automation Anywhere

Use the new Automation Anywhere Integrations adapter to automate repetitive human tasks and integrate with applications that do not offer APIs or for which there is no adapter. See Integrate with Robotic Process Automation Tools in Using Processes in Oracle Integration and Understand the Automation Anywhere Adapter in Using the Automation Anywhere Adapter with Oracle Integration.

REST API updates

We've made additions and added examples to the Process/Process Instance APIs in the Oracle Integration REST APIs. For example:

  • Retrieve Activities Flow for a Process Instance: Use the new activityType query parameter to the to return only a subset of activities that match the specified type.

  • Update the Process State: Use the new suspend and resume actions to alter the flow of a process by passing activityChanges in the JSON body.

See the What’s New topic under Get Started in Oracle Integration REST API.

Application activation

We improved the process application activation dialog so that it now shows your current retention policy settings.

Dynamic process enhancements

We've added support for the following special types of data association to dynamic processes (already supported in structured processes):

  • Transformations: Use them for input and output data types that don’t match. They're particularly useful for matching slightly differing data attributes, such as address or employee data. See Work with Transformations in Using Processes in Oracle Integration.
  • Append to arrays: Use the Append action in the data association editor to add elements to a target array. See Append to Array in Using Processes in Oracle Integration.
  • Array filter: Now available in dynamic processes. In the Data Association editor of a structured process or transformation, you can selectively filter elements from a source array object and assign them to a target array. See Filter Array Data Objects in Using Processes in Oracle Integration.

Forms enhancements

Updates include:

  • You can now access an object from a Select control while displaying one value but using other non-visible object attributes in select control events. For example, you might show the label of an object, but use the ID internally to populate other form controls. See Configure Drop-down Select Fields in Using Processes in Oracle Integration.

  • You can now easily reorder actions in web form events.

  • You can now reorder table columns in web forms.

Data retention

We improved the process application activation dialog so that it now shows your current retention policy settings.

New Process Icons

Category Icon New Old

Human

Submit

New Submit icon Old Submit icon

Human

Approve

New Approve icon Old Approve icon

System

Abstract

New Abstract icon Old Abstract icon

System

Data Mapper

New Data Mapper icon Old Data Mapper icon

System

Service

New Service icon Old Service icon

System

Call

New Call icon Old Call icon

System

Send

New Send icon Old Send icon

System

Receive

New Receive icon Old Receive icon

System

Notify

New Notify icon Old Notify icon

System

Dynamic Process

New Dynamic Process icon Old Dynamic Processe icon

System

Decision

New Decision icon Old Decision icon

System

Sub-Process

New Subprocess icon Old Subprocess icon

Events

Start

New Start icon Old Start icon

Events

Form Start

New Form Start icon Old Form Start icon

Events

Message Start

New Message Start Old Message Start icon

Events

Message Catch

New Message Catch Old Message Catch icon

Events

Timer Catch

New Timer Catch Old Timer Catch icon

Events

Error Boundary

New Error Boundary Old Error Boundary icon

Events

Message Throw

New Message Throw Old Message Throw

Events

End Event

New End Event icon Old End Event icon

Events

Message End

New Message End Old Message End icon

Events

Error End

New Error End icon Old Error End icon

Events

Terminate End

New Terminate End icon Old Terminate End icon

Gateways

Exclusive

New Exclusive icon Old Exclusive icon

Gateways

Inclusive

New Inclusive icon Old Inclusive Gateway icon

Gateways

Parallel

New Parallel icon Old Parallel Gateway icon

Gateways

Event Based

New Event Based icon Old Event Based icon

Integrations

Integration

New Integration icon Old Integration icon

Other

Note

New Note icon Old Note icon

Resolved Issues

Integration Resolved Issues

Issue Resolution
FTP Adapter - Host key security Host key security between Oracle Integration and MFTP no longer fails for the FTP Adapter with the following error: CASDK-0004 Host Key Verification.
SOAP Adapter - Usability enhancements Text for the SOAP Adapter in the user interface has been enhanced to improve usability.
REST Adapter - Usability enhancements In-context help for the multiple operations feature in the REST Adapter has been added.
REST Adapter - Use in a for loop When using the REST Adapter in a for loop, you can specify individual parameters as repeating elements.
REST Adapter - Parse special characters. The REST Adapter can parse JSON responses with special characters such as an @.
REST Adapter - Schemas with reserved words The REST Adapter now provides a design time error instead of an activation failure error when the schema provided uses a reserved namespace.
SOAP Adapter - Rejected messages Messages rejected by an inbound SOAP Adapter trigger are no longer shown in the Tracking page with an invalid flow version.
Integration activation error Integration activation no longer fails with out-of-memory errors in the logs.
Salesforce Adapter - Field types change An issue is resolved where a change in field types to sObject by Salesforce in version 46 had resulted in the query parser being unable to resolve the relationship. This had previously resulted in a NullPointer exception.
Activation failure error The java.lang.NoClassDefFoundError: weblogic/application/Module activation failure error has been fixed.
Oracle HCM Cloud Adapter - ATOM feed entries Oracle HCM Cloud Adapter processing no longer fails if entries in the ATOM feed have a title with a tab character.
Salesforce Adapter - IAR project import issue After importing the project IAR in 19.2.1, the Use Default Header checkbox was selected on the Operation page. This was unexpected and has been resolved.
Connectivity agent - install location The connectivity agent installation experience is the same regardless of whether the agent installer is run from a directory other than the agent install location.
Microsoft SQL Server Adapter - Usability enhancement Text for the Microsoft SQL Server Adapter in the user interface has been enhanced to improve usability.
FTP Adapter - Timeout period increase When using the connectivity agent with the FTP Adapter, the timeout period for runtime requests has been changed to 580 seconds.
FTP Adapter - Digital signing The FTP Adapter supports digital signing.
SOAP Adapter - Error message enhancement SOAP Adapter error messages have been enhanced to include remedial actions when the inbound connection has no security policy configured (and therefore, defaulted to Username Token policy) and if the runtime request does not have the Username Token policy.
Connectivity agent - Temp files reduction The number of temp files created by the connectivity agent has been reduced.
Connectivity agent restart Restarting an already running connectivity agent no longer causes PID file deletion.
Oracle ERP Cloud Adapter - OAuth support Support is provided for OAuth (manual OAuth client creation is required) in the Oracle ERP Cloud Adapter.
Workday Adapter - User domain policy access The Workday Adapter user is now only given domain policy access to the feature that they are using (Web Services, RAAS, or EIB) instead of to all three. When testing the connection, only access to that specific feature is validated.
Oracle Autonomous Transaction Processing Adapter - Error message enhancements More helpful and actionable error messages are provided for when the wrong password or service name is entered for the Oracle Autonomous Transaction Processing Adapter.
Oracle E-Business Suite Adapter - Open interfaces Support has been added for open interfaces to the Oracle E-Business Suite Adapter.
Ariba response message sandboxResponse element The sandboxResponse element has been added in the Ariba response message. This element is used when creating an integration to test whether Ariba is accepting the upload request or the request is already in progress.
Connectivity agent installation location A useful error is shown when the connectivity agent installer is run when pointing to a JAR file in a different folder.
SOAP Adapter - Validation improvements Validation has been improved for duplicate SOAP and HTTP headers in the SOAP Adapter.
SOAP Adapter - invalid data types Validation and testing no longer passes for a WSDL with invalid data types in the SOAP Adapter.
Connectivity agent upgrade Generated backups are deleted as a part of the connectivity agent upgrade.
Concur Adapter - Summary page issue You no longer face an issue with the Summary page when configuring the Concur Adapter in an integration.
Salesforce endpoint configuration You can now configure the Salesforce endpoint while configuring a SOQL-Query operation when any field name in the SOQL query contains " from " (surrounded by white spaces).
Requests with a no content-length header Requests with a no content-length header no longer return a 500 error instead of a 411 error in the adapter framework.
Oracle Responsys Adapter - Profile extensions The Oracle Responsys Adapter now shows profile extensions for the profile list containing space.
Oracle ERP Cloud Adapter - Connection description The description is now shown for the Oracle ERP Cloud Adapter connection.
Oracle Advanced Queuing (AQ) Adapter When used with the Oracle Advanced Queuing (AQ) Adapter, a connectivity agent error message now shows what was required to alleviate the error.
Oracle Utilities Adapter - Enhancements Open authorization support and fault handling in REST is provided in the Oracle Utilities Adapter.
SAP Adapter - Mapping issue You can refresh the SAP Adapter in an integration without losing any of the mappings in an integration.
FTP Adapter - Connections page validation Validation has been added on the Connections page of the FTP Adapter for an incorrect PGP encryption key.
Integrations page performance improvement Performance has been improved when saving integrations on the Integrations page.
Bell notification icon linking improvement When you click the bell notification icon for a failed connectivity agent in the upper right corner of the page, a dialog is displayed with a link to the Dashboard page for more details.
Valid predicates The Expression Editor correctly identifies valid predicates.
attributeFromDefault attribute Support is provided for the attributeFromDefault attribute in XML schemas.
Migration of expressions with wildcard characters The migration of expressions with wildcard characters from Oracle Integration Cloud Service to Oracle Integration is supported.
Improved error messages for integration activation failures A user friendly error message and remedial actions are provided for errors introduced when activating an integration that was imported into a service instance with missing lookup artifacts.
Reclaim space procedures improvements Reclaim space procedures (shrink and move) in Oracle Integration have been enhanced to include the dynamic process tables of Processes.
Integration invocation from global fault handlers The invocation of integrations from global fault handlers during a resubmit is now supported.
Load performance improvements The load performance for the Home, Monitoring, and Design-time Metrics pages has been improved.
Substitution groups Schemas that have substitution groups are supported.
Help link updates The Help page links for the Agents page, Connections page, Create New Connection page, and Settings page have been updated.
Scheduled orchestration job cancellation A scheduled orchestration job is now canceled when the underlying database experienced a service disruption.
Runs page improvement The wrong information is no longer displayed on the Runs page.
Tracking page improvements Consistent terminology in reporting the status of integration executions in the Tracking pages is provided.
Tracking variable deletion If the trigger connection for a Basic Routing integration changes to point to a different resource, the tracking variable is deleted.
Stage file action ZIP file The stage file action no longer creates a corrupted ZIP file if the input directory was the parent of the output.
Connections page API key field The field length of the API key field in the Connections page has been increased to 2048 characters.
DocuSign Adapter - Authorize code flow support Supports the authorize code flow in the DocuSign connection.
REST Adapter - Trigger connection A trigger connection using an XML schema no longer fails with a CASDK-0005 error.
Oracle Advanced Queuing (AQ) Adapter - Password special character support Activation no longer fails when the password had special characters.
Microsoft Email Adapter - Attachment element in the mapper An attachment element now appears in the mapper.
Oracle E-Business Suite Adapter - Test connection issue A test connection no longer fails intermittently with an Unexpected Error or Internal Server Error (NullpointerException).
SAP Adapter - New interface Implemented a new interface to CloudSapAdapter (class) and added logic in handleActivation (method) to refresh the JCA after any connection change.
Oracle Database Adapter - Error message enhancement The error message has been enhanced for when the payload size exceeds the threshold.
Oracle Database Adapter - Connectivity agent credentials New credentials with the connectivity agent are now reflected at design time.
Oracle Database Cloud Service Adapter - Special character validation Enhanced special character validation at design time is provided.
SOAP Adapter - Timestamp issue A timestamp is now received in the response from an invoke, although it was sent as a part of the request.
Salesforce Adapter - SOQL query operation The SOQL query operation can now build a parentRelationshipField based on a CAM-contained relationships map that is built through a describeSObject API call, instead of relying on a CAM-contained CloudDataObjectNode.
ServiceNow Adapter - Field Service Management enhancements The Field Service Management plug-in in the adapter and the dependent plug-ins of the Field Service Management plug-in have been enabled.
SAP Ariba Adapter - CombinedDataPull enhancements Valid entries for the value of "Data Import Task Name" and "File Name" for the "CombinedDataPull" sheet are created.
Oracle ERP Cloud Adapter - SAML assertion signature digest verification Multiple error codes are now displayed when a SAML assertion signature digest verification failed with callbacks.
Workday Adapter - Integration regeneration and activation The adapter can now select the version from the runtime WSDL (the version on which the Workday Adapter endpoint was originally configured) after regeneration and activation of the integration. For creating and editing an integration, the Workday Adapter can now pick the latest version from the Connections page.
Oracle ERP Cloud Adapter - Create and Update Contact The adapter no longer fails when Create and Update Contact are used in the same integration.
Function callouts Function callouts have been renamed to Javascript in the user interface.
Delete Schedule REST API The Delete Schedule REST API no longer throws a NullPointerException when invoked on active schedules.
Trigger metadata connection refresh The second tracking field now appears after refreshing the trigger metadata connection.
Scheduled integration runs Fixed an issue where scheduled integration runs (in an error state) were shown even when run with an unauthorized user account.
Mapper error reporting The mapper now reports an error on a specific invalid mapping.
Assign action help text The help text for the assign action has been improved.
Connection security policy A null pointer exception is handled in case of an invalid or null security policy for a connection.
Trigger menu of orchestrated integration Adapters that do not support trigger functionality now longer appear in the trigger menu of an orchestrated integration.
Retrieve Monitoring Metrics REST API The Retrieve Monitoring Metrics REST API is no longer missing the LastUpdated field.
Mapping Recommendations Settings page The help text on the Mapping Recommendations Settings page has been improved.
Notification email copyright date The copyright date in the footer note of the notification email sent from Oracle Integration has been fixed.
Batch retry If a batch processing error is received after a server restart (recovery mode), the job can use that information to retry the batch.
XSL maps Issues related to the usage of unsupported functions in the XSL map are reported and successfully handled.
Schema elements in for-each groups Schema elements in for-each groups that have substitution groups are successfully handled.
XPath expressions Quotes in XPath expressions are successfully handled.

Process Resolved Issues

Issue Resolution

Nested forms

Resolved issue when attaching form images as email notifications when the forms contained other nested forms.

Link fix

Fixed the Learn More link on the Oracle Integration Welcome page.

List scroll

List scroll issue prevented all available process applications from being shown.

Clone applications

Users with Space viewer only permissions could not clone process applications.

My Apps

An internal memory cache synchronization issue prevented the My Apps Workspace page from opening.

Append in dynamic process arrays

Using the append operation in dynamic process array data associations resulted in an error.

Null keywords incorrectly included in email notifications

Email notifications included "null" keywords even when null checks were added to the email notification template via Mustache syntax.

Attachments panel couldn't be closed

The Attachments panel on the Process Details page couldn't be closed after downloading a file. This issue occurred in Workspace, not on the My Tasks page from the Oracle Integration Home page.

Process attachment API issue

The process attachment API incorrectly replaced a space with a "+" character in the attachment file name was resolved.

500 error returned with invalid taskID for payload endpoint

A 500 error was returned when an invalid taskId was used accessing the REST API endpoint /tasks/{taskId}/payload.

Warning missing when overwriting decision model after changes

The warning dialog was not shown when overwriting an existing decision model and its input and output parameter changes.

Attachments couldn't be added when documents not configured

Users couldn't add attachments to tasks on the Workspace Task Details page when Content and Experience wasn't configured.

Loading time for large processes

We've improved process loading and renderization for very large processes rendered incrementally. The loading time is affected by the browser being used. The loading issue was more common with Internet Explorer version 11.

Issue loading integrations

Process could no longer load integrations after a used integration (previously discovered and used) was removed from the active integrations list.

My Apps returned blank page

The My Apps page was not loading correctly and showing a blank page due to concurrent access to a time-consuming operation.

Decision connector editable when read only

A DMN connector was editable when the model was read-only.

Presentation not cloned

A form presentation containing many controls couldn't be cloned.

Form print issue in Firefox

Printing a web form with multiple tabs in Firefox omitted the first tab.

Human task action issue

Human task actions containing non-ASCII characters caused the action processing to break the page. This happened more frequently when showing actions with accents or similar characters in non-English languages.

Audit API response fix

Fixed values provided in the Audit API response where inforRequestedFrom and infoSubmittedTo parameters were returning userid instead of the display name.

May 2019

New Features

Common Features

Feature Description

Improved Home page loading time

Through dynamic loading, we've improved the speed and performance of the Oracle Integration Home page and its sections.

Oracle Integration Home page - Common About page A common About page is now accessible from the Oracle Integration Home page.

Integration Features

Feature Description
Recovery job ID search on Tracking page

Searching on the Tracking Instances page has been enhanced to search for recovery job IDs that run to process failed instances.

See Manage Business Identifiers for Tracking Fields in Messages in Using Integrations in Oracle Integration.

JMS Adapter - Header support JMS headers in both the trigger and invoke directions are supported. You can set message headers to dequeue messages from queues and set message headers to enqueue messages into queues.

See Oracle WebLogic JMS Adapter Capabilities in Using the Oracle WebLogic JMS Adapter with Oracle Integration

Process Features

Feature Description

Query parameter added to REST endpoint

The new activityType parameter enables you to return only a subset of activities that match the specified type.

Resolved Issues

Integration Resolved Issues

Issue Resolution
Connectivity agent - Restart Improved the agent restart time after an agent is upgraded.
Connectivity agent - Group updates Added support to update the agent group through the Oracle Integration REST API.
Adapter SDK An issue in the adapter SDK for a protected/secured WSDL (using the SOAP proxy) with an authorization header is resolved.
SOAP Adapter - Callback invoke A callback invoke fails if configured with the URL instead of an uploaded WSDL.
FTP Adapter - Error message Improved the error message for when a user enters the wrong host key.
FTP Adapter - Design-time Improved the design-time experience for multi-level authentication.
JMS Adapter - Inbound header element A JMS inbound header element (for example, Message Id) being mapped to a JMS outbound header element (for example, Correlation Id) no longer throws an exception upon activation.
Adobe eSign Adapter - Regional subdomains Adobe eSign Adapter: Fixed support for regional subdomains (for example, na1, na2, in, and em2 in OAuth).
Oracle ERP Cloud Adapter - Error message improvement Oracle ERP Cloud Adapter: Improved the user error message when an FBDI upload integration shows errors for being unable to move a file at the target location.
REST Adapter - Error message improvement REST Adapter: Improved the user error message when an ArrayIndexOutOfBound occurs during JSON translation.
File Adapter - Pipe-separated file content Fixed an issue when reading pipe-separated file content while skipping certain lines.
Adapter SDK custom validation Enhanced the adapter SDK to support custom validation of connection properties.
Integration runtime failure Integrations no longer fail at runtime when the dynamic invoke feature is not enabled. No headers are available in an incoming SOAP payload and there is at least one mapping done.
Application WSDL validation Enhanced adapters to intelligently validate application WSDLs where the target namespaces do not match the parent schema import. 'Import' is used instead of 'Include' or cross-referenced schemas are present without import namespaces in the definition.
Operation invocation on Fusion Applications Invoking operations on custom objects for Fusion Applications adapters no longer fail.
Error message improvement Improved error message with an action recommendation when an adapter 'Test Connection' fails due to a self-signed certificate not having the subject alternate name.
Collapsed scope actions Users can reposition collapsed scopes within orchestration integration flows.
Activation errors Activation errors caused by XML schema definitions containing references to it are successfully handled (recursive schema imports or includes).

Process Resolved Issues

Issue Resolution

Import issue

Deleting a process application and then re-importing it under the same name resulted in the old deleted process application rather than the new version.

Process application open issue

An internal server error was fixed that prevented process applications from opening in Process design time.

Identities REST endpoint issue

An HTTP 500 error was returned when invoking the bpm/api/4.0/identities REST endpoint when Oracle Identity Cloud Service (IDCS) contained a very large number of users. A similar situation occurred with the Identities web form control and other select controls in Process forms when Oracle Integration was pulling a full list of users, and was resolved.

Correlations issue

Users were prevented from opening the FX correlations mapping editor and configuring correlations in structured (BPMN) processes.

Web form preview mode issue

Web form elements visible when editing were not visible in Preview mode.

Title update issue

The process instance and task titles were not properly updated when configured inside a parallel gateway. After the fix, the main thread title propagates to all child threads inside the parallel gateway flow.

April 2019

New Integration Features
Feature Description
Orchestrated integrations - nested scopes

You can add nested (child) scope actions to a basic scope action. This provides a more sophisticated way of organizing or separating actions into a subsection of the integration.

See Manage a Group of Actions and Fault Handlers with a Scope Action of Using Integrations in Oracle Integration.

Oracle E-Business Suite Adapter - Support for Java APIs as invokes (targets) in integrations

The Oracle E-Business Suite Adapter supports Java-based APIs including Java Bean Services and Application Module Services subtypes from Oracle Integration when adding the Oracle E-Business Suite Adapter as invoke (target) connections.

In addition to PL/SQL, concurrent program, open interface REST services, Java APIs are now available as REST services for invocation from Oracle Integration.

See Oracle E-Business Suite Adapter Capabilities and Invoke Oracle E-Business Suite Java APIs from Oracle Integration in Using the Oracle E-Business Suite Adapter with Oracle Integration.

Oracle Advanced Queuing (AQ) Adapter - New video

See how the Oracle Advanced Queuing (AQ) Adapter supports the trigger connection using the object queue data type in Oracle Integration.

See Use the Oracle Advanced Queuing (AQ) Adapter for Object Queue Type.

Canceling long running integration instances

You can cancel an integration instance that is not completing as expected.

See Cancel a Running Integration Instance in Using Integrations in Oracle Integration.

Unlocking scheduled integrations

When a schedule is in edit mode and the browser crashes, the schedule becomes locked, which prevents it from being edited. You can unlock an integration schedule to resume editing.

See Unlock an Integration Schedule in Using Integrations in Oracle Integration.

Oracle NetSuite Adapter - Token-based authentication

Token-based authentication allows you to generate secure, revocable, and nonexpiring tokens for integration clients to use when connecting to Oracle NetSuite. The end user credentials are never exposed and the password does not expire.

See Oracle NetSuite Adapter Capabilities in Using the Oracle NetSuite Adapter with Oracle Integration.

Oracle NetSuite Adapter - Custom records

You can perform CRUD operations on custom records in an integration. Custom records are dynamic and customizable building blocks that enable you to create custom fields, lists, and special links with other NetSuite records and transactions.

See Oracle NetSuite Adapter Capabilities in Using the Oracle NetSuite Adapter with Oracle Integration.

REST Adapter - Amazon Web Services (AWS) Signature Version 4 support The REST Adapter can invoke external REST endpoints supporting the Amazon Web Services (AWS) Signature Version 4 authentication type.

See Configure the REST Adapter to Consume an Amazon Web Services (AWS) REST API in Using the REST Adapter with Oracle Integration.

New Process Features
Feature Description

Clone processes

As a time saver, you can now clone processes within a process application. On the Processes page in design time, click the new clone icon for a structured or dynamic process, and specify a new name. Cloning copies all design-time metadata for the process. Forms and integrations used in the process are linked to but not cloned, and data associations are retained.

See Clone a Structured Process and Clone a Dynamic Process in Using Processes in Oracle Integration.

Forms divider

Use the new divider control to separate your forms into sections or categories.

See Configure Divider Controls in Using Processes in Oracle Integration.

Dynamic process service task errors

When a service task fails to execute in runtime, an icon now appears for the service task under Activities. Hover your cursor on the error to see details about the service task failure's cause.

March 2019

New Integration Features
Feature Description

Migrate to Oracle Cloud Infrastructure

Ready to move your integrations to our most powerful infrastructure platform?

Connectivity agent high availability

You can use the connectivity agent in high availability environments. You install the connectivity agent twice on different hosts. There are no differences in agent installation. You specify the same agent group identifier during both installations.

See Use the Agent in High Availability Environments of Using Integrations in Oracle Integration.

Oracle HCM Cloud Adapter - Support future-dated events for Atom feeds

The Oracle HCM Cloud Adapter now supports the new approach to future-dated entries in Oracle HCM Cloud and also enables you to choose how you want to handle future-dated entries when consuming ATOM feeds from Oracle HCM Cloud.

See Oracle HCM Cloud Adapter Capabilities of Using the Oracle HCM Cloud Adapter with Oracle Integration.

Oracle Advanced Queuing (AQ) Adapter - New video

The Oracle Advanced Queuing (AQ) Adapter supports the trigger connection using the raw queue data type in Oracle Integration.

See Use the Oracle Advanced Queuing Adapter for Business Event System.

New Process Features
Feature Description

Migrate to Oracle Cloud Infrastructure

Ready to move your processes to our most powerful infrastructure platform?

Oracle Process Mobile 6.1 available

The Oracle Process Mobile app has been certified and released for both iOS and Android. Users can download it from the Apple Store and Google Play. The app works for both Oracle Process Cloud Service and Oracle Integration flows (both autonomous and classic).

Follow these tips:

  • Uninstall any previous versions of the app before installing the new version.
  • Install version 6.1. Avoid installing an older version with the same name but an older version number.

New videos

New to Process and want to learn more? See About Process in Oracle Integration.

See how you can invoke processes from integrations:

Array manipulations in web forms

You can use the new array manipulation actions to perform various operations on arrays (such as set, insert, append, clean, and delete) when an event occurs.

See Work with Presentations in Using Processes in Oracle Integration.

New Visual Builder Features
Feature Description

Support for Progressive Web Application

You can now enable the mobile applications that you create in Visual Builder as Progressive Web Apps. Among other benefits, this allows you to distribute your application through a URL for users to access.  

Take Photo action

The Take Photo action has been enhanced so that, in addition to mobile applications, you can use it in web and Progressive Web Apps that you create in Visual Builder. The runtime behavior depends on the type of application that you use the action in.

Open URL action replaces Navigate to External action

A new action, Open URL, replaces the deprecated Navigate to External action. Using the Open URL action, you can choose where to open the URL:

  • From a web application, in a new or existing browser tab
  • From a mobile application, in the native browser, such as Safari on iOS, in app browser, or the current web view
New Navigation Drawer template for mobile apps

For mobile applications, Visual Builder now provides a new navigation option that you can implement when you select the Vertical navigation style when creating a new mobile application.

Improvements to staging and publishing using DevCS

The workflow for staging and publishing using the Developer Cloud Service pipeline has been improved.

Improved support for the Component Exchange

You can now use the Component Exchange component catalog to add reusable components published by Oracle to your application.

In the Component Exchange, you can now see all available versions of a component in addition to the latest one, and choose the version you want to install.

Improvements to the Page Designer

The following improvements and features were added to the Page Designer:

  • You can now select multiple components in the canvas and in the Page Structure view. On the canvas, you select multiple components by holding the Shift key while clicking on the components. In Page Structure View, you select multiple components by holding the Ctrl/Cmd key while clicking on nodes of the tree.

    When multiple components are selected, they can be moved together to a different place on the same page, and actions invoked in the popup menu are applied to all the selected items. When the Delete action is selected, all the selected components are removed. The Surround actions make the chosen option the common parent of the selected components, for example, two selected adjacent components can be surrounded with one oj-bind-if. Selecting the Parent submenu in the popup menu will show all the common parents of the selected components.

  • The Page Structure view has been redesigned and the following functions added:

    • An options dropdown menu was added
    • Tooltips on nodes now show all details, including IDs, classes and content hints even when these details are hidden in the tree
    • A new popup was added showing the slots on nodes of components which have slots
    • Special wrapping div elements used for sizing inside grid container are now displayed as Cell and Gap elements
  • The Variables drop-down in the Property Inspector now includes a Create Variable action for all scopes to allow direct creation of a new variable to bind to the property.

  • The oj-tab-bar component now preserves the selected tab while the page is refreshing in canvas.
Changes to Security settings

The following changes were made to how security settings are configured:

  • Anonymous access is now set at the level of the artifacts (web, mobile, service connections, business objects) instead of the visual application. The Allow Anonymous Access checkbox in the visual application's Settings editor has been removed.
  • A Business Objects tab has been added to the visual application's Settings editor, and the Security tab has been removed. The tab contains security settings for business objects, the URLs for the Catalog APIs and the tool for getting an access token.

Improvements to Application Wizard

The design of the New Application wizard has been updated.

Improvements to business rules editor

A new tab was added to the Editor's palette for object functions that shows the parameters of the current object function. This list of parameters updates automatically when you edit the function's parameters using the business rules Property Inspector.

Support for secure static headers for web services

You can now define secure static headers at the server level. The header value is encrypted and stored by the vb proxy, and the vb proxy will apply the secure header when a request is made by the service. Warning messages are shown if the service connection is not using the vb proxy.

Improvements to Audits

You can now select individual issues and use the menu in the Audits pane to execute all tasks related to the selected issue, including fixing the issue.

Improvements to translations

When downloading translation files, the downloaded file is now fully ARB-compliant.

Improved support for Excel Add-in

The UI for the REST console has been improved.

Changes to relationships between business objects

The way relationships between business objects are modeled in the entity.json has been modified to improve scalability. The entity.json of both business objects in a relationship now contain some details of the relationship. This enables the existence of all relationships for a given business object to be known without loading the whole data model.

The following changes were made to the UI for relationships:

  • In the Overview tab, incoming relationships (for example, 1:M) are shown as a dotted line until clicked, at which point the full details from the owning business object are loaded to enable the cardinality and required status to be determined.
  • In the Relationship Editor, the optional Accessor name fields that only appeared in Edit mode has been replaced with mandatory relationship name fields in both Edit and Create. Using the name as an accessor is optional, and you can enable and disable the option.
  • Many-to-many relationships are no longer derived from the existence of the two many-to-one relationships, but are persisted in entity.json. If a many-to-many is needed and the intersection business object already exists, this can be selected in a dropdown list in the Create Relationship dialog.
Optimized mobile template size

The Debug and the Release versions of the iOS and Android templates have been optimized to reduce their size.

February 2019

New Integration Features
Feature Description
Oracle Advanced Queuing (AQ) Adapter - New video

See how the Oracle Advanced Queuing (AQ) Adapter supports both trigger and invoke connections using the Business Event System in Oracle Integration.

See Use the Oracle Advanced Queuing Adapter for Business Event System.

Oracle Talent Acquisition Cloud (Taleo EE) Adapter - New adapter Use the Oracle Talent Acquisition Cloud (Taleo EE) Adapter to asynchronously import data in bulk into Oracle Talent Acquisition Cloud (Taleo EE) (formerly known as Taleo Enterprise Edition) from other applications. You can also import attachments when you use the Oracle Talent Acquisition Cloud (Taleo EE) Adapter to import data from an external application into Oracle Talent Acquisition Cloud (Taleo EE). The Oracle Talent Acquisition Cloud (Taleo EE) Adapter is supported only as an invoke in an integration flow; adding it as a trigger is not supported.

See Oracle Oracle Talent Acquisition Cloud (Taleo EE) Adapter Capabilities of Using the Oracle Talent Acquisition Cloud (Taleo EE) Adapter with Oracle Integration.

New Process Features
Feature Description

Saving web form data

You can capture form data at multiple points in a process, and store it in a database or file system for archiving or auditing purposes. For example, you might capture a form snapshot after an end user submits a form and then again after a manager approves the form.

See Save Web Form Data in Using Processes in Oracle Integration.

If-Then-Else decisions

You can now introduce additional test statements (Else If statements) in If-Then-Else decisions.

See Create If-Then-Else Statements in Using Processes in Oracle Integration.

Set analytics retention

You can set the number of days to retain completed analytics before automatic purging. The default number of retention days is 7. Because increasing retention days increases database consumption, you'll need to balance your organization's retention needs with database capacity.

Specify the retention setting in runtime administration. See Schedule Analytics Archive and Purge in Using Processes in Oracle Integration.

Array filtering in structured processes

In the Data Association editor of a structured process or transformation, you can selectively filter elements from a source array object and assign them to a target array.

See Filter Array Data Objects in Using Processes in Oracle Integration.

Decision FEEL loops

You can now create a Loop decision to iterate over lists or arrays. This decision type supports For, Every, and Some loops.

See Create Loops in Using Processes in Oracle Integration.

Decision modeling best practices

We've added guidelines to make decision models easy to develop, maintain, and interpret. These best practices use a simple vacation days decision calculation as an example.

See Best Practices for Modeling Decision Logic in Using Processes in Oracle Integration.

IMPORTANT: Set instances purge retention

Here's a reminder to set the number of days to retain completed process instances before they get purged. (Purged instances cannot be recovered.) The default number of retention days is 7. Because increasing retention days increases database consumption, you'll need to balance your organization's retention needs with database capacity.

Specify the retention setting in runtime administration. See Schedule Instances Archive and Purge in Using Processes in Oracle Integration.

January 2019

New Common Features
Feature Description

Streamlined product name

For simplicity, we’ve shortened our name from Oracle Integration Cloud to Oracle Integration. Our user-managed version is now called Oracle Integration Classic. This change has no impact on functionality.

New Integration Features
Feature Description
Oracle Monetization Cloud Adapter - New adapter The Oracle Monetization Cloud Adapter lets you integrate the Oracle Monetization Cloud REST APIs with other Oracle or external applications in Oracle Integration.

See Oracle Monetization Cloud Adapter Capabilities of Using the Oracle Monetization Cloud Adapter with Oracle Integration.

Errors are displayed for rejected messages in trigger connections Inbound rejected messages are tracked. These are messages that are too large and are rejected by the inbound adapters. The audit trail page shows the trigger connection in red when a rejected message is encountered.
New Process Features
Feature Description

Use base64 images in forms

You can now upload images encoded in base64 format to forms.

See Upload and Preview a Base64 Image in Using Processes in Oracle Integration.

December 2018

New Common Features
Feature Description

Change the BYOL Metering Option of an Existing Instance

You can change the BYOL metering option of an already existing instance, as necessary. This feature is useful for the following scenarios:

  • You selected the wrong option when creating a new Oracle Integration instance and need to change it.
  • You need to shift the location of an on-premises license in the cloud. For example, you need to move the license from one Oracle Integration instance to another or even to a different type of cloud service instance such as Oracle SOA Cloud Service.

See Change the BYOL Metering Option of an Existing Instance in Administering Oracle Integration.

New Integration Features
Feature Description

E-mail notification addresses

You can send an e-mail notification from an e-mail address of your choice.

See Send Notification Emails During Stages of the Integration with a Notification Action and Send Service Failure Alerts, System Status Reports, and Integration Error Reports by Notification Emails in Using Integrations in Oracle Integration.

Oracle Field Service Adapter - filter expression support

Support is provided for entering filter expressions when subscribing to events in the Adapter Endpoint Configuration Wizard. You enter the filter expression to apply to the operation. Only events matching this filter are added to the event subscription.

See Trigger Events Filter Selection Page in Using the Oracle Field Service Adapter with Oracle Integration.

Improved icons Icons have been improved in the Integrations canvas.
REST API enhancement Pagination with a limit and offset in integrations, connections, and lookups is supported.
New Process Features
Feature Description

New dynamic process Integration activity

Easily insert and configure integration activities in dynamic processes using the new Integration activity. Add an activity, select Integrations, and choose an integration that has been activated and set to visible. Configure its use as needed.

See Create Activities and Define General Properties for an Activity in Using Processes in Oracle Integration.

Improved web forms expression editor

We've streamlined the user experience to make it easier to build expressions in web forms. As you add actions, conditions, and connectors, and filters, use the collapse icons to see summaries and the expand icons to view and edit details.

See Add Dynamic Behaviors to a Form in Using Processes in Oracle Integration.

Drive dynamic behavior in web form screenflow

Use dynamic data, such as values entered in controls, payload data, or data from connectors to trigger the Change Presentation action.

See Change Form Presentations Dynamically in Using Processes in Oracle Integration.

New performance management QuickStart App added

We're adding more ready-to-activate QuickStart Apps you can use as is or adapt as needed. The new Performance Management app manages the performance management cycle for managers who review employee performance within an organization.

New simple forms editor

Ready to create a form in seconds? Select Use Simple Editor when creating the form, then use the simple intuitive interface to quickly build your form. If at any time you need options available only in the full form editor, click the Use Full Editor button to upgrade the form to full editor mode.

See Use the Simple Editor in Using Processes in Oracle Integration.

Streamlined process application and decision model creation

Creating process applications and decision models is now faster and more intuitive. Click Processes on the Oracle Integration Home page. Process application and decision models now have separate links in the navigation pane. Click either link to see its new streamlined list, then Create to try out creating applications or models.

See Quick Tour of the Processes Page in Using Processes in Oracle Integration.

Robotic process automation adapter for UiPath

You can now use robotic process automation (RPA) tools in your structured and dynamic processes to extend process automation. Use the new UiPath Integrations adapter to automate repetitive human tasks and integrate with applications that do not offer APIs or for which there is no adapter.

See Integrate with Robotic Process Automation Tools in Using Processes in Oracle Integration and Understand the UiPath Robotic Process Automation Adapter in Using the UiPath Robotic Process Automation Adapter with Oracle Integration.

Expanded Process task view for authorized users

We've provided the Process Owner and Process Reviewer roles better visibility into the task history of process instances. Users assigned these special roles see a task history dropdown field with two options:

  • Task View (default) shows the current task's history.

  • Full View shows history for all tasks executed in the process so far.

The assigned role determines the task details available:

  • Process Owners see tasks for processes they own by selecting Administered by Me under My Tasks. They can see task details of all tasks (current and completed) in the process.

  • Process Reviewers see tasks for processes they review by selecting Reviewed By Me under My Tasks. Process Reviewers can see task details for current tasks; they see completed tasks but without details.

See Assign and Manage Roles in Using Processes in Oracle Integration.

Dynamic process iFrame support

We’ve made dynamic process components available for iFrame integration using embeddable components. For example, you can now embed case details, dynamic process instance lists, and milestone and activity lists.

See Experiment with Process UI Components in Using Processes in Oracle Integration.

Timezone support on forms

The Date Time control has been enhanced to adjust to users' timezones. When a user enters data into a Date Time control, the timezone information of the user is saved in UTC format. When other users access this data, the date-time information is displayed in timezones specific to them.

See Configure Date and Time Fields in Using Processes in Oracle Integration.

Business object updates (WSDL)

You can now update external business objects being used in a process application by uploading a new WSDL file. (Updates for XSD and JSON files were also recently added.) A warning is displayed if incompatible definitions are found.

See Work with Web Service Definition Files in Using Processes in Oracle Integration.

New Visual Builder Features
Feature Description

Upgrade to Oracle JET 6.0

The Visual Builder generated applications now use Oracle JET 6.0 libraries and components. 

Improvements to the Page Designer

The following improvements were made to the Page Designer for visual applications:

  • iPad added as device option in the Page Designer for mobile apps
  • Quick Starts now generate ojAction events instead of click events for buttons
  • The Settings editor for a shell page now contains a Default Flow setting to be used when nested flows are embedded in the page using the Flow Container component (oj-vb-content)
  • Pages in design-time are now automatically refreshed when navigating to them to update data changed in a different page (for example, when saving data in Live mode in one tab that affects the data displayed in another tab.)
  • Empty container-like components on the canvas are now highlighted to indicate the area they occupy (rendered border) and their name (gray label). This applies to the Form Layout, Grid/Flex/Bar Containers and Rows, and Toolbar and Masonry components.
  • Support for drop handling for flex in mobile page templates was improved.
  • Improved drop support for oj-form-layout means that any component can be dropped into a form layout, and form layouts can also be nested. A component can be paired with the oj-label that precedes it in the source code, so components without a label-hint attribute set can have their label in the form.
  • A Flow Container component was added to represent the oj-vb-content element. The component can be used in the page to embed a nested flow's page.

Improvements to Quick Starts

The following improvements were made to Quick Starts:

  • The Bind Data step of Quick Starts for List View, Table and Create/Edit/Detail pages now includes component selection dropdown for all the selected fields.
  • Quick Starts now generate ojAction events for buttons instead of previously generated click events
  • Updated default label position attribute (label-edge) in forms generated by Quick Starts for web and mobile apps.

Improvements to Action Chain editor

The following improvements were made to support for working with actions in the Action Chain editor:

  • When adding a Call Component Method action, the component id input is now populated with a list of ids from the page. Upon selection, the component method input is also populated with the methods that are valid for the selected component.
  • When adding a Call REST Endpoint action, placeholders are now shown for the failure outcome in addition to the success outcome.
Added support for nested flows

Visual Builder now supports nested flows, and the following features were added:

  • The Settings editor for pages now contains a Default Flow setting that is used when a nested flow is embedded in the page using the Flow Container component.
  • Nested flows can be created in the flows folder under any flow.
Added support for iPad deployment for mobile apps

iPad was added as a deployment target option when building mobile apps.

Support for Integrations

A new tab for setting the Oracle Integration server URL and authentication was added in the application's Settings editor. An Oracle Integration service catalog was added that lists REST integrations defined in Oracle Integration, and you can now use the service connection wizard to select integrations from the catalog and add them to your application.

Improved support for installing components

The following improvements were made to support adding components:

  • A mechanism was added for updating components installed from Component Exchange.
  • When opening an application, the Component Exchange is automatically checked for new versions of installed components, and a message is displayed when updates are available.
  • The window displaying Component Exchange items now contains individual Browse, Installed and Updates tabs. The Updates tab lists the new versions of components when they are available and can be used to update components.
Improvements in the Property Inspector

The following improvements were made to the Property Inspector for visual applications:

  • An Array type customizer in the All tab for array types can be used to create and manage the array items.
  • A Slots customizer in the General tab and in Page Structure view now lists the component's slots in a logical order.
    • default slot first, contextMenu slot last, the other slots in between
    • startIcon, endIcon slots (for example, for button components)
    • start, middle, end slots (for example, for a bar layout component)
  • For components inside For Each, the $current and the As alias are now available in the mapper/expression editor opened from Property Inspector.
  • The names of action chains created from the Events tab now have "Chain" appended to the name (for example, ButtonActionChain).
Improvements to Event Listeners

The mapper for custom events and variable change listeners now displays $event in the sources. Notification messages are now displayed when an event listener refers to an action chain that does not exist, calls an action chain without mapping required parameters and calls an action chain with unrecognized parameters.

New notifications for variables and types

Notifications were added to indicate invalid or missing details for variables and types:

  • Type is not defined as a valid object or array
  • Type references another type that doesn't exist
  • Type references an invalid type
  • Variables: Default value is invalid
  • Variables: SDP: No endpoint defined
  • Variables: MSDP: No SDPs specified
Settings window now opens in tab

The application's Settings are now displayed in an editor tab in the designer instead of a modal window.

Support for child business objects in business rules editor

The custom code editor for business rules now contains the option to select a template with code for working with child business objects.

Added support for Visual Builder Add-in for Excel plugin

The Oracle Visual Builder Add-in for Excel is a plug-in for Microsoft Excel that allows Excel users to edit business data available from Oracle REST services.

Support for vanity URLs

You can now specify a vanity URL for an application in the Application tab of the visual application's Settings editor.

November 2018

New Integration Features
Feature Description

Oracle HCM Cloud Adapter, Oracle Engagement Cloud Adapter, and Oracle ERP Cloud Adapter - Parent and child business resource support

When configuring the adapter as an invoke connection, you can select parent business resources and their corresponding child business resources.

See Oracle ERP Cloud Adapter Capabilities in Using the Oracle ERP Cloud Adapter with Oracle Integration, Oracle HCM Cloud Adapter Capabilities in Using the Oracle HCM Cloud Adapter with Oracle Integration, and Oracle Sales Cloud Adapter Capabilities in Using the Oracle Engagement Cloud Adapter with Oracle Integration.

DB2 Adapter and MySQL Adapter - Table operation enhancements

Support is provided for performing operations on a table: insert, update, insert or update (merge), and select.

See Oracle DB2 Adapter Capabilities in Using the DB2 Adapter with Oracle Integration and MySQL Adapter Capabilities in Using the MySQL Adapter with Oracle Integration.

Oracle WebLogic JMS Adapter - Schema archive upload support

The upload of a schema archive is supported. A schema archive can have a single top level schema with nested imports and includes that contain absolute or relative paths.

See JMS Adapter Capabilities in Using the Oracle WebLogic JMS Adapter with Oracle Integration.

Oracle Advanced Queuing (AQ) Adapter raw and object support

Raw and object queues are supported.

See Oracle Advanced Queuing (AQ) Adapter Capabilities in Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Integration.

Oracle HCM Cloud Adapter, Oracle Engagement Cloud Adapter, and Oracle ERP Cloud Adapter - dynamic endpoint invocation support

You can dynamically invoke a REST endpoint/URL at runtime without requiring you to configure any extra invoke connection or REST outbound details.

See Oracle ERP Cloud Adapter Capabilities in Using the Oracle ERP Cloud Adapter with Oracle Integration, Oracle HCM Cloud Adapter Capabilities in Using the Oracle HCM Cloud Adapter with Oracle Integration, and Oracle Sales Cloud Adapter Capabilities in Using the Oracle Engagement Cloud Adapter with Oracle Integration.

New Process Features
Feature Description

Forms

We’ve added the following enhancements to the forms editor:

  • Presentation customizer: You now have the option of customizing presentations in addition to cloning them. Customizing creates a new presentation whose controls are linked to the base presentation, and you choose which controls are visible.

    See Work with Presentations in Using Processes in Oracle Integration.

  • Post connectors in events: You can now initiate a POST operation while executing REST connector calls in form events and set the request-body data for the operation.

    See Execute REST Connector Calls in Events in Using Processes in Oracle Integration.

  • Matches function: This new function checks if two strings or expressions match and returns a Boolean value.

    See Specify Functions in Using Processes in Oracle Integration.

  • Global error handling: When configuring global connectors, select the new Ignore connector error option to ensure that even though error handler messages appear in controls, all other events execute normally when a form loads.

    See Global Connectors in Work with Presentations in Using Processes in Oracle Integration.

  • Train component PDF support: You can now print forms that contain train component controls. Note that only the selected step is printed.

    See Configure Advanced Controls in Using Processes in Oracle Integration.

Append to an array

Use the new Append action in the data association editor to add elements to a target array.

See Append to Array in Using Processes in Oracle Integration.

Data mapping default value

While mapping data within structured processes, you can now specify a fallback (default) value in addition to a data source argument.

See Get or Else functions in Work with Expressions in Using Processes in Oracle Integration.

Multiple output decision tables

You can now create decision tables with more than one output variable.

See Define Decision Table Output in Using Processes in Oracle Integration.

Business object updates (XSD and JSON)

As part of iterative design, you can now update external business objects already being used in a process application by uploading a new XSD or JSON file. A warning is displayed if incompatible definitions are found.

See Upload a New Version of a XML Schema File in Using Processes in Oracle Integration.

Dynamic processes

REST API options for retrieving dynamic process resources were added. These endpoints are useful for calling dynamic processes from Visual Builder.

See the What’s New topic under Get Started in Oracle Integration REST API.

Note that by selecting Form as input to a dynamic process, you can now use either a form or REST service to start a process. See Define Process Input and Output in Using Processes in Oracle Integration.

October 2018

New Common Features
Feature Description

Oracle Integration - Export design-time metadata support

Support is provided for exporting Oracle Integration design-time metadata from a user-managed environment to an autonomous environment. You can also export an Oracle Integration instance running in one autonomous environment to another autonomous environment.

See Move Assets Between Environments in Administering Oracle Integration.

New Integration Features
Feature Description

SOAP Adapter - Dynamic endpoint discovery support

Supports is provided for the dynamic discovery of endpoints. This is useful for scenarios in which the endpoint invoked by the SOAP Adapter must be dynamically configured based on runtime logic.

See SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration

Oracle E-Business Suite Adapter - Support for open interface tables and views as invokes (targets) in integrations.

The Oracle E-Business Suite Adapter supports outbound integrations with open interface tables and views from Oracle Integration when adding the Oracle E-Business Suite Adapter as invoke (target) connections.

In addition to PL/SQL and concurrent program REST services, open interface tables and views are now available as REST services for invocation from Oracle Integration.

See Using the Oracle E-Business Suite Adapter.

REST API enhancement You can change the connection in an integration using the REST API.
New Process Features
Feature Description

Upgrade process applications

Use an automated tool to move process applications from Oracle Process Cloud Service or another Oracle Integration instance to Oracle Integration. If you prefer, you can import and upgrade process applications individually.

See Import Process Assets to Oracle Integration in Administering Oracle Integration.

Forms enhancements

We’ve added the following enhancements to the forms editor:

  • Assign names to events: You can now assign names to events in events options. This helps you easily identify multiple events configured for a control or presentation. See Configure Events in Using Processes in Oracle Integration.

  • Labels on repeatable sections: You can now assign labels to repeatable sections. See Configure Repeatable Sections in Using Processes in Oracle Integration.

  • Events enhancements: We now support relational operations within events. We’ve also added new logical functions. See Specify Functions in Using Processes in Oracle Integration.

Integration updates

Easily keep integrations in process applications up-to-date. On the Integrations view, icons identify integrations that have been deactivated or deleted, or active ones whose definitions have changed. Choose the update option that works for your process application.

See Update Integrations in Using Processes in Oracle Integration.

Embeddable components

We’ve added new information on integrating Process snippets such as forms or task lists into other environments such as ERP, CX, or HCM applications.

See Best Practices for Embedding Process UI Components in Using Processes in Oracle Integration.

New Visual Builder Features
Feature Description

Upgrade to Oracle JET 5.2

The Visual Builder generated applications now use Oracle JET 5.2 libraries and components. 

Improvements to the Page Designer

The following improvements were made to the Page Designer for visual applications:

  • HTML serialization has been improved to minimize escape characters in attribute values:
    • Single quotes (') are used to delimit an attribute value if the value contains more double quotes (") than single quotes

    • The symbols "greater than" (>) and "lesser than" (<) are not escaped in attribute values

    • Ampersands (&) in attribute values are not escaped when they are immediately followed by a white-space character or another ampersand

  • The Delete button for components in the Property Inspector was removed. You now delete components using the Delete item in the context menu at the top of the Property Inspector.

  • The All tab in the Property Inspector now displays an indicator when a property has a sub-property where values have been set.

  • The Property Inspector header now contains a Back button with the parent component name in some cases
    • Components in named slots of parents - e.g. "< Button | Icon" for an icon in a slot of a button

    • Components that declare a link to one of its ancestor tags - e.g. "< List View | Swipe Tile" where swipe action tile is in a swipe actions element inside a list view's template element

  • The Property Inspector now provides improved support for CCA component metadata:

    • Create General and Data tabs for properties marked in their component.json with propertyGroup 'common' or 'data'

    • When marked with 'format', the following properties will have more specialized customizers created in the Property Inspector: date, time, datetime, color.

    • Events marked as 'common' will appear in event Quick Starts, and as 'suggested' events in the Create Event UI

  • A tool for uploading images and accessing an image gallery was added to the Data tab for image components in the Property Inspector.

  • The List View in the Property Inspector now contains a customizer for Swipe Actions.

  • The HTML code editor now supports Oracle JET 5.1 elements. Insight shows element and attribute documentation. Insight also helps with attribute enumeration values and binding variables.

Improvements to Quick Starts

The following improvements were made to Quick Starts:

  • Variables created by Quick Starts now use a shorter "SDP" suffix instead of the previously long "ServiceDataProvider"

  • Types are now created by Quick Starts into the page scope instead of the flow scope

  • Add Data to List Quick Start now generates components into slots of oj-vb-list-item row CCA (instead of binding fields to attributes of the CCA).

  • The Select Endpoint step of Quick Starts now contains an updated Endpoint picker. The panel shows the simplified view by default and contains an option to switch to the detailed view.

  • The Bind Data step of Quick Starts has been updated to have an Endpoint Structure view where you can drag and drop fields to select them. The step contains an area for adding fields that are included in the data but not rendered in the page.

  • For mobile apps, the Edit Page and Delete Action Quick Starts now generate the appropriate action in List View as a swipe action.

  • A Quick Start Create Static List of Options was added for generating combobox, select and radio buttons components

Improvements to Action Chain editor

The following improvements were made to the Action Chain editors:

  • Actions that are not fully configured will show a warning symbol. A tooltip will indicate the missing configuration.

  • Clicking placeholder node will open a menu with options for adding an action.

  • Action chains can be renamed in the Property Inspector

  • Flow input parameters can be specified for navigateToPage events that changeFlow.

  • A text field for filtering actions was added to the Actions palette.

Improvements to the Artifact Browser

You can now import single files and zip archives by dragging them from your local system directly onto folders in the Artifact Browser. The Import Resources dialog box opens when you add the file.

Improved support for variables and types

The following improvements were made to the support for variables and types:

  • You can now create Multi Service Data Provider (MSDP) variables.

  • Types can be promoted to a wider scope, allowing them to be reused and reducing the number of duplicated type definitions across pages.

  • Unsupported attributes of ADP/SDP/MSDP have been removed.

  • The event listener tab for variables has been simplified

  • Add field is exposed consistently for types

Improved support for connecting to services

The following improvements were made to the connecting to services:

  • In the Services tab of the application’s Settings dialog box, a button was added for testing the connection to the catalog URL using the authentication credentials. Problems connecting to the URL are displayed in the dialog box.

  • In the Authentication tab of the Services editor, the "Allow anonymous access" option replaces "Use different authentication for a logged in user". The upper authentication option is for the logged in user and the lower authentication option is for anonymous users. The Source tab for displaying the Swagger now contains the property "anonymousAuthentication" and the property "diffAuth" is no longer used.

  • In the Authentication tab of the Services editor, "Propagate Current User Identity" was added as an authentication mechanism. This is the preferred option for propagating identity from web or mobile apps to service connections. In order to use the new Implicit Flow authentication at the web app level or "Basic" authentication at the mobile app level, the authentication mechanism for service connections needs to be set to "Propagate Current User Identity".

    In previous releases, mobile apps that were set with "Basic" at the app level could use "Direct" as an authentication mechanism to propagate identity to services. With this release this combination will no longer propagate identity. Instead of using “Direct”, the authentication mechanism for these service connections will be automatically changed to "Propagate Current User Identity" when the visual application is reopened. You are strongly advised to review the service connections for mobile apps that use identity propagation. You must also restage/republish these apps for the new changed settings to take effect and to consume any security related fixes, which is recommended.

  • In the Authentication tab of the Services editor, a new authentication type "Same as Authenticated User" is available when the Allow Anonymous Access option is selected. When "Same as Authenticated User" is selected, the anonymous user will inherit the user credentials from the logged in user (the credentials selected in the Authentication Mechanism dropdown list).

  • Developers can now test service endpoints as an anonymous user by selecting As Anonymous User in the Test tab of a service endpoint. This feature can be use when the Allow Anonymous Access option is selected in the service’s Authentication tab and an anonymous authentication mechanism is selected in the dropdown list.

  • In the Endpoints tab of the Services editor, a button was added that enables you to replace the service definitions of all selected endpoints with the latest updated definitions from the service. The Replace Definitions button is available when the registered service connection is registered via the Catalog (Fusion Applications) or a service specification document ("ADF Describe"). The button opens the service wizard and you are prompted to verify the definitions that will be replaced.

Improved support for business objects

The following changes were made to the business object editors:

  • In the business object Diagrammer, the context menu now contains a Find command (cmd+f or ctrl+f) for locating a business object in the Diagrammer.

  • In the Business Objects panel of the Artifact Browser you can open the contextual menu of a business object and select Find in Diagram to locate the business object in the Diagrammer.

  • In the Endpoints tab of the business object editor, you can now click an endpoint to view the endpoint’s details in the editor. The editor is read-only, but you can use the Test tab to send requests and see the responses with specified parameter values.

Changes to build settings for mobile apps

The following changes were made to the configuration for mobile app build settings:

  • The Build Profiles tab was renamed to Build Configurations.

  • For each platform, you can now individually specify the default build configuration that is used for staging and for publishing.

  • The option was added to force the built app to run in portrait mode.

Permission strings for iOS mobile apps

You can now provide custom permission strings to replace the strings provided by Oracle Visual Builder for the mobile apps it builds for iOS.

Updated application templates

Web and mobile application templates have been updated to use oj-messages, which provides a more modern UI as well as support for additional display options. New applications will automatically be created using the new templates. Existing apps would need to be manually migrated to use oj-messages.

Improvements to security settings

The following changes were made to the security configuration settings:

  • Instance administrators can now use a Certificates page to upload and manage certificates, including self-signed certificates.

  • User identity is now propagated to other co-located services without any explicit login when "Oracle Cloud Account" authentication is used.

  • Added support for OAuth2 implicit grant flow in the web app settings.

Improved support for translations

In the Property Inspector you can now choose the resource bundle to use for storing a translation string.

Improved Git support

Git Tags are no longer used for keeping track of application sources. Commit SHAs are now used instead of tags.

September 2018

New Integration Features
Feature Description

Timezone support in scheduled integrations

When you create a scheduled integration, you can specify the preferred timezone.

See Create a Schedule and View Future Runs in Using Integrations in Oracle Integration.

Monitoring Integrations page enhancements for scheduled integrations

For scheduled integrations on the Monitor Integrations page, navigation links are provided that take you to the Schedule and Future Runs page.

See Monitor Integrations in Using Integrations in Oracle Integration.

Oracle Service Cloud (RightNow) Adapter - New name

The Oracle RightNow Adapter has been renamed to the Oracle Service Cloud (RightNow) Adapter.

See Oracle Service Cloud (RightNow) Capabilities in Using the Oracle Service Cloud (RightNow) Adapter with Oracle Integration.

Oracle Policy Automation Adapter - New adapter

The Oracle Policy Automation Adapter enables you to send data from any cloud or on-premises application to Oracle Policy Automation for complex decision-making. Use the Oracle Policy Automation Adapter for regulated industries such as public sector, financial services, medical devices, and retail; for human resources decision-making; or for anywhere policy-based decisions must be integrated.

See Oracle Policy Automation Adapter Capabilities of Using the Oracle Policy Automation Adapter with Oracle Integration

Oracle Talent Cloud for Midsize (Taleo BE) Adapter - New adapter

The Oracle Talent Cloud for Midsize (Taleo BE) Adapter enables you to create an integration in Oracle Integration. The Oracle Talent Cloud for Midsize (Taleo BE) Adapter uses Oracle Talent Cloud for Midsize (Taleo BE) (formerly known as Taleo Business Edition) APIs to provide access to objects and operations such as requisitions, employees, offers, and so on.

See Oracle Talent Cloud for Midsize (Taleo BE) Adapter Capabilities in Using the Oracle Talent Cloud for Midsize (Taleo BE) Adapter with Oracle Integration.

Microsoft SQL Server Adapter and Oracle Database Cloud Service Adapter - Table operation enhancements

Support is provided for performing operations on a table: insert, update, insert or update (merge), and select.

See Oracle Database Cloud Service Adapter Capabilities in Using the Oracle Database Cloud Service Adapter with Oracle Integration and Microsoft SQL Server Adapter Capabilities in Using the Microsoft SQL Server Adapter with Oracle Integration.

Oracle HCM Cloud Adapter and Oracle ERP Cloud Adapter - File upload to Oracle WebCenter Content

You can upload files to Oracle WebCenter Content (Universal Content Manager) in encrypted or unencrypted format. Oracle WebCenter Content provides a unified repository to store unstructured content, enabling organizations to deliver the content to business users in the proper format.

See Oracle ERP Cloud Adapter Capabilities of Using the Oracle ERP Cloud Adapter with Oracle Integration and Oracle HCM Cloud Adapter Capabilities of Using the Oracle HCM Cloud Adapter with Oracle Integration.

New Process Features
Feature Description

New Service activity in dynamic processes

Use this new activity to invoke an external service, such as an OIC integration or a REST connector, from a dynamic process.

See Create Activities in Using Processes in Oracle Integration.

New Train control in forms

Use this new control to sequentially guide users through a multistep web form activity.

See Configure Advanced Controls in Using Processes in Oracle Integration.

Print forms

The new Print action lets you print a presentation of a form when an event occurs.

See Work with Presentations in Using Processes in Oracle Integration.

Form event enhancements

You can now monitor form logs and test your form with custom payload data.

See Preview Forms and Their Payload in Using Processes in Oracle Integration.

Process runtime enhancements

We’ve added these enhancements to improve process execution:

  • Maximum number of loops or activities: To prevent a process executing a very large number of loops or activities as part of a single process instance, the number of direct/indirect loops is restricted to 1000, at which point execution is suspended. This restriction prevents audit data growth and releases system resources.

  • Repeat failure/exception handling: To ensure that a process instance does not result in repeated exceptions, especially when invoking an external service, we’ve limited auto-recovery on faulted process instances to two times.

August 2018

New Common Features
Feature Description

Common logging configuration for Oracle Integration

Administrators can adjust logger levels and download logs for all features in one place by selecting the Settings link in the navigation pane on the main Home page.

See Configuring Logging Settings in Administering Oracle Integration.

New learning path

A new learning path showcasing the Integrations and Visual Builder features in a Weather API example is available on the Tutorials page in the Oracle Help Center:

  • Rain or Shine, Oracle Integration Has You Covered

New security, authentication, and authorization for Oracle Integration REST APIs using OAuth

Authentication and authorization in Oracle Integration is managed by Oracle Identity Cloud Service. Oracle Integration REST APIs as well as REST endpoints exposed in integrations are protected using OAuth token-based authentication.

See Security, Authentication, and Authorization in REST API for Oracle Integration.

Oracle Integration Cloud Service to Oracle Integration export/import

You can export your Oracle Integration Cloud Service design-time metadata as an archive and import that archive into Oracle Integration. You do not need to manually configure connection endpoints and passwords and then activate the exported integrations in Oracle Integration. Integration activations occur automatically.

See Move Assets Between Environments in Administering Oracle Integration.

New Integration Features
Feature Description

Oracle Advanced Queuing (AQ) Adapter - Outbound messaging support

Enqueueing of messages in the outbound (invoke) direction is supported. You select the queue destination for outbound messages and configure the message format. You also select to use an existing schema or no schema (message is sent in opaque format).

See Oracle Advanced Queuing (AQ) Adapter Capabilities in Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Integration.

REST Adapter - Two-way SSL support

Support is provided for consuming external REST APIs that are protected using transport level security. The REST Adapter supports one-way SSL and two-way SSL. Oracle Integration supports a certificate management user interface to upload public certificates for external APIs that are protected either using lesser known certifying authorities (CA) or self-signed certificates.

External REST APIs hosted on a two-way SSL server require client side (Oracle Integration) identity. Oracle Integration provides support for exchanging the client side identity with the server hosting the external API.

See Creating an Integration that Consumes External REST APIs Hosted on a Two-Way SSL-Enabled Server of Using the REST Adapter with Oracle Integration

Oracle Database AdapterSELECT operation support

Performing a SELECT operation against database tables is supported.

See Oracle Database Adapter Capabilities in Using the Oracle Database Adapter with Oracle Integration.

Orchestrated integrations - Inline menu for adding actions

When you hover your cursor over an action/node in an orchestrated integration, a list appears with selections for Commonly Used, Connections, Actions, and Integration Artifacts. Only actions that are allowed to be placed between the two nodes in question are displayed. You can search for an item by typing in the search box. Only matching components appear in the output.

See Adding Actions Through an Inline Menu in Using Integrations in Oracle Integration.

Stage file action - Schema creation enhancements

Support is provided for creating schemas from XML, JSON, and ZIP file formats in stage file actions of orchestrated integrations.

See Configuring a Stage File Action in Using Integrations in Oracle Integration.

Note action

You can add placeholder notes similar to sticky notes to an orchestrated integration.

See Adding Placeholder Notes with a Note Action in Using Integrations in Oracle Integration.

Integration activation - Detection of incomplete functions

If you attempt to activate an integration that includes a function that is not completely configured, an error message is displayed in the banner. You must complete configuration of this function before you can activate the integration.

See Activating an Integration in Using Integrations in Oracle Integration.

New Process Features
Feature Description

Call a dynamic process from a structured process

You can now call a dynamic process from a structured process. From the process editor, drag and drop a Dynamic Process element from the palette’s System category, select the dynamic process from the process application to call, and map data input to the dynamic process using data association.

See Use a Dynamic Process in a Structured Process in Using Processes in Oracle Integration.

Decision tables

You can now open decision tables and relations in an expanded dialog for easy editing.

See Using Decision Tables in Using Processes in Oracle Integration.

REST APIs

REST API options were added or modified. For example, deploy (activate) a process application and return the activated application’s version.

See the What’s New topic under Get Started in Oracle Integration REST API.

My Tasks

Quickly view and access your tasks in a streamlined list right from the Home page. Open additional options only as needed.

See Quick Tour of the My Tasks page in Using Processes in Oracle Integration.

Forms

This release includes several enhancements for web forms:

  • Use the new array Concat function to concatenate array values as needed. For example, use the function to join values from two tables in a single table. See Specifying Functions in Using Processes in Oracle Integration.

  • For panels in a form, you can add a header and a description to the top of a panel. Also, you can use style themes to format the header. For a section in a form, a new style theme lets you indent sections. See Placing Controls in Panels, Sections, or Tabs and Styling Properties in Using Processes in Oracle Integration.

Process/Decision Modeling lifecycle

We've made enhancements to help you easily sync up your process model decision business objects with their decision model after making changes.

  • Now a decision connector within an application displays an incompatibility error when the data interface is updated for the decision model version associated with it. You can use the Update definition link on the connector to resolve this error.

  • Similarly, decision connectors display errors if the associated decision snapshot is deactivated or if the decision model is deleted.

See Adding Decisions to Applications and Processes in Using Processes in Oracle Integration.

Decision modeling

Easily edit your decision models from within your process application. (No need to close the application and open the decision model.) From the application, select the Decisions component in the navigation pane and click the new Edit option to modify the decision model. To see the decision model snapshot already deployed and used by the application. click the decision component name instead.

See Adding Decisions to Applications and Processes in Using Processes in Oracle Integration.

Dynamic Process default values

We’ve set default values to enable developers to more quickly create and activate a dynamic process. For example, leave defaults selected so you can skip defining roles and assigning them to human tasks until after your dynamic process is up and running.

See Learn dynamic processing basics in Using Processes in Oracle Integration.

Dynamic Process inline validation

As you add and configure activities and stages in dynamic processes, get immediate feedback and fix errors inline--right where you are instead of while testing or activating the process application.

See Working With Inline Validations in Using Processes in Oracle Integration.

Dynamic Process role management

You can now permanently retain role mappings for application activations. Role mappings for an existing version of an application activated to production are retained even if you choose to overwrite the version during activation.

See Creating Process Roles in Using Processes in Oracle Integration.

QuickStart Apps

We’ve added new personalization options you can make available to users of your QuickStart Apps:

  • Let users select a different form and associated presentation for a human task activity or a start form event, from those defined in the process. Also, you can let users edit and customize certain form properties.

  • Let users change activity names in the QuickStart App.

  • Use the new simple expression editor for certain properties associated with Submit/Approve and Notification tasks.

See Decide What Settings Users Can Customize and Customize the QuickStart App in Using Processes in Oracle Integration.

New Integration Insight Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

Console purge support

You can now purge metrics and events data for all consoles or an individual console, selecting to purge all data or only data from a specified number of days or weeks.

See Working with the Consoles Page and Working with Preconfigured and Custom Dashboards.

New Integration Insight videos

New videos are available on the Videos page on the Oracle Help Center to provide visual instructions for using Integration Insight to complete the tasks required to generate dashboards where you can monitor your business processes:

  • Create a Connection

  • Create a Model

  • Define a Milestone

  • Reinitialize the Unique Identifier

  • Map a Milestone to an Integration

  • Define Extraction Criteria for the Unique Identifier

UI and usability enhancements

The Business Transactions dashboard and the Business Transaction Details page have been updated to improve your experience.

See Working with the Business Transactions Dashboard and Business Transaction Details in Using Integration Insight in Oracle Integration Classic.

Consolidated documentation in one publication

The Integration Insight documentation that was published in four separate publications is consolidated into a single guide: Using Integration Insight in Oracle Integration Classic

Support for new Integrations actions

You can now map milestones to these Integrations actions:

  • Assign

  • Error Hospital

  • Fault Return

  • Raise Error

  • Stop

See Supported Integrations Features in Using Integration Insight in Oracle Integration Classic.

New custom dashboard chart types

You can now create custom dashboards using the Line and Scatter chart types.

See Creating Custom Dashboards in Using Integration Insight in Oracle Integration Classic.

New dashboard filter setting

The Preferences page has been removed, and the setting Use as Default for all Consoles has been moved to the dashboard Filter settings.

See Filtering Dashboards in Using Integration Insight in Oracle Integration Classic.

New Visual Builder Features
Feature Description

Redesigned user interface and application architecture for building visual applications

The application designer now supports creating richer user interfaces by providing access to a broader set of Oracle JET UI components, direct access to the source code of your page, and a more robust visual development environment. The tool now provides greater flexibility for creating custom user interfaces and adding richer behavior. The redesigned application architecture enables easier access to external sources of data, visual definition of business logic flows, and more refined control over the user interface functionality.

The Home page for visual applications using the new architecture is now the default for Visual Builder.

Upgrade to Oracle JET 5.1

The Visual Builder generated applications now use Oracle JET 5.1 libraries and components. 

Improvements to the Page Designer

The following features were added to the Page Designer for visual applications:

  • Live and Code toggles replaced with a three-state toggle Live / Design / Code

  • Device selection dropdown in toolbar of mobile page designer redesigned with separate Landscape / Portrait toggles

  • Drag and drop support in the canvas is now based on HTML5

  • A new Icon component was added to the Component Palette (a span with icon class)

  • Icon gallery items have been updated to add labels and improve spacing for the various preview sizes.

  • JET text components now support virtual keyboards so on mobile devices an appropriate keyboard shows up. This has been added to the Property Inspector for appropriate text fields and defaulted correctly by component type.

  • New components can now be added to the Component Palette from the Component Exchange and added to pages like other components.

  • The Train (oj-train) and Switcher (oj-switcher) components and Bar Layout Container were added to the Components palette.

  • The Bar layout container was added as a layout option for pages, and components can be positioned into the Start, Middle and End areas of the container. It is now possible to switch between any of the layout options.

  • A popup menu for components on the canvas and in the Page Structure view enables you to surround the component with oj-bind-if, oj-bind-for-each, or oj-defer components, or a Flex container.

  • Masonry Layout and Masonry Tile layout components are now supported. Drop feedback is available for positions between existing tiles, and the size, layout and order of tiles can be configured.

  • The following components were added to the Components Palette: Masonry Layout, Masonry Tile, Navigation List, Conveyor Belt, Film Strip, Messages, and Password Input field.

  • The Component Palette now contains a Picker category containing Inline Data Picker, Inline Date Time Picker, Color Palette and Color Spectrum components.

  • A Quick Start was added in the Events tab for table components to create action chains triggered by first-selected-row events.

  • The filterCriterion parameter replaces filterCriteria in the Add Data Quick Start.

Improvements in the Page Structure view

The following improvements were made to the Page Structure view for visual applications:

  • Components can now be dragged from the palette into the Page Structure view, from the Page Structure view onto the canvas, and moved within the Page Structure view

  • The Page Structure view now displays more details about components

  • In the Page Structure view, slots are visible as nodes that can be drop targets. You can use the Show Slots toggle in the Page Structure to show and hide the nodes.

  • You can now delete or surround elements using a popup menu in the Page Structure view.

Improvements to Property Inspector

The following improvements were made to the Property Inspector for visual applications:

  • In the Property Inspector, an icon chooser was added for the following components: menus, tabs, radio buttons, comboboxes, selects and checkboxes

  • In the Property Inspector, the Slots section of some components now contains a (+) action for adding a new component directly into the slot:
    • Mobile Page Template component - slots Left Side (startControl) and Right Side (endControl) offer Button and Menu

    • Button component - slots startIcon and endIcon offer Icon and Image

    • many JET components - contextMenu slot offers Menu

  • Variable selection popup and expression editor for components in List View and Table components now include $current object with its attributes. Child component's event mapper in List View now includes $current object with its attributes, including $current.key. $current.key is passed to action chains as key parameter for components inside List View and Table components. List View and Table components now set the single selection mode on selection event quick start, if not set previously.

  • oj-vb-list-item component (list row CCA) now has a general Property Inspector tab with customizers for its attributes

  • Datetime, Date and Time field components now have formatting options

Improvements to Quick Starts

The following improvements were made to the Quick Starts in visual applications:

  • pages generated by Quick Starts now include flow name as the prefix of the page name (for example, main-edit-bo1, or item1-edit-bo1).

  • new icons on Quick Starts tab in Property Inspector

  • Chart Quick Starts now generate data bindings with the JET 5.1.0 Chart Data Provider

  • The Field selection step in Quick Starts now includes a filter field to help locate fields in the endpoint structure panel.

  • Rich-type related metadata from Swagger is taken into account when creating field components in Quick Starts. With the Rich types implemented in business objects, we now generate proper components on our pages and honor the format attribute of the selected fields. Examples of the new fields include email, URL, phone, and percentage. This also includes showing proper icon in the endpoint structure. Numeric fields in business objects get additional hints for minimum, maximum and few others such as scale and precision. Generated components take those hints into account. String fields in business objects get additional hints for minLength, maxLength and pattern. When generated into form pages as a string input component, these should be honored and translated into proper component's attributes and validators.

  • In the page–related Quick Starts, nested objects for Create/Detail pages implemented by allowing users to select items from inside an array. When finished the page will have an initial single empty item in the array in the record variable and generated UI components will bind to that single item.

  • In the Edit Page Quick Start, a warning is displayed when a read-only field is selected, and conditional update based on ETag + If-Match has been added into the Edit pages generated by the Quick Start.

Improvements to Business Rules editor

The following improvements were made to the Business Rules editor:

  • Field-level triggers are now supported, for actions triggered by changes to a field.

  • The criteria builder now supports reference fields when building conditions. Fields from the references of the references, recursively, are also now supported.

Support for uploading single files

You can now upload individual files from the Artifact Browser and create folders using the import dialog box.

Simplified process for importing and exporting resources and applications

The process for importing and exporting visual application archives and resources are now the same. When exporting a visual application, you can now choose if you want to include the data in custom business objects in the ZIP archive. You can now easily expand and modify application archives locally and create a new archive that you can import. When importing an archive without business object data, the business objects are created but there are no records. You can import ZIP and OVB application archives.

Reorganized structure in Artifact Browser

The logical view of web and mobile applications in the Artifact Browser has been reorganized to simplify locating and creating artifacts.

Improved options for service connections

In visual applications, the Settings dialog box provides details on the URL of the Services Catalog and the authentication used to access the catalog. Web service connections can be marked as server side only connections by selecting the Server Only Connections check box on the service tab.

You can now generate “Bearer” type access tokens that can be used with Oracle Cloud Account, User Assertion OAuth 2.0, Client Credentials OAuth 2.0, and Resource Owner OAuth 2.0 authentication to access Catalog and Business Object APIs from outside Visual Builder.

Improvements to Processes integration

The following improvements were made for integrating visual applications with Processes:

  • A new Perform Task Action trigger was added to perform actions on a task

  • A new Detail Page Quick Start was added for defining detail pages for process objects

  • An Add Task Actions Quick Start was added for tables/lists of process tasks. The Quick Start adds controls to the page that allow actions to be performed on the task that's selected in the collection.

  • Added support for starting a process based on a Form Start event.

  • Enhanced functionality so that users can start processes accepting complex parameters. The UI for mapping complex parameters for actions and triggers has been improved. 

  • The Processes pane in the Artifact Browser now contains menu items to open the Processes design time (Composer) and runtime (Workspace) pages.

Improvements to Audits window

The following improvements were made to the Audits window for visual applications:

  • Filtering is now possible by text and type/severity

  • A progress bar was added to indicate scanning progress

Improved support for translations

The following improvements were made to the support for translations:

  • Clicking the translation icon in the Property Inspector opens a popup dialog where you can specify a description for strings and the key.

  • A Translations tab was added to the Settings page for app artifacts, flow artifacts and pages to create and delete translations bundles.

  • The Property Inspector for visual applications now includes a button for generating keys for strings and including them in translation bundles. The file format for translations has been updated to allow adding metadata to the keys in the translation bundle.

  • The Translations tab in the Settings window can be used for uploading and downloading resource bundles. The default format for resource bundles is now ARB (Application Resource Bundle) to facilitate translating resources using various tools.

Improvements to the Variables and Types editor

The following improvements were made to the Variables and Types editors:

  • The UI was modified to make the Edit Type from Endpoint more discoverable.

  • Improved the drop down for selecting types to provide help hints on the data providers.

Support for application templates

If there are any application templates available in the Component Exchange associated with your instance, you will now see an option to choose an application template when you create a new visual application.

Component Exchange Integration

Service administrators can now set the location of a Component Exchange instance in the Tenant Settings.

May 2018

New Common Features
Feature Description

Oracle Integration managed by Oracle

Not Integration Classic Does not apply to Oracle Integration Classic (user-managed).

Oracle Integration managed by Oracle is a new service offering that provides a unified platform in which you can automate processes, integrate applications, analyze results, and visually build custom enterprise applications. You install Oracle Integration, but Oracle manages your service instance, including performing backups, upgrades, patching, scaling in/out, database administration, and more. This enables you to concentrate fully on designing and deploying your applications.

See What Is Oracle Integration in Administering Oracle Integration.

Support for Oracle Integration managed by Oracle on Oracle Cloud Infrastructure

Not Integration Classic Does not apply to Oracle Integration Classic (user-managed).

When Oracle manages Oracle Integration, it runs on Oracle Cloud Infrastructure. Oracle Cloud Infrastructure combines the elasticity and utility of public cloud with the granular control, security, and predictability of on-premises infrastructure to deliver high-performance, high availability, and cost-effective infrastructure services. Oracle Cloud Infrastructure is an enterprise cloud, capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern serverless and container-based architectures.

See Oracle Cloud Infrastructure and What Is Oracle Integration in Administering Oracle Integration.

New Integration Features
Feature Description

On-premises connectivity agent

The next generation connectivity agent with a significantly smaller foot print of less than 150 MB is delivered with Oracle Integration. This enables you to build integrations that can exchange messages between Oracle Integration and on-premises assets behind a fire wall. The connectivity agent is certified to run on JDK 8 and 9. The agent is certified to run on OEL 6 and 7, RHEL 6 and 7, SUSE Enterprise 12, and Windows Standard 2016. This next-generation connectivity agent eliminates the need for you to manually upgrade the agent whenever Oracle Integration is upgraded. The agent upgrade occurs automatically whenever Oracle Integration is upgraded/patched.

With a significant reduction in foot print, the download and installation of the connectivity agent are completed in less than a few minutes.

See About Agents and Integrations Between On-Premises Applications and Oracle Integration and Downloading and Running the Connectivity Agent Installer in Using Integrations in Oracle Integration.

Oracle NetSuite Adapter - Basic search and pagination

You can define a search criteria based on the fields of a selected business object.

See Oracle NetSuite Adapter Capabilities in Using the Oracle NetSuite Adapter with Oracle Integration.

FTP Adapter - GZIP support

With the support of this feature, your customers/partners can upload files to sFTP/FTP servers as GZIP files. The FTP Adapter can download, uncompress the GZIP files, and stage them for downstream processing.

See FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration.

FTP Adapter - Read file operation file size support

The FTP Adapter now supports reading files up to 10 MB in size with the read file operation. With this capability, additional modeling and processing activities needed for downloading and staging the files and using a stage file action for reading the file in segments are eliminated for processing files up to 10 MB in size.

See What You See on the FTP Adapter Invoke Operations Properties Page in Using the FTP Adapter with Oracle Integration.

Oracle Commerce Cloud Adapter - New business objects

New trigger request and invoke operation business objects are provided. For invoke connections, files, audiences, organization requests, and bulk import/export process operation business objects are provided.

See Adding the Oracle Commerce Cloud Adapter Connection to an Integration in Using the Oracle Commerce Cloud Adapter with Oracle Integration.

REST Adapter - OAuth 1.0 One Legged Authentication

The OAuth 1.0 One Legged Authentication security policy enables web sites or applications (consumers) to access protected resources from a web service (service provider) through an API without requiring you to disclose your service provider credentials to consumers.

An Oracle NetSuite application, for example, protects the RESTlets using OAuth 1.0a token-based authentication. You can use the REST Adapter to invoke Oracle NetSuite REST APIs using a connection configured with this policy.

See How Do I Configure the REST Adapter to Consume a REST API Protected with OAuth 1.0a One-Legged Authentication in Using the REST Adapter with Oracle Integration.

REST Adapter and SOAP Adapter - Size enforcements on messages and attachments

The REST Adapter and SOAP Adapter enforce new size limits on messages and attachments.

For the REST Adapter, there are multipart request and responses in the inbound and outbound directions, respectively. The size limit on attachments is applicable in both the inbound and outbound directions, getting the response from the external service. For example, the REST Adapter trigger cannot take more than 1 GB of attachments combined. Assume there are two multipart attachments that are 500 MB in size. Only two attachments can be sent in that request as the inbound limit is 1 GB. This is the same with outbound responses, if an external service is sending two multipart attachments of 500 MB in size. Only two attachments can be consumed because the outbound response limit is 1 GB for the total number of attachments.

The SOAP Adapter can handle an incoming unstructured payload (MTOM) of up to 512 MB in size.

See SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration.

Describing data definitions using a set of XML schema definitions in the REST Adapter, FTP Adapter, and File Adapter (complex schema support)

Do you have the need to describe the data structure for an XML-formatted message/file using a set of XML schema definitions (XSD)? Starting with this release, the FTP Adapter, File Adapter, and REST Adapter now allow for an archive (ZIP) of XML schema definitions to be uploaded to describe the data structure. The FTP Adapter and File Adapter provide this capability for read and write operations. The REST Adapter provides this support for describing the data structure when the application/XML content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities in Using the REST Adapter with Oracle Integration, FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration, and File Adapter Capabilities in Using the File Adapter with Oracle Integration.

Describing data definitions using a sample XML document in the REST Adapter, FTP Adapter, and File Adapter

The REST Adapter, FTP Adapter, and File Adapter now allow you to upload sample XML documents to provide data definitions for XML-formatted messages/files. The FTP Adapter and File Adapter provide this capability for read and write operations on XML-formatted files. The REST Adapter provides support for describing the data structure when the application/XML content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities in Using the REST Adapter with Oracle Integration, FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration, and File Adapter Capabilities in Using the File Adapter with Oracle Integration.

Describing data definitions using a sample JSON document in the REST Adapter, FTP Adapter, and File Adapter

The REST Adapter, FTP Adapter, and File Adapter now support for allowing customers to upload sample JSON documents for describing the data definitions. The FTP Adapter and File Adapter provide this capability for read and write operations for JSON-formatted files. The REST Adapter provides this support for furnishing the data definition when the application/JSON content type is selected for request and/or response messages in both trigger and invoke connections.

See REST Adapter Capabilities in Using the REST Adapter with Oracle Integration, FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration, and File Adapter Capabilities in Using the File Adapter with Oracle Integration.

Oracle Siebel Adapter IP2017 certification

Oracle Siebel Adapter is certified on IP2017.

See the Oracle Integration Adapters Certification matrix.

Oracle Database Adapter - Bulk data import support for insert and update operations

Oracle Integration is delivering a much-sought after feature - the Oracle Database Adapter allows integration developers to declaratively define an insert-only operation and update-only operation on one or more tables. This new feature supports the sending of multiple records (for example, multiple employees details can be inserted/updated in a single request). It also supports relations (for example, multiple employees within one department can be inserted/updated in a single request).

The Oracle Database Adapter enables Oracle Integration to send 10 MB of data to an Oracle database in a single request.

The Oracle Database Adapter now enables you to declaratively construct your complex DML statements such as insert and update in a few clicks using a graphical editor. The editor supports only insert and update operations. The Adapter Endpoint Configuration Wizard guides you to select schemas, tables, and relationships to construct the data structure that you want to send to the database. The wizard also helps you to filter the attributes from the selected data structure to fine tune the data you may want to send to the database instead of sending all attributes.

Another salient aspect of this feature is that the adapter can accept a collection of records to send to the database as a single unit of work.

The following use cases can be implemented using this new capability:

  • Bulk data insert – You can perform mass inserts. For example, up to 10 MB in the target application’s database in a single transaction in conjunction with orchestration and mapper capabilities. You can model integrations such as the synchronization of customer data from a CSV file to an Oracle database to use this capability.

  • Bulk data update - You can perform mass updates For example, updates of employee benefits from Oracle HCM Cloud to an on-premises database up to 10 MB in the target application’s database system in a single transaction in conjunction with orchestration and mapper capabilities.

See Oracle Database Adapter Capabilities in Using the Oracle Database Adapter with Oracle Integration.

Oracle Advanced Queuing (AQ) Adapter and Oracle WebLogic JMS Adapter - Support for size enforcement and rejection handling

Support is provided for processing payloads up to 10 MB in size.

See Oracle Advanced Queuing (AQ) Adapter Capabilities in Using the Oracle Advanced Queuing (AQ) Adapter with Oracle Integration.

See Oracle WebLogic JMS Adapter Capabilities in Using the Oracle WebLogic JMS Adapter with Oracle Integration.

Oracle Service Cloud (RightNow) Adapter - Upload and download attachment support

You can download a file as an attachment from Oracle RightNow Cloud to Oracle Integration. After the file is downloaded, the Oracle Service Cloud (RightNow) Adapter exposes the file reference in the mapper for use by other adapters for further processing.

Similarly, the Oracle Service Cloud (RightNow) Adapter provides support for uploading a file as an attachment to Oracle RightNow Cloud. An integration flow can be modeled to upload a file as an attachment to an object in Oracle RightNow Cloud.

See Oracle RightNow Cloud Capabilities in Using the Oracle Service Cloud (RightNow) Adapter with Oracle Integration.

Oracle Service Cloud (RightNow) Adapter - Syntactic validation of ROQL-based tabular queries (QueryCSV)

Syntactic validation of ROQL-based tabular queries (QueryCSV) is done automatically to catch any syntactic errors.

SOAP Adapter - Attachment support

The SOAP Adapter now supports sending attachments as part of the payload to an external SOAP API and receiving attachments as part of the responses received from the SOAP APIs.

The SOAP Adapter automatically discovers and supports attachments found in external SOAP APIs based on the Message Transmission Optimization Mechanism (MTOM) standard defined by the World Wide Web Consortium (W3C). Use cases such as the following can be implemented using the new capabilities. You can use the Send Attachments in Request feature in the SOAP Adapter to stream an employee’s data file from Oracle Integration to UCM in Oracle HCM Cloud prior to submitting a request to Oracle HCM Cloud by invoking the Oracle HCM data loader service. Similarly, you can use the Accept Attachments in Response option in the SOAP Adapter to let the SOAP Adapter stream the Business Intelligence Publisher report available in UCM to Oracle Integration, which can be accessed and processed by downstream actions within that integration flow.

See SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration.

SOAP Adapter - Support for uploading a ZIP file with multiple WSDLs and schemas

The SOAP Adapter provides support for uploading complex SOAP interfaces. The WSDL archive can consist of WSDLs along with any number of artifacts such as WSDLs and schemas referenced within. The archive can be uploaded through the SOAP connection. You can use this connection for invoking an external SOAP operation defined in the WSDL archive. Similarly, you can use this connection as a trigger for implementing an integration supporting one of the operations defined in the WSDL archive. For example, you can use this feature to implement integrations that expose SOAP endpoints using OAGIS-based object definitions.

See SOAP Adapter Capabilities in Using the SOAP Adapter with Oracle Integration.

Oracle HCM Cloud Adapter - HCM Atom feed support

The Oracle HCM Cloud Adapter supports subscribing to the HCM Atom feed. Atom feeds enable you to track changes made to feed-enabled resources in Oracle Global Human Resources Cloud.

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

Oracle HCM Cloud Adapter - HCM data extracts support

The HCM data extracts feature in Oracle HCM Cloud is a flexible tool for generating data files and reports in Oracle HCM Cloud. The Oracle HCM Cloud Adapter can be configured to automatically download HCM extracts from Oracle HCM Cloud to Oracle Integration and have them be accessible for downstream processing. For example, you can schedule to run the benefits data extract in Oracle HCM Cloud and have a scheduled orchestrated integration built to automatically download the extracts to Oracle Integration and send all or partial information to downstream applications.

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

New adapter - Oracle Enterprise Performance Management Cloud Adapter

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.

New adapter - Oracle Database Cloud Service Adapter

The Oracle Database Cloud Service Adapter facilitates integration with Oracle Database Cloud Service using the connectivity agent.

See Oracle Database Cloud Service Adapter Capabilities in Using the Oracle Database Cloud Service Adapter with Oracle Integration.

Oracle Utilities Adapter - trigger-based support for manual upload of WSDLs for a particular service

You can also manually upload a WSDL in the trigger (inbound) direction for a specific service instead of parsing the WSDL from the HTTP-based service catalog WSDL specified in the Connections page. This option enables you to upload a WSDL for a particular service in which element-to-element mappings can be performed to deal with anytype elements.

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

Workday Adapter

Workday is a SAAS-based human capital management system that also supports financial management systems for organizations. Workday can be the one system for all your organizational activities such as recruiting, payroll, finance, inventory, and so on.

See Getting Started with the Workday Adapter in Using the Workday Adapter with Oracle Integration.

SuccessFactors Adapter - inbound events support

Trigger (inbound) support is provided for receiving event notifications from SuccessFactors.

See SuccessFactors Adapter Capabilities in Using the SuccessFactors Adapter with Oracle Integration.

Concur Adapter - API option support

The Concur Adapter provides support for Concur’s Extract API and Payment Batch API. Concur’s Extract Web Service enables you to request the extract of available data objects, such as approved expense reports, travel requests, and payment requests. Concur’s Payment Batch API enables you to manage payment batches and collect their batch files.

See Configuring Concur Adapter Invoke API Option Properties in Using the Concur Adapter with Oracle IntegrationUsing the Concur Adapter with Oracle Integration.

New Process Features
Feature Description

Activation

We've enhanced the process application activation wizard:

  • In addition to SOAP integrations, you can now configure REST integrations during activation. Note that you must configure OIC integrations in the Integrations feature.

  • If a process application doesn't use any REST or SOAP integrations, the Customization step is skipped and you proceed directly to validation.

  • If you opt to use credentials configured during design time, they are automatically populated for you during runtime activation. Otherwise, you can create separate credentials for runtime.

See Activating Applications in Using Processes in Oracle Integration.

Email notifications

Help end users more easily respond to tasks by customizing their email notifications. In addition to templates and actions, you can now specify:

  • When emails are sent (upon assignment, completion, or error). You can even specify a different template and subject for each status.

  • How forms associated with tasks are included as attachments (as images, PDF files, inline, or not included).

  • Whether documents or other files previously attached to tasks are included as email attachments.

See Configuring Email Notifications in Using Processes in Oracle Integration.

Forms

Web form enhancements include:
  • Execute actions on columns: We’ve added new actions that let you hide or show table columns when an event occurs. In addition, we've added a new property in the Properties pane that lets you hide table columns.

  • Execute an action on all rows: We’ve added new event actions that let you:

    • Retrieve a control's value and apply it to each row of a table or repeatable section (For Each).

      See Configuring Tables in Using Processes in Oracle Integration.

    • Copy values from one column to another for each row of a table or copy values from one control to another for each row of a repeatable section (Current Iteration Row).

      See Configuring Tables in Using Processes in Oracle Integration.

  • Change presentations dynamically: A new action lets you dynamically switch a form’s presentation, with the option of retaining the modified payload. For example, in a travel request application, change the presentation and available controls based on whether the user selects a one-way or roundtrip flight radio button. See Changing Form Presentations Dynamically in Using Processes in Oracle Integration.

  • Resize uploaded images: You can now control an image’s height and width on the Styling tab.

Data association process activity

A new activity, called Data Mapper, has been added to the structured process editor under System elements. Its sole purpose is to map data.

Use it to assign values to data objects when other activities that use data association (such as human or service tasks) are not needed at that point in the process. Or include a Data Mapper activity to initialize variables for the entire process. This activity can have output only.

See Working with Data Mapper Elements in Using Processes in Oracle Integration.

Auto mapping

Auto mapping is available in both structured and dynamic process editors. Click the Auto Mapping icon in the Data Association window and Process makes its best guess on data values to map, based on names and data types. You may need to make adjustments, but auto mapping works well for straightforward use cases.

Custom properties for structured process activities

You can now assign values to process activities for use in runtime.

Begin by defining properties and assigning them fixed values in design time, then use a process metadata REST API endpoint in runtime to access the assigned values.

See Assigning Custom Properties to Structured Process Activities in Using Processes in Oracle Integration.

Test activate dynamic processes

You can now test your dynamic processes, without needing to activating them each time to see changes.

See Test Activate Your Application in Using Processes in Oracle Integration.

Dynamic process patterns

We've added new process patterns to get you quickly up and started creating dynamic processes. You'll see the available patterns when you add a dynamic process to a process application.

See Creating a Dynamic Process in Using Processes in Oracle Integration.

Customize JSON before importing business objects

You can now edit generated JSON before you import business objects from JSON. This allows you to make any adjustments needed to the best guesses made during generation but before import.

See Importing a Business Object from JSON in Using Processes in Oracle Integration.

REST APIs

New API options were added for dynamic processes. For example, create a new dynamic process instance after first fetching deployed dynamic process definitions. You can create a new dynamic process instance using either the id or key from the response.

See the What’s New topic under Get Started in Oracle Integration REST API.

January 2018

New Common Features
Feature Description

Quick Start instance provisioning

You can provision an Oracle Integration instance with a single click. This instance automatically includes an Oracle Database Cloud Service instance, but does not include an Oracle Cloud Infrastructure Object Storage Classic container instance. This instance is useful for testing integrations.

See Creating a Quick Start Instance with a Single Click of Administering Oracle Integration.

New Integration Features
Feature Description

Integration activation and deployment phases

When you activate an integration, the banner message tells you that it is submitted for activation and to click refresh if activation status is in progress. When you click the refresh icon, the Active icon is displayed in green, if integration deployment is successful.

See Activating an Integration of Using Integrations in Oracle Integration.

Oracle Field Service Adapter — Business object and operations enhancements

A new business object and several operations have been added.

See Configuring Oracle Field Service Adapter Invoke Operations Properties of Using the Oracle Field Service Adapter with Oracle Integration.

Batch size configuration in the MySQL Adapter and DB2 Adapter

You can set the batch size under Advanced Options when configuring the MySQL Adapter and DB2 Adapter in the Adapter Endpoint Configuration Wizard.

See What You See on the Trigger Polling Strategy and Options Page of Using the MySQL Adapter with Oracle Integration and What You See on the Trigger Polling Strategy and Options Page of Using the DB2 Adapter with Oracle Integration.

New Integration Insight Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

End-to-end business process visibility enhancements

It’s now easier to get visibility into business processes that are implemented across more than one integration.

See Event Correlation Across Multiple Integrations and Adding Additional Unique Instance Identifier Associations in Using Integration Insight in Oracle Integration Classic.

When you import a model from a previous version of Insight that has more than one unique instance identifier mapping, Insight either uses the predefined extraction criteria to associate the identifier to an existing milestone or creates a new milestone and associates the identifier to it.

See What Happens When You Import a Model with Multiple Unique Instance Identifier Mappings in Using Integration Insight in Oracle Integration Classic.

December 2017

New Common Features
Feature Description

Instance provisioning with the Oracle Cloud Stack Template

You can create an Oracle Integration instance with the Oracle Cloud Stack template. A template consists of a set of services that are provisioned together (for example, Oracle Integration, Oracle Database Cloud Service, and the Oracle Cloud Infrastructure Object Storage Classic container). A stack is an actual provisioned instance of a template. This option enables you to automatically provision an Oracle Database Cloud Service and the Oracle Cloud Infrastructure Object Storage Classic container along with Oracle Integration during stack template provisioning.

See Creating an Instance with the Oracle Cloud Stack Template in Administering Oracle Integration.

REST API

Functions in REST API for Oracle Integration that are related to instance management and provisioning have been moved to a separate document for easier reference. You can now access the following REST API documents in Oracle Integration:

The REST API for Oracle Integration now displays functions by feature. Functions are grouped under Integrations, Process, and Integration Insight.

New Integration Features
Feature Description

REST Adapter — Support for dynamic REST endpoints

The REST Adapter enables you to dynamically change the (invoke) outbound endpoint configuration.

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

FTP Adapter — Self-diagnosing sFTP server connectivity issues

You can self-diagnose connectivity issues while integrating with external sFTP servers.

See Testing the Connection in Using the FTP Adapter with Oracle Integration.

Oracle Service Cloud (RightNow) Adapter — Oracle RightNow Cloud August 2017 certification

The Oracle Service Cloud (RightNow) Adapter is certified on the Oracle RightNow Cloud August 2017 release.

See Obtaining the Oracle RightNow Cloud WSDL in Using the Oracle Service Cloud (RightNow) Adapter with Oracle Integration.

Oracle NetSuite Adapter — Support for custom attributes

While invoking the Oracle Talent Cloud for Midsize (Taleo BE) Adapter to create, retrieve, or update any record in the Oracle NetSuite application, you can map values for the custom field types exposed by that particular business object in the mapper.

See Oracle NetSuite Adapter Capabilities and Mapping Values for Custom Fields of Using the Oracle NetSuite Adapter with Oracle Integration.

Enabling or Disabling Tracing on Active Integrations

You can enable or disable tracing on activated integrations without re-activating them. You can perform these actions on individual integrations or globally on all integrations.

See Enabling or Disabling Tracing on Active Integrations in Using Integrations in Oracle Integration.

Diagnostic framework enhancements

Enhancements have been made to the collection of incident diagnostics:

  • Incident creation enhancements for test connection failure, migration failure, and database threshold levels being reached.

  • Custom dump creation enhancements inside the incident folders for generated runtime artifacts and diagnostic logs.

  • Use of diagnostic framework log detection features to include additional error codes during incident creation.

  • Enhancements in the execution of custom dumps.

Navigational enhancements in orchestrated integrations and the activation messages of integrations

The following enhancements are provided:

  • Ability to create and edit connections from within the integration canvas of an orchestrated integration.

  • Ability to view expanded integration activation messages in the banner of the Integrations page that show the “submit now” URL and Tracking Runs page link for scheduled integrations and the same endpoint trigger URL and Tracking page link for unscheduled integrations.

See Activating an Integration and Defining Inbound Triggers and Outbound Invokes of Using Integrations in Oracle Integration.

Repositioning of stage file actions

You can reposition a stage file action (except for the Read File in Segments operation) in an orchestrated integration.

See Creating an Orchestrated Integration of Using Integrations in Oracle Integration.

New Process Features
Feature Description

Using integrations in processes

Working with previously created integrations is now even easier in the process editor. You can specify which active integrations, connectors, and web services you want to show in the palette, so developers just drag and drop them and they’re configured for use.

See Using Integrations in Processes in Using Processes in Oracle Integration.

Web form enhancements

The forms editor includes the following enhancements:

  • Rich Text Editor control: Add a rich text editor control into web forms to allow users to enter various types of content, like multimedia, web links, formatted texts, and more.

    See Configuring Rich Text Editor Controls in Using Processes in Oracle Integration.

  • Outcome management: You can now specify custom outcomes (such as Approve, Reject, On Hold, and so on) for a form using events. In addition, you can specify conditions to prevent users from submitting a form.

    See Specifying Custom Outcomes for Forms in Using Processes in Oracle Integration.

  • Localization: Use the new Translate button in the forms editor to supply localized strings for form controls. In runtime, users can then view a localized version of the form by choosing their preferred language.

    See Localizing Web Forms in Using Processes in Oracle Integration.

Dynamic process and connector support in QuickStart Apps

You can now allow users to customize settings related to a dynamic process or connector within a QuickStart App.

See Decide What Settings Users Can Customize in Using Processes in Oracle Integration.

New Integration Insight Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

Map milestones to the start or end of Invoke actions in integrations

When you map a milestone to an Invoke action, you can now choose whether the milestone is considered passed on entry or on exit of the Invoke action. This also affects when values are extracted for associated identifiers and indicators.

See Mapping a Milestone to an Integration in Using Integration Insight in Oracle Integration Classic.

Force model deactivation and deletion

You can now force the deactivation and deletion of models that encounter errors during these actions due to changes to the Integrations instance to which milestones are mapped.

See Deactivating a Model and Deleting a Model in Using Integration Insight in Oracle Integration Classic.

Create a draft of an activated model in the Integrations feature

A model must be in a Draft state before mapping to it. You can now create a draft of an activated model in the Integrations feature as you map to it.

See Mapping a Milestone to an Integration in Using Integration Insight in Oracle Integration Classic.

New Stream Analytics Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

GoldenGate Integration

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.

See Understanding GoldenGate Integration in User's Guide.

New Spatial Patterns

New spatial patterns like Spatial Speed, Geo Code, Intercation Single Stream, Interaction Two Stream, Proximity patters and many more. These patterns provide advanced capabilities like analyzing the speed of a moving object, obtain geo code of a location, and so on

See Spatial Patterns in User's Guide.

Query Group Stage

A query group stage lets you do aggregations on multiple group bys and multiple windows. It is a collection of groups, where each of the group has its own window.

See Working with Query Group Stage in User's Guide.

October 2017

New Integration Features
Feature Description

REST Adapter Enhancements

  • REST Adapter API Key-Based Authentication security policy

    This policy enables you to provide secure access to APIs. The resource owner generates an API key for a given client application with required authorization and then shares this generated API key. The client application is then required to pass this API key with the request for accessing protected resources. See Integrating APIs with API Key-Based Authentication in Using the REST Adapter with Oracle Integration.

  • Support for application/octet-stream MIME Attachment (Raw) Payloads

    Support for Raw binary attachments in payloads has been added. See REST Adapter Capabilities in Using the REST Adapter with Oracle Integration.

  • Support for simple execution of co-located integrations. Co-located integrations are in the same POD or domain.

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

  • When you activate an integration with a REST trigger, at the top of the Integrations page an endpoint metadata URL is provided with which you can inspect the shape of the API. This metadata includes additional information about the endpoint description, the endpoint URI and the swagger URI.

    Screenshot shows the top of the Integration pane after a successful activation. It includes the note: “You can access it via URL.”
  • Support is provided for array types while sampling a JSON payload in the JSON translator.

Invoking co-located SOAP endpoints

Oracle Integration can determine if an outbound SOAP endpoint is invoked by an integration that is local (co-located) or remote to Oracle Integration. Co-located means the integrations are running on the same host instance or in the same domain. If the outbound endpoint is co-located, the endpoint is invoked using an optimized HTTP request using a JSON Web Token (JWT) token for authorization.

See SOAP Adapter Concepts in Using the SOAP Adapter with Oracle Integration.

Oracle Field Service Adapter enhancements

There are several enhancements to the Oracle Field Service Adapter:

  • When a new custom property is added in Oracle Field Service Cloud, you can view it in the mapper for an existing integration by clicking the Oracle Field Service Adapter in an integration and selecting Regenerate Artifact.

  • New business objects and events have been added for selection to the Operations page and the Events page of the Adapter Endpoint Configuration Wizard.

See Oracle Field Service Adapter Capabilities and Adding the Oracle Field Service Cloud Adapter Connection to an Integration in Using the Oracle Field Service Adapter with Oracle Integration.

New functions available in the Expression Builder for integrations

The following functions that were previously available only in the mapper are now available in the Expression Builder. The integration patterns that support these functions are also listed. For orchestrated integrations, you can use these functions in assign, logger, notification, filter, and switch activities.

  • Advanced functions

    • generate-guid (in orchestrated integrations and template integrations)

    • lookup-xml (in orchestrated integrations and template integrations)

    • parseEscapedXML (in orchestrated integrations only)

  • Mathematical functions

    • square-root (in orchestrated integrations and template integrations)

  • String functions

    • compare-ignore-case (in orchestrated integrations and template integrations)

    • createDelimitedString (in orchestrated integrations only)

    • format-string (in orchestrated integrations only)

    • getContentAsString (in orchestrated integrations only)

    • get-localized-string (in orchestrated integrations and template integrations)

    • index-within-string (in orchestrated integrations and template integrations)

    • last-index-within-string (in orchestrated integrations and template integrations)

    • left-trim (in orchestrated integrations and template integrations)

    • right-trim (in orchestrated integrations and template integrations)

Viewing integrations in read-only mode

You can assign the ServiceUser role to users who require read-only access to integrations. A user with this role cannot create, edit, clone, or import integrations. They can download and export integrations.

See What Users Can Do in Integrations by Role in Administering Oracle Integration.

Logging details about integration execution

If you do not enable tracing, minimal logging details are created in ics-flow.log to indicate when the activated integration begins and completes execution (regardless of execution success or failure). You can download the logs on the Dashboard page.

See Activating an Integration in Using Integrations in Oracle Integration.

Loading the latest integration sample versions

You can upgrade your instance to include the latest sample integration versions. If a sample integration is active or locked, it is not overwritten.

See Loading Newer Versions of the Sample Integrations in Using Integrations in Oracle Integration.

Editing integrations with incomplete connections

You can edit the completed connections, actions, and maps in this type of integration. You cannot edit the endpoints based on incomplete connections. Instead, you must first edit the endpoints for those connections on the Connections page.

See Editing an Integration with Incomplete Connections in Using Integrations in Oracle Integration.

Specifying separate retention times for successful and faulted integration instances

You can view the quiesced, unquiesced, and warning thresholds for your database and the percentage of the database that has been used. If you have the Administrator role, you can also set values for the quiesced threshold, unquiesced threshold, warning threshold, and retention times for successful and faulted instances. You can also perform both automatic and ad-hoc purges of the database.

See Purging and Retaining Data in the Database in Using Integrations in Oracle Integration.

Invoking a process from an integration

You can invoke a process from an orchestrated integration. When you drag the process node into an integration, the Select Process wizard is invoked and prompts you to select an application, process, and operation to invoke.

See Creating an Integration that Invokes a Process in Using Integrations in Oracle Integration.

New Process Features
Feature Description

Using integrations in processes

Seamlessly incorporate integrations into processes directly from the process editor. Drag and drop an integration element from the palette to the process flow, and select the active integration to call.

See Using Integrations in Processes in Using Processes in Oracle Integration.

New dynamic processes

This release introduces a powerful and flexible new dynamic process editor and runtime experience for modeling and running unstructured processes. Use the dynamic process editor to model unpredictable processes that depend on knowledge worker input or changing conditions. You can even call structured processes from a dynamic process.

See Ready to create a dynamic process? and Developing and Using Dynamic Processes in Using Processes in Oracle Integration.

Web form enhancements

The forms editor includes the following enhancements:

  • Filters for LOVs: You can now specify filters for controls that accept list of values (LOV) as input. Filters provide a way to selectively extract data from a data source (such as payload or an external connector) and display the filtered data as options of the control.

    See Specifying Filters for Controls in Using Processes in Oracle Integration.

  • Event filters: You can also define a filter within an event and use the filter data in other controls through event actions and conditions.

    See Specifying Filters in Events in Using Processes in Oracle Integration.

  • Data first forms using arrays and enums: The array and enum data types are now mapped to appropriate controls. From the Business Types Palette, you can now use business types that contain these data types to create a web form.

    See Creating a Web Form Based on a Business Type in Using Processes in Oracle Integration.

  • Number and Money controls: The increment/decrement buttons are now hidden by default.

    See Configuring Number Fields and Configuring Currency (Money) Fields in Using Processes in Oracle Integration.

  • Reorder conditions: You can reorder conditions within an event window.

    See Specifying Conditions in Using Processes in Oracle Integration.

  • Check if empty: Use the new operator called is empty within an event window to check if a particular property, such as value, of a control is empty or not.

    See Specifying Conditions in Using Processes in Oracle Integration.

  • Row Count: While configuring events for a table, use the new Row Count property to add a condition based on number of rows present within the table.

    See Configuring Tables in Using Processes in Oracle Integration.

  • Calculate the difference between dates: New interval functions are introduced which you can use to calculate the difference between two dates.

    See Specifying Functions in Using Processes in Oracle Integration.

  • CSS styling: New information is available on using cascading style sheets (CSS) to customize the look and feel of web form elements.

    See Customizing Web Forms Using CSS in Using Processes in Oracle Integration.

New Integration Insight Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

Map integrations to milestones

You can map integrations to Insight model milestones and define extraction criteria for identifiers and indicators in the Integrations feature.

See Mapping Milestones to Integrations in Using Integration Insight in Oracle Integration Classic.

Oracle JET dashboards

Oracle JET dashboards help you gain insight into your business processes.

See Console and Dashboards for a Single Business Process in Using Integration Insight in Oracle Integration Classic.

New Stream Analytics Features

Integration Classic only Applies only to Oracle Integration Classic (user-managed).

Feature Description

Query Stage

Configures a SQL-like query on the data stream and comprises additional sources for Joins, Filters, Summaries, Group By, Time Windows, and so on.

See Application Artifacts in User's Guide.

Rule Stage

Applies conditional (IF - THEN) logic to the events in the stream. You can check for specific conditions and assign values to fields based on the results of your checks.

See Application Artifacts in User's Guide.

New Visual Builder Features
Feature Description

Simple aggregations

Support for simple aggregations for most chart types has been added to the Page Designer. See Adding a Chart Component to a Page in Using Oracle Visual Builder - Classic Applications.

Modeling relationships

The Data Designer has improved support for modeling relationships, including support for creating One to One and Many to Many relationship, and a new visual editor to help you specify cardinality and relationship properties. See Viewing, Creating, and Editing Business Object Relationships in Using Oracle Visual Builder - Classic Applications.

Row-level security

Support for row-level security in the Data Designer has been improved to allow more fine-grained security settings and a query builder for creating simple conditions. See Securing Business Objects in Using Oracle Visual Builder - Classic Applications.

Multi-select component

A multiselect component bound to a many-to-many relationship has been added to the Page Designer. See Adding a Multi-select Component to a Page in Using Oracle Visual Builder - Classic Applications.

Import applications with Process definitions

Visual Builder applications containing Process definitions can be exported and imported. When importing an application you are prompted to specify an existing Process application that contains all the process definitions required by the application you are importing. You can use this method to move an application from a development to a staging or production environment.

Supported Oracle JET version

Feature Description
Upgrade to Oracle JET 3.1.0

The Visual Builder designtime and your generated applications now use Oracle JET 3.1.0 libraries and components. 

Oracle Integration on Oracle Cloud at Customer

The features available to you in Oracle Integration on Oracle Cloud at Customer exclude the latest features added after May 2018.

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.


Oracle Cloud What's New for Oracle Integration

E84902-47

Copyright © 2017, 2019, Oracle and/or its affiliates. All rights reserved.

Primary Author: Oracle Corporation

This document highlights the latest updates to Oracle Integration.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.