Oracle Logo
Identifier Logo
November PaaS Newsletter Banner
November 2020 Edition Oracle Integration & Process Partner Community Newsletter

Grow the Oracle Cloud business and connect, extend & innovate Oracle SaaS solutions.
Dear Partner Community,
The 12th edition of the Cloud Platform Partner Advisory Council will take place December 8th -10th 2020. In case you have implemented successful Oracle Integration in customer projects, It’s your opportunity to share your feedback with the Oracle Product Management team. We will discuss the product road-maps & insights to support your customer success and to improve the Oracle cloud services.

For consultants who attend an Oracle Integration hands-on bootcamp we offer a permanent OIC Playground to continue learning and to become a certified expert.

The Oracle Integration November 2020 update is released. The introduction of quarterly updates allows you to choose your update window. Highlights of the latest release are Oracle Application Adapter improvements like cherry picking resources and 3rd party Adapter improvements like PayPal Adapter inbound support.

In the process & innovation section Kalyn published advanced filtering options in process forms. Thanks to Lalitha for the article on Business Process Automation using Oracle Process Cloud Service.
Jürgen Kress
For a short summary of our monthly key information watch the PaaS Partner Updates on YouTube. The November edition highlights the Gartner Magic Quadrant and the Partner Advisory Council.
In this month’s community webcast Chris Peytier will present how to extend SaaS solutions. Please join the How Process Workflow can extend the role of integration - Partner Community Webcast November 24th 2020.

Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity.

Keep safe!
Jürgen Kress
Table Of Contents
Community Announcements
Cloud Platform Partner Banner
Cloud Platform Partner Advisory Council 2020
You are invited to the 12th edition of the annual global Partner Advisory Council by the Oracle Integration Product Management team.

Why should you attend? Get the latest product updates and roadmap details from the Oracle Integration Product Management team. Provide feedback based on your customer project experience and discuss with the Oracle team product improvements & future directions.
Who should attend? Senior consultants architects, technical leaders & CTOs, who implemented successful Oracle Integration.

Schedule: December 8th-10th 2020

December 8th 8:00-9:00 PST
Keynotes presented by Clay Magouyrk, Executive Vice President, Oracle Cloud Strategy and Andrew Mendelsohn, Executive Vice President, Oracle Data Management Strategy.

December 9th 2020 8:30-11:00 PST
Welcome & introduction & partner feedback
OIC Vision and Roadmap and Release Management
Extreme Scalability and Enhanced Resilience in Oracle Integration, Antony Reynolds
Summery & wrap up day 1

December 10th 2020 8:30-11:00 PST
Adapters & Accelerators & Recepis, Michael Meiner
Extend SaaS with Visual Builder and Process
API Management, Robert Wunderlich
SOA modernization, Ravi Pinto and Sandhya
Summery & wrap up
Process Workflow Banner
How Process Workflow can extend the role of integration
November 24th 2020, 4:30 PM - 5:30 PM CET (Berlin)
Process workflow is often the human-facing counterpart of back-end integration. Each one can leverage the power of the other but they often don't play well together because they cater for different profiles. Oracle Integration Cloud reduces this disconnect in a powerful way that opens new capabilities.
We will demonstrate how each one can leverage the other, and even extend the reach of integration with the use of Robotic Process Automation.

Speaker: Chris Peytier, Oracle EMEA
Schedule: November 24th 2020, 4:30 PM -  5:30 PM CET (Berlin time)
Free on-demand PaaS Partner Community Webcasts
Thanks for attending our monthly community webcasts. Every month a speaker from the Oracle product management teams presents the latest updates on the Oracle Cloud Platform. In case you missed one of them, take the opportunity to watch our community webcasts on-demand:
PaaS Partner YouTube Banner
PaaS Partner YouTube Update
November 2020
The November video includes three topics:

