With the February 2023 release of Oracle Integration Generation 2, we are bringing updates to the Oracle Integration Adapters and various new prebuilt integration recipes.

OIC Gen2 February 2023 Adapters and Connectivity Enhancements

Enhanced Oracle Integration Adapters

Pagination Enablement for SAP ASE (Sybase) Adapter

With the update in February 2023 release, the SAP ASE (Sybase) adapter extends capabilities to provide support for pagination for outbound invocations in Oracle Integration.

More information on the patterns and files supported in the Adapter documentation.

Workday Adapter Authorization Code Credentials Support

As a part of the February 2023 release, the Workday adapter has been enhanced to support Authorization Code Credentials security policy (aka three-legged OAuth).

With the update in the stated release, the Workday adapter enables users to use the Authorization Code Credentials security policy for a Workday adapter connection. Authorization Code Credentials (three-legged authorization) provides better security than basic authentication, i.e., username password.

New fields, namely client ID, client secret, and URL prefix are added to the existing connection properties on the Connection page in Oracle Integration to communicate with the Workday application. To generate the client ID and client secret, the user must register an API client in Workday.

API Certification for Shopify Adapter

From the February 2023 release, the Shopify adapter is certified with Shopify API versions, 2022-07 and 2022-10. It is important to note that the properties/endpoints, that have been deprecated in Shopify API versions 2022-07 and 2022-10 are not supported by the Shopify adapter. For more information about the deprecated properties/endpoints, see Shopify 2022-07 and 2022-10 release notes.

Decision Service support on Oracle Intelligent Advisor Adapter

OIC February 2023 release now enables users and designers to use Decision Service from Intelligent Advisor Hub at the invocation side of an integration.

 

New Recipes added to Oracle Integration Generation 2

Recipes are pre-assembled solutions that bundle all the resources required by the integrations, such as the connections and lookups, into one package. Use a recipe to quickly get started building your first integration. OIC Gen 2 already includes a variety of recipes, this release sees more added.

  • Create project tasks in Oracle NetSuite for Jira issues
  • Get opportunity details from Oracle B2B Service
  • Export new hire info from Oracle HCM Cloud
  • Share YouTube video posts on socials
  • Sync email accounts between Okta and Oracle HCM Cloud
  • Sync employee identities between Oracle HCM Cloud and an LDAP instance
  • Sync work schedules between Workday and Oracle Field Service Cloud
  • Create activities in Oracle Primavera Cloud for Jira issues
  • Create Jira issues for project tasks in Oracle NetSuite
  • Import orders from Shopify to Oracle ERP Cloud
  • Integrate Oracle MICROS Reporting and Analytics sales data from ATP with Oracle Financials Accounting Hub
  • Import sales orders from Oracle NetSuite to Oracle Autonomous Data Warehouse
  • Read and write files on an FTP server
  • Migrate integration artifacts between instances
  • Post Slack notifications for Oracle ERP Cloud purchase order approvals
  • Import employee records from Oracle HCM Cloud to Oracle E-Business Suite
  • Integrate Oracle MICROS Reporting and Analytics with ATP