Oracle Logo
Identifier Logo
June PaaS Newsletter Banner
June 2021 Edition Oracle Integration & Process Partner Community Newsletter

Grow the Oracle Cloud business and connect, extend & innovate Oracle SaaS solutions.
Dear PaaS Partner Community,
Thanks for the joint business in fiscal year 2021, June 1st starts the New Year for Oracle. Partners play a key role for Oracle integration and digital assistant. 8 of the top 10 Oracle Integration customers are implemented by partners. SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized. Attend the SaaS Innovation Webcast with Suhas Uliyar, Vice President Oracle Product Management, July 8th 2021. Want to increase the Oracle PaaS business? Create new service offerings and solutions for the Cloud? Attend the PaaS Overview Webcast July 6th 2021. Martijn Vlek, Vice President will present the latest PaaS sales plays, kits and how to get access to the Oracle Cloud platform.

For all SaaS consultants we offer again the popular 3 days hands-on Integration bootcamp. New schedules include India, Brazil and Asia, for details please see the registration page here.

Integration Insight now supports process automation. Business users can easily monitor and analyze processes. Dashboards visualize the status of process milestones. Daniel Teixeira completes his process automation series with part 5 publish & activate.
Jürgen Kress
For a short summery of our monthly key information watch the PaaS Partner Updates on YouTube. The June edition highlights Connect & Innovate SaaS & Platform Launch Webcasts and the Hands-on Integration Bootcamps.
In this month’s community webcast Shay Shmelzer will present an Oracle Visual Builder update and how partners can leverage the used by Oracle to develop the next generation of Oracle Cloud Apps to extend SaaS and build customer solutions. Please join the Partner Community Webcast June 29th, 2021. On-demand webcast recordings are available at the Oracle Video Hub.
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
PaaS Partner Adoption
Oracle HQ
Tel. +49 89 1430 1479
Blog LinkedIn Twitter
Table Of Contents
Community Announcements

SaaS Partner Launch Banner
Connect, Innovate & Extend SaaS Partner Launch July 8th 2021
Join our Launch Webcast
Want to increase the Oracle Cloud business? Create new service offerings and solutions for HCM, ERP & CX based on the Oracle Cloud Platform?

Attend this webcast with Suhas Uliyar, Vice President, Product Mgmt.
SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized:
Oracle Integration connects SaaS solutions with out of the box adapters.
Oracle Digital Assistant innovates SaaS solutions with pre-build chatbots.
Oracle Process and Visual Builder extends SaaS solutions with customized UIs and workflows.

Speaker: Suhas Uliyar, Vice President Product Mgmt.,
Digital Assistant AI & Integration Oracle
Schedule: July 8th, 2021, 11:00 AM - 12:00 PM (GMT-08:00)
Oracle Cloud Platform Banner
Oracle Cloud Platform Partner Launch July 6th, 2021
July 6th, 2021
11:00 AM - 12:00 PM

Want to increase your Oracle Cloud Platform business? Want to create new service offerings and solutions for the Cloud?

Attend this webcast with Martijn Vlek, Vice President Oracle EMEA!
• Cloud Platform update
• Sales Plays & Cheat Sheets
• Customer presentations, demos, and free trials
• Partner resources & support

Speaker: Martijn Vlek, Vice President Oracle EMEA
Schedule: July 6th, 2021, 11:00 AM - 12:00 PM CEST (GMT+2)
Oracle Visual Builder Banner
Oracle Visual Builder What’s New - Partner Community Webcast
June 29th, 2021
Learn how you can leverage the Visual Builder Platform - used by Oracle to develop the next generation of Oracle Cloud Apps – to develop your own solutions and to extend Oracle’s Apps too. In this session we’ll explain the new platform architecture, show a full development life cycle demo, and discuss the new features added in the latest release.
See the platform that Oracle relies on for our own business and learn how it can benefit your business.