• Oracle named Leader in Gartner Magic Quadrant
• Partner Advisory Councils 2020
• Extend SaaS services with OIC webcast
    For regular updates please subscribe to our YouTube channel here. Thanks for your likes and sharing the video on YouTube and LinkedIn. For the latest PaaS Community information please visit our Community update wiki here (Community membership required).
    SaaS Hands On Bootcamps Banner
    Integrate SaaS hands-on Bootcamps Webtraining
    Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in a row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

    JAPAC December 1st-3rd, 2020
    South America November 17th-19th, 2020
    India November 10th-12th, 2020

    Get the latest OIC training material here (community membership required).
    Implementation Certifications Banner
    Oracle Implementation Certifications
    Enablement and certification is key to cloud succe
    At the Oracle Competence Center and Online Learning Library partners can attend free on-line classes and certifications. Free vouchers for the implementation exam (USD 245) are part of your OPN benefits. To request them please contact your Oracle partner manager.
      Oracle Application Integration Cloud Platform 2019 Sales Specialist (free)
      Oracle Application Integration Cloud Platform 2019 Solution Engineer Specialist (free)
      Oracle Cloud Platform Application Integration 2020 Specialist | 1Z0-1042-20
      In case you can not access the online guided learning path and a free online assessment please contact the OPN team here.

      Back to top

      Integration Section

      Oracle Integration Banner
      Oracle Integration Playground
      Permanent service for Partners free of charge! Want to try, test and get trained on Oracle Integration? Use our OIC playground - a shared permanent environment.
      It’s a shared instance for Oracle Integration Partners community members only, so:
      - use your business email address as your user id (not yahoo or gmail)
      - don’t delete anything you didn’t create
      - do not store any customer data
      - do not give anybody external direct access to this instance
      - when you create any Integration artifacts e.g. connections, integration flows etc. put your initials in the name and your email address in the description. Once registered go here to access the instance. If asked for Cloud Tenant, then enter “bots4saas”.

      Remember to use the documentation, tutorials and learning material at Any issues, questions or feedback please use the Slack workspace
      Oracle Integration November 2020 Update by Antony Reynolds
      It is time for the November quarterly update to Oracle Integration. Lilly the Oracle integration mascot is looking forward to it. We have lots of exciting new features and improvements to share with you. Note that testing is still underway for these features and, although unlikely, it is possible that some will not meet our quality standard and be deferred to a later release.

      Oracle Integration November 2020 update for Oracle Applications Adapters by Prakash Masand
      Oracle Integration is one of the most robust Integration platform for Integrating with Oracle Applications may it be Fusion Applications like ERP Cloud, Engagement Cloud or NetSuite and Service Cloud. Oracle Integration November 2020 update continues to build on the momentum of differentiating Oracle Integration platform for integrating Oracle Applications by providing deep functional, simplified and differentiating features. Thus enabling customers to consume business value from Oracle Applications at a rapid pace in continuum with the Oracle applications updates.

      Choosing Your Update Window by Antony Reynolds
      We currently provide OIC functional updates every quarter. For OIC Generation 2 instances we do this in two windows, usually two weeks apart. Starting with the November release we will allow customers to select the windows in which they wish to be updated. We recommend that non-production instances are updated in the first window and production instances in the second window. This allows customers to sanity check the update before it is applied to production instances.

      Oracle Integration - Adapter Enhancements to Non Oracle Applications by Arvind Venugopal
      Oracle Integration (OIC) has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional enhancements and features on existing Application Adapters.
      In the November 2020 release, Oracle Integration added the following capabilities to third party application adapters:
      • Salesforce Adapter: Enablement for Salesforce Government Cloud Customers
      • ServiceNow Adapter: Graceful downgrade of User Experience
      • PayPal Adapter Inbound Support and New Modules
      • Shopify Adapter New Modules

      How to use the OCI Object Storage from the Oracle Integration Cloud by Daniel Martins Teixeira
      The Oracle Cloud Infrastructure (OCI) offers a great set of services that can be very useful in combination with the Oracle Integration Cloud (OIC) for a wide variety of use cases. Things like the Object Storage, Oracle Streaming Service, Functions etc, can easily be accessed from OIC. The OCI ecosystem has a rich set of API’s that can be used for that purpose. In this post I am going to show how to create a file in the Oracle Object Storage.
      What is the Object Storage
      “The Oracle Cloud Infrastructure Object Storage service is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos.”

      Read ZIP files in Oracle Integration Cloud by Ankur Jain
      We all know the capabilities of Oracle Integration Cloud FTP adapter of reading and writing files. There are situations where the files are in the zip format and required to read the zip files, parse each and every file under the zip file and send the data into the downstream applications.
      In the article, we will explain how to read ZIP file from FTP location and push the content of each file under the zip file into the Oracle database. Download the zip file from here. This zip file contains three CSV file in the below format-

      Security Improvements for Database & FTP Adapters by Michael Meiner
      Oracle Integration (OIC) has a rich set of security capabilities to enable our customers to connect applications and technologies in a secure manner. We continue to enhance Oracle Integration to provide additional security settings and functionality. In the November 2020 release, Oracle Integration offers new security-related functionality for the Database and FTP adapters.

      A Simple Guide to Oracle HCM Data Loader (HDL) Job Support in Oracle HCM Cloud Adapter by Prakash Masand, and Asawari Pawar
      Oracle Integration continues to simplify integrations with Oracle HCM Cloud by adding native support to more and more Oracle HCM integration touch points. Oracle Integration now supports Oracle HCM Data Loader (HDL) jobs, a powerful tool for bulk loading data through integrations. Using Oracle HDL, you can load business objects for most Oracle HCM Cloud products into Oracle Integration. For example, you can load new hires from Oracle Talent Acquisition Cloud (Taleo EE) as workers into Oracle HCM Cloud using an Oracle HDL job.

      OIC Connectivity Agent by Daniel Teixeira
      The OIC connectivity agent is the answer for a secure hybrid deployment, where you have a mix of cloud and on-premise applications and need to ensure a secure communication.
      The agent is the handler/listener that manages both inbound/outbound communication. This ensures that there is no need to open a port in the on premise firewall.
      1. Create an Agent Group
      The agent group is a logical group to which we can associate the physical agents installed on premise. Very simple to create one - Just provide a name and a description.
      2. Download and Run the Connectivity Agent Installer

      Integration, Process & Insight - Netsuite Data Sync Use Case by Niall Commiskey
      OIC is a toolkit - 4 main tools:
      • Integration - connect your apps
      • Process - intelligent human workflows - can be used to extend apps or for your own custom processes.
      • Insight - analyze what's going on in Integration and Process, but this from a business user perspective. More details below.
      • Visual Builder - create net new apps on top of your apis.
      For those who haven't seen Insight before - the OraDocs provide the following succinct description of what it offers - Integration Insight in Oracle Integration provides a business-friendly experience, allowing users to model, collect, and monitor business-level metrics using web-based dashboards. Integration Insight works with business processes that are implemented using the Integrations or Processes features in Oracle Integration

      Create an XML file in Oracle Integration Cloud by Ankur Jain
      Let’s see how to achieve this use case
      • Create a FTP connection: Please go through the article to see how to create FTP connection
      • Create a REST connection. Please go through the article to see how to create REST connection
      • Go the the Integrations and click on the Create button from the upper right coner and select “App Driven Orchestration“

      OIC REST API for Lookups by Niall Commiskey
      Above, my lookup. Here are the Lookup REST APIs - Retrieve is easy - Per default, retrieve does not show me the row values e.g. USD, GBP etc.
      I just need to add the following query parameter, in order to retrieve the contents - Update - let's add a couple of new entries. So what does my request look like? Now let's check the Lookup in OIC - As you can see, the original entries have been overwritten. In this case, update means essentially replace..

      Copy files from one SFTP to another in OIC by Ankur Jain
      There are scenarios where we want to copy files from one SFTP location to another in Oracle Integration Cloud. In this article, I will show you how to copy files from one SFTP to another irrespective of the type of files. Let’s see how to achieve this.
      • Create a scheduler integration
      • Drop the source FTP adapter and enter the name of the endpoint(ListFiles)
      • Configure properties as below and click on the Next button

      Announcing Oracle SOA Suite on Containers & Kubernetes for Production Workloads by Ravi Pinto
      The Oracle SOA Suite Team is thrilled to announce the general availability of Oracle SOA Suite on Containers and Kubernetes for Production environments. This is a culmination of a tremendous effort backed by customer feedback in the early access phase.
      As part of the first release version 20.3.3, we are making available the following:
      • Container images for Oracle SOA Suite including Oracle Service Bus on MOS patch 31966923 (Production) and (Dev & Test)
      • Sample scripts on Github

      Back to top

      Business Process Management & Innovation Section

      Try Our Advanced Filtering in Process Forms by Kalyn Chang
      We have recently added more powerful filtering functionalities in Forms. Previously, you were limited to combining filter conditions with Or logic only, and you couldn't filter existing filters further. Additionally, we have expanded our logging capabilities so users can see the return values of filters.
      Now you can:
      • Combine filter conditions with and logic
      • Filter other filters
      • Debug Filters with Logs

      Business Process Automation using Oracle Process Cloud Service by Lalitha Selvaraj
      Why do we need Process Cloud Service?
      Oracle Process Cloud Service lets you automate business processes in the cloud. A business flow can be created through PCS which goes through multiple/single approval process and can also send email notifications for single/multiple users through mail to approve or reject the process flows through online. Turn your company’s specific processes into process applications by creating process models that includes requests, approvals, decision paths and roles for each task. Process cloud mainly used for Healthcare to improve patient care. Endless forms with personal details, medical history, medical tests, diagnoses and treatments. Not only it is difficult to collect patient form data, save and manage these databases, but it’s also difficult to quickly access them. PCS enables you to configure and customize emails sent as notifications to human workflow task assignee's (the default email notification is too basic, containing only a link to the Workspace app). You can create your own email templates that can include payload information, task information, links and comments.
      Integrating Oracle Process Cloud service with Oracle Integration Cloud Service:
      Integrating Oracle Process Cloud Service with Oracle Integration Cloud Service which uses REST service to fetch the data from on-premise applications or cloud applications. Process applications can communicate and exchange data with local and remote applications that are exposed as either SOAP or REST. The ICS Integration is available for use from any service task. Using the known Data Association feature, you can map a data object to either hold the information that you want to send to the ICS or hold the information sent back by the ICS.

      Back to top

      Additional New Material for PaaS Community

      Twitter SOA Banner
      Top tweets PaaS Community
      Send your tweets #PaaSCommunity. Follow us on Twitter.
      Training Calendar Banner
      Training Calendar
      For the latest trainings please visit our Training Wiki.
      Join the Oracle Developer Meetup groups
      Want to learn more about developing Enterprise-grade Cloud Native applications on the Oracle Cloud Platform, covering topics like Microservices Architecture, developing in Node, Python and PHP, using Low Code development tools to build Mobile apps, and much more?

      Join the Oracle Developer Meetup groups if you want to follow Oracle’s solutions in this area, or participate in the events and hands-on labs we organize:
      Free Trials Banner
      Free trials Oracle Cloud Platform
      Free Oracle Cloud platforms 30 days cloud trial are available here. Your Oracle partner manager can extend this trails.

      For SaaS trials please visit For support please contact the OPN Team.
      My Private Corner Banner
      My private Corner – a treasure

      Your feedback helps us to improve our product, cloud services and partner support. Based on multiple customer projects partners accumulate knowledge and prioritize enhancements.
      12th years ago we hosted the first Integration Partner Advisory Council at Oracle HQ.

      Thanks to you many new features and improvement have been implemented! The next conference in December will include 8 Cloud Platform tracks. For details please visit the registration page here. #PaaSCommunity!

      Back to top

      Invite your colleagues to join the PaaS Partner Community
      Community Resources
      Stay Connected
      Facebook Linkedin Twitter Youtube