Speaker: Shay Shmeltzer
Schedule: June 29th, 2021, 10:00 AM – 11:00 AM CET (Berlin time)
Free on-demand PaaS Partner Community Webcasts
Take the opportunity to watch our community webcasts on-demand.

Accelerate your chatbot projects with Oracle Digital Assistant Templates
Identity Propagation call from Integration Cloud to Oracle SaaS Applications
Connect Opera with Oracle SaaS
Extreme Scalability and Enhanced Resilience for OIC
SOA Modernization
Cloud Native and Serverless SaaS Extensions
How Process Workflow can extend the role of Integration
Innovate Service Cloud with Chatbots
Integration Update & New Features
Chatbot Design best practices for Conversational UX
Connect, Innovate, Extend SaaS KickOff Webcast 2020
Cloud Platform KickOff Webcast 2020
NetSuite Integration
Integration Insight
Innovate HCM with Chatbots
ERP Integration with Application Adapters
HCM Integration with Application Adapters
Extend SaaS with Visual Builder Cloud Service
Integration Adapters
Integrate SaaS
Digital Assistant Update

For the latest information please visit Community Updates Wiki page (Community membership required).
Partner YouTube Banner
Cloud Platform Partner YouTube Update June 2021
The June video includes three topics:

• Connect & Innovate SaaS and Platform Launch Webcasts
• Hands-on Integration Bootcamps
• Visual Builder What’s New 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 integration & process information, please join the PaaS community.
    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 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!
    Oracle Product Management is pleased to invite Oracle Partners to attend a 3-days hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud.

    This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.
    Oracle Integration Cloud (OIC) offers Integration, Process Automation and Visual design capabilities that help business analysts and IT specialists to automate end to end business processes across departments.

    Oracle Integration Cloud offers a simple recipe to be successful in this application integration and process automation journey: Build, Integrate and Engage.

    On-demand training
    India June 15th, 18th & 22nd 2021
    Brazil June 29th, 30th & 1st 2021
    Asia July 13th, 16th & 20th 2021
    Oracle Implementation Banner

    Oracle Implementation Certifications

    Enablement and certification are key to cloud success.
    At the Oracle Competence Center and Online Learning Library partners can attend free on-line classes and certifications. In addition we offer the latest implementation exams ($245 or free vouchers) for:
    Oracle Cloud Platform Application Integration 2021 Specialist | 1Z0-1042-21
    Oracle Cloud Platform Digital Assistant 2020 Specialist | 1Z0-1071-20
    Oracle Cloud Platform Application Development 2019 Associate I 1Z0-1043

    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
    Heathrow A Customer Success Story by Flexagon & Capgemini
    In 2020, Heathrow commenced a business and technology transformation which included a move to the cloud. Among other changes, this involved a move from Oracle E-Business Suite (EBS) hosted in a private cloud to Oracle Cloud ERP and the use of Oracle Cloud Infrastructure (OCI) and Platform services such as Integration and Database. The team had been using labor-intensive manual processes to manage their infrastructure, migration of code, configurations, and other changes across environments.
    Heathrow identified an opportunity to make their processes more efficient. They knew there had to be an easier and more modern way to manage changes across their test and production environments and declared that automation would be part of their transformation and shift to the cloud. They wanted automated deployment and management of infrastructure, code, and configurations while establishing repeatable processes, including the ability to be more responsive to business needs.

    Oracle Integration Latest Features by Antony Reynolds
    This page will be updated with links to our regular Oracle Integration new feature announcements. You can bookmark this site so that you never have to search to find out what new features are coming.

    Help! I can’t find my OIC instances anymore by Simone Geib
    This is something I mainly hear from customers whose OIC instances have just been upgraded to Gen 2, and they don’t have much experience with the OCI console yet.
    The remedy is pretty simple though, once you know what to pay attention to.
    After logging into your OCI console, using a URL similar to this - depending on your home region -, select Developer Services -> Application -> Integration in the new simplified OCI menu (see Announcing Improved Navigation for the OCI Console).
    If your OIC instances are in your selected region and in the root compartment, you will see them right away. If that is not the case, check the selected region on the top right:
    Your home region may be Ashburn, but some of your instances may be in Phoenix or Toronto. This is not something you had to pay attention to in Gen 1, but in the OCI console, you will only see instances in the selected region.

    Amazon Selling Partner Adapter for Oracle Integration by Michael Meiner
    Oracle Integration (OIC) adapters enable connectivity to applications. We continue to focus on broadening our portfolio of application adapters, thereby enabling our customers to satisfy a wider set of business use cases in their application ecosystem.
    We are pleased to announce the availability of the Amazon Selling Partner Adapter! For our May release, this is a limited availability feature. We expect to release as part of the out-of-the-box adapters in the near future.
    This adapter is targeted at businesses that sell products in the Amazon store, enabling such businesses to integrate their Amazon store with other applications in their ecosystem.
    The Amazon Selling Partner Adapter has been built in collaboration between Oracle and Amazon. There will shortly be a listing in the Amazon Marketplace Appstore in Seller Central announcing limited availability of the adapter.
    Integration Usecases
    The Amazon Selling Partner Adapter provides the ability for Oracle Integration (OIC) to integrate with your Amazon Seller account, including:
    • Catalog Items
    • Fulfillment by Amazon (FBA) Eligibility
    • Fulfillment by Amazon (FBA) Inventory
    • Orders
    • Merchant Fulfillment
    • Finances
    You can create integration flows with the Amazon Selling Partner adapter such as to connect your Amazon Seller account with an ERP system. OIC has adapters to a number of ERP systems, including of course Oracle ERP. Integration flows may include:
    • Items created in ERP trigger integration to create the item in Amazon account
    • Orders placed on Amazon are captured on scheduled basis by integration to create sales order(s) in ERP
    • Inventory updates in ERP trigger integration to upgrade inventory in Amazon account

    Integrate ICS with a third party OAuth Protected REST service using the generic REST adapter – Part 2 by Anuj Kaushal
    In the first part of the series, we provided a brief introduction of oauth and the various security policies available within ICS. We also had a closer look at OAuth Custom Two Legged Flow. In this post, we will look at OAuth Custom Three Legged Flow. The final part in this series provides the sample custom OAuth Security configuration for some of the popular services.
    Before we delve into custom 3-legged security policy, it is important to understand the steps performed as part of OAuth Authorization code credentials flow:
    Step 1: User specifies the authorization request URI. The user is redirected via the user-agent (browser) to the authorization URI.
    Step 2: Resource owner logs in to authenticate and provides consent to the client application to access its resources.
    Step 3: The authorization server sends a callback request to the client application and sends the authorization code.
    Step 4: The client application extracts the authorization code from the request and uses it to send another request to the authorization server to get an access token.

    Run OIC scheduled integration using REST by Ankur Jain
    Oracle Integration allows you to build the scheduled integration that can run on the set frequency such as once in a day, twice in a day, once in a week, so and so forth. Sometimes, there is a requirement to run OIC scheduled integration by a third-party application based on some event.
    The scheduled integration that is developed may have a scheduled parameter or not and if the scheduled integration is having the scheduled parameter, then also the parameter value needs to pass by a third-party application in case it is called by someone.
    Let’s consider a scenario where you have developed one scheduled integration that takes one parameter with name last-date-time which is used to get the incremental data from the source application and push it to the target application. You have already scheduled this integration which runs on its set frequency. But, In case of any error or someone wants to run it from the back date-time, then what’s the solution. There are a couple of solutions, but the best solution is to use the scheduled REST API which can hit the scheduled integration on-demand.
    Oracle Integration has its own scheduled REST API which can be used to kick off the scheduled integration outside the OIC. Click here to know about the scheduled REST API.

    OIC Connectivity Agent Patterns by Niall Commiskey
    Questions often crop up regarding when the connectivity agent is used.
    For example - I have SAP, Oracle DB, various SOAP / REST Services hosted on premise. The connectivity agent is also installed on the network. Will the connectivity agent be used for all inbound/outbound communication in respect of OIC?
    Let's take SAP as an example - any REST or SOAP based calls to OIC will go directly, i.e. not thru the agent. Any calls via the SAP Java connector will go thru the connectivity agent.

    OIC: Two Methods to receive Callback/Business Events from ERP – OAuth(New) and CISF Keys(Old) by Deb Mukherjee
    Check if the Token-Based Authentication Scheme is Now Enabled for Event Integrations
    Open in SOAP UI /POSTMan :-
    The token-based authentication scheme is added in the Oracle ERP Cloud Adapter for business and FBDI event messages originating from Oracle Fusion Applications. For token-based authentication, the EHF-Token must be present in the HTTP headers of the event message. In the absence of the EHF-Token, Oracle Integration checks for the CSF key credentials for authentication. Token-based authentication removes the dependency on the CSF entry in Oracle SOA Composer.

    Oracle Integration Cloud – Kafka Adapter with Apache AVRO by Daniel Teixeira
    The Oracle Integration Cloud (OIC) May 2021 release brought Apache AVRO support to Kafka. This is something a lot of customers asked and it’s widely used.
    If this is the first time you use the Kafka Adapter with OIC please check these previous posts – Kafka Adapter for OIC and Kafka Trigger.
    What is AVRO
    Apache Avro is a binary serialization format. The format is schema-based so, it depends on the definition of schemas in JSON format. These schemas define which fields are mandatory and their types. Read the complete article here.

    Example of CRUD ops using Rest API :- How to Cancel Invoice Using Rest API in OIC by Deb Mukherjee
    Oracle Fusion Helps with Rest API to access different objects and perform CRUD operations from Backend. First try this in SOAP UI/POST Man and copy the response payload.
    Please ensure the user has proper role to access this rest API.
    Please note the response content-type is :
    Content-Type: application/
    Create a REST Type connection.

    SOA Suite to OIC --> how easy is it? By Niall Commiskey
    This is the first in a series of posts addressing current SOA Suite customers interested in leveraging Oracle Integration Cloud. We currently have many SOA Suite customers adopting OIC. This adoption can take different forms -
    1. "Migrating" existing SOA composites to OIC -
    Here we are essentially talking about re-implementing the existing SOA Suite composites in OIC. I have many customers doing this and doing it very well. One of them had ca. 200 integrations to implement in OIC. This work was done by a team of 2 developers over a period of 6 months - that is from initial development to production.
    2. Lift and Shift SOA Suite on-premise to SOA on OCI - Net new integrations implemented on OIC -
    Think of the following scenario - customer is doing a lift and shift of E-Business Suite on-premise to Oracle Cloud Infrastructure (OCI). SOA Suite is heavily used so it makes sense to lift and shift this component as well. Customer then adopts a cloud based CRM and now has net new integration requirements in respect of, for example, opportunity to order between CRM and EBS.
    3. Co-existence - Net new OIC integrations invoking SOA Suite processes via the OIC SOA Suite adapter and SOA Suite composites invoking OIC integrations.
    This post, is, hopefully, the first of many on this theme. I begin with the simple BPEL process shown above and go deeper as we go along. The process is very simple - allowing me to insert an Order in the Database, via a SOAP interface.

    SOA Suite to OIC - how easy is it? Part 2 by Niall Commiskey
    In this post, I look at the similarities/differences between SOA Suite and OIC, both from a design time and runtime perspective. I then look at an approach to implementing SOA integrations in OIC.
    SOA Suite and OIC
    Now let's go a bit deeper and compare the components of each.
    I like to tell customers OIC is a toolkit. The tools include Integration - to connect apps, Process - to extend apps or implement custom business processes, Visual Builder - to create net new apps on top of your App apis, Integration Insight - giving you business user facing Dashboards and Alerts on top of your integrations and processes. Complement these with a B2B component and an sftp conform File Server then you have the toolkit that is OIC. But there is more...
    OIC runs on OCI, along with many other PaaS services from Oracle. Many of these services could be interesting for you from an integration perspective as well e.g. OCI API Gateway to protect your OIC apis, OCI Streaming Service (Kafka), OCI Functions (Serverless Functions for your more complex business logic), OCI Eventing and OCI Logging - to name but a few. OIC provides adapters for many of these services - net, net OCI services can provide a compelling business value-add to OIC.
    To the above we can add Service Bus, BAM (Business Activity Monitoring), MFT (Managed File Transfer) and B2B components. Naturally both come with a rich set of adapters - SOA Suite has 20+ adapters, OIC has more than 70 and growing.

    Back to top

    Business Process Management & Innovation Section

    Process Automation with Process Cloud Service (PCS) – Part 5 – (Publish & Activate) by Daniel Teixeira
    This is the final post in the process of creating an automated process workflow using the Process Cloud Service. Here I will Publish & Activate the process created before (check Part1, Part2, Part3 and Part4).
    Publish Process
    The Publishing of a process makes those changes available. Thing of this as pushing your changes in a CI/CD world. We cannot Activate a process before Publishing it. Any subsequent change to the process will need to be published (saving it does not make it available to other participants)
    The process can be published with the top right button Publish.
    Activate Process
    Once we published our process it can activated. You can choose which version to activate – in this case the Last Published Version is also the only available version!

    Integration Insight for Process automation by Sandhya Lakshmi Gopalan
    As part of the May 2021 release of Oracle Integration , we have added a new capability which will enable to map Insight to Process applications. This feature will facilitate business users to gain real time visibility of their process applications too.
    Often business processes span across multiple process and integration flows. With this feature , you can create an insight model which can be mapped across both the integration and process flows.
    First, create an insight model aligning to your business process and activate it.
    For example: Let us consider a travel approval business process. This process involves a couple of milestones , indicators and identifier as shown below.

    Back to top

    Additional New Material for PaaS Community
    • April 21 – New OIC articles By Phil Wilkins
    • Speed sailing Fifty-foot racing catamarans are fitted with arrays of sensors and Oracle Cloud technologies to improve performance and build fan excitement, as the SailGP racing championship kicks off Saturday in Bermuda
    • Breaking away Specialized Bicycle Components was pedaling hard to keep up with high demand for bikes during the COVID-19 pandemic. Moving to Oracle Cloud Infrastructure gave the company the power it needed
    • Multicloud strategy Learn why five startups take a multicloud approach, spreading workloads across cloud services from Oracle, Amazon, Microsoft, and Google
    • Partner power PwC sees five main ways its collaboration with Oracle will help their mutual customers, including a focus on “microverticals” such as public utilities, healthcare providers, or gaming, and building on Oracle technology to create custom applications
    • Five Oracle Integration lessons from handling billions of messages monthly
    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.
    Bandit Banner
    Bandit the Cloud Expert
    During the #PaaSForum and the #PaaSSummerCamp many of you meet Bandit.
    As an Oracle speaker, he approved the presentation from Jean Marc Gottero, as part of a cloud process live on stage. Most of the time he was running around the conference meeting new and existing friends. Always looking around for a lap to get pet. After 18 years he retired, we miss you! Share your pictures of #BanditCloudExpert

    Back to top

    Invite your colleagues to join the Integration & Process Partner Community
    For regular information on integration and process solutions please join our Cloud Platform Partner Community. As a community member, you get access to free hands-on training, documentation, sales & Marketing kits including customer presentations and our monthly newsletter & webcast.
    Community Resources
    Blog & Twitter
    Want to see more?
    Stay current on everything OPN has to offer – Visit our Oracle Partner Community Forums!
    Stay Connected
    Facebook Linkedin Twitter Youtube