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

Grow the Oracle Cloud business and connect, extend & innovate Oracle SaaS solutions.
Dear Partner Community,
As 2020 comes to an end finish the year with an Oracle certification. Enablement and certification are key to cloud success. At the Oracle Competence Center partners can attend free online classes and free online certifications: Oracle Application Integration Cloud Platform 2019 Sales Specialist and Oracle Application Integration Cloud Platform 2019 Solution Engineer Specialist. Additional we offer the latest implementation exam Oracle Cloud Platform Application Integration 2020 Specialist | 1Z0-1042-20 ($245 or free voucher).

Every month’s we offer a community webcast with the latest product updates. All webcasts are available on-demand including presentations in ppt format. Highlights include (community membership required):

• HCM Integration with Application Adapters
• ERP Integration with Application Adapters
• Netsuite Integration with Application Adapters
• Integration Update & New Features
• Connect, Innovate, Extend SaaS KickOff Webcast 2020
• Cloud Platform KickOff Webcast 2020
• How Process Workflow can extend the role of Integration
• Extend SaaS with Visual Builder Cloud Service
• Integration Insight
• Integrate SaaS
• SOA Cloud Service

In the process & innovation section we published an Process Cloud Service (PCS) Overview from Surbhi and how to connect PBCS applications with OAC.
Jürgen Kress
For a short summary of our monthly key information watch the PaaS Partner Updates on YouTube. The December edition highlights the Oracle Digital Assistant newsletter and the on-demand partners community webinars.
In this month’s community webcast Angelo Santagata will present how to extend SaaS solutions serverless. Please join the Extend Oracle SaaS with Cloud Native & Serverless Solutions - Partner Community Webcast December 16th, 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
Extend Oracle SaaS Banner
Extend Oracle SaaS with Cloud Native & Serverless Solutions
December 16th, 2020 4:30 PM - 5:30 PM CET (Berlin)
A number of customers have already built extensions/ integrations with Oracle SaaS using a variety of Oracle PaaS services. Going forward some of these will want to upgrade, migrate or build new, extensions/integrations and unsurprisingly want to ensure that their new extensions use modern technologies and modern frameworks.
A specific desire these customers will have is the management of the PaaS servers, SaaS customers are used to the SaaS model, they pay by user/invoice and not by CPU and expect Oracle to manage everything.

This presentation aims to help us understand what needs, when extending/integrating, a SaaS customer will have and various patterns they can adopt. The technologies we will explore are the various cloud native technologies, like Kubernetes, streams etc. and serverless technologies like Oracle Functions as a Service.

Speaker: Angelo Santagata Architect, Oracle SaaS A-Team
Schedule: December 16th, 2020 16:30-17:30 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
December 2020
The December video includes three topics:

• Oracle Digital Assistant newsletter
• Partner Community Webcasts on-demand
• Extend SaaS services with serverless solutions
    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!

    EMEA December 8th-10th 2020
    JAPAC December 1st-3rd, 2020

    Get the latest OIC training material here (community membership required).
    Oracle Implementation 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 for Technical Adapters by Prakash Masand
      Oracle Integration has rich capabilities for connecting with diverse technical end points may it be service / API based like SOAP and REST or messaging based like Kafka and JMS or database management system like ADW, ATP etc. OIC supports wide array of technical adapters enabling customers to connect, integrate and reap advantages of core digital technologies in their business processes. Oracle Integration continues to improve the technical adapters capabilities further empowering customers in their digital transformation journey.
      In November 2020 update we are pleased to announce following updates to the technology adapters:
      REST Adapter Improvements
      Oracle Integration REST adapter is a versatile adapter helping customers to communicate with wide array of products & services like Oracle Functions, OCI Object storage, AWS S3 etc, proving to be a one of the cornerstone adapters for customers modern integration solutions. In the conquest of further empowering the customers, Oracle Integration has been further enhanced the REST adapter with following capabilities.

      Oracle Integration Announcements On Home Page by Kundan Vyas
      What are OCI Console Announcements
      OCI Console Announcements are the messages which are sent to tenant administrator's email to notify them about information related to service status that will impact their tenancy.Tenant administrators can view most recent announcements and the announcements from the past by clicking on the bell icon on the Home Page of OCI Console. Learn more about OCI Console announcements here.
      Clicking on the bell icon on OCI console navigates the users to the OCI Announcements page which displays announcements related to all OCI Cloud services as shown in the picture below.

      Oracle Integration (OIC) - a holistic view by Niall Commiskey
      The focus of my posts is usually on the Integration component of OIC. But sometimes it's better to emerge from the details and take a more holistic view of what is on offer. I may be preaching to the converted, but just in case...
      OIC is THE toolkit for connecting your apps, extending your apps, creating net new apps/mashups on top of your app apis and, finally, providing insight into your business processes
      Let's start from the bottom up - OIC runs natively on Oracle Cloud Infrastructure (OCI). It's one of many services that does so. Others, such as the one's I have listed above may be very useful from an OIC perspective, e.g. processing streaming data from the OCI Streaming Service. OIC already has an OCI Streaming Adapter. What about event driven scenarios? The OCI Events Service can respond to resource changes in your tenancy. Orchestration business logic can be implemented in Oracle's Functions as a Service platform. This is a big value add in respect to our competitors. Please note the OCI Services list in my slide is not exhaustive, other services such as OCI Logging are not listed, purely for space reasons.
      Next level - a couple of months ago we released the File Server component. Now you have your own sftp conform server within your OIC environment. Currently you have an allocation of 500GB of space for processing / storing your files. Leveraging File Server is a no-brainer, considering how many ERP and HCM integrations are still file based.

      A Simple Guide to ERP Cloud Customer Creation through integration by Bala Mahalingam
      Customer information is the foundational data for any enterprise. Definition of a Customer object is a crucial one in the Oracle ERP Cloud implementation.
      Typical use cases for customer creation in Oracle ERP Cloud are:
      1. Users creating customer information through application user interface
      2. Users creating / updating customer information through spreadsheets
      3. Integration with another cloud / on-premise application
      4. Initial data load of customer records from legacy applications
      This blog is focused on integration use case (3) and provide you an overview of creating customer record in ERP Cloud leveraging new REST API’s available in release 20D and SOAP services.
      If you are implementing ERP Cloud and Sales Cloud you need to plan your customer on-boarding process based on your business requirements. One of my blogs on customer data definition guidelines can help you to model your customer in Oracle Fusion Applications cloud. For example, you could start with Prospect in Sales Cloud, and promote it to customer in your sales process, and that customer record will be automatically available in ERP Cloud. ERP Cloud requirement will be just to create Customer Account.

      Oracle Integration: ICS to OIC Migration with transition to ATP by Michael Meiner
      Oracle Integration (OIC) has a rich set of capabilities to enable our customers to connect to Oracle databases including on-premise databases and Cloud (DbaaS, ATP). We continue to enhance Oracle Integration to provide additional database connectivity functionality. In the November 2020 release, Oracle Integration offers new functionality for transitioning to an ATP database.
      This can be especially important when migrating from Integration Cloud Service (ICS) to Oracle Integration (OIC). As OIC runs on Oracle Cloud Infrastructure (OCI), you might want to also take advantage of ATP which is available in OCI. ICS integration flows which integrate with Oracle Database as a Service (DBaaS) typically use the Database adapter. When migrating such integrations to OIC, the Database adapter will appear in the migrated integrations. This makes uptake of ATP cumbersome, as each integration flow would need to be hand-modified to replace the Database adapter with the ATP adapter.
      Integration of ATP using the Database Adapter
      In the Oracle Integration November release, it is now possible to integrate such existing integrations with ATP. In prior releases, the only connection option available with the Database adapter was username password token. This security option is not supported by ATP-Serverless. In the November release, there is an additional connectivity option for Oracle Wallet. You can use this option to connect with ATP-Serverless. This allows you to seamlessly replace the DBaaS connections from ICS with ATP-Serverless connections for use with OIC. There is no need to modify the integrations, just update the connection information including the connectivity agent and you're ready to use ATP!

      OIC Log Management with VB Studio, OCI Bucket and OCI Logging Analytics by Jin Park
      I would like to show how OIC log management can be achieved with OCI Object Storage (I’ll call it bucket) and OCI Logging Analytics, Visual Builder Studio (used to be Developer Cloud, I’ll call it VB Studio).
      Interestingly I’m not going to use OIC to download log files, either to ingest log data from OCI Object Storage. VB Studio will be my tool to do sourcing log files and feeding it to bucket – I’ll be taking advantage of unix shell and oct-cli from VB Studio. Then OCI Logging Analytics will ingest log data from bucket based on cloud event.
      Here is the simple architecture what I’m going to do. In this architecture, OIC instance and VB Studio instance can be located different OCI region from the where bucket and OCI Logging Analytics belong to as it’s using REST API and OCI-CLI.

      Recover unsaved changes for an Integration edit session by Vijay Kendai
      This blog is for a new feature coming out in Oracle Integration Cloud (OIC) November release.
      Due to many unforeseen circumstances, integration developers can lose their work while editing integrations. Lost work may be as a result of browser crashing, losing network connectivity, server going down etc. Depending on the state of the edited integration, the loss of the work can range from minimal changes to complicated mappings and transformations between applications. This blog describes how the integration developer can recover the lost changes.
      What is recovered?
      • Changes made by the integration developer after fully completing an action.

      OIC Nov 20 Release - Data Retention by Niall Commiskey
      New Feature - allowing you to centrally manage your OIC space. It is available in the Settings sub-menu. Here you can define retention time for Integration instances under normal/low space available conditions.
      Purge when Low Space Reached will also delete Process Runtime data.
      This fact may determine whether you check that box or not.
      If Process data from completed instances needs to be retained then this can be done in Process.

      How to Invoke an OCI Function 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 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 deploy a Function, and how to Invoke it from OIC.
      What are Functions
      “Oracle Functions is based on Fn Project. Fn Project is an open source, container native, serverless platform that can be run anywhere, It’s easy to use, supports every programming language, and is extensible and performant.”
      How to Start
      There is extended documentation and plenty of blogs & tutorials that provide a comprehensive deep dive into OCI, Docker Images and Functions etc.

      OIC - A Generic Invoke for Scheduled Jobs by Niall Commiskey
      The customer requirement is as follows - I need to run reports in ERP - format of the call is reportName and dateLastRun.
      This information - reportName and dateLast Run - is stored in a DB table on Oracle ATP. Do I need to have 1 OIC scheduled job for each report? No - here is a simple example of implementing such. Here is the generic job executor - all it does is write to FTP.
      Granted, doesn't look like much, but this is where you would leverage the ERP adapter to kick off the execution of the report. Ok, now to the client - this will read from the DB, get the report name and date last run values.

      Diagnostic logging 'events' and benefits of decoupled log-processors by Jang-Vijay Singh
      The implementation of good logging frameworks is typically asynchronous for good reason: background processing involved in logging activities must not cause an overhead in the main flow. Even the simplest action like writing the output to a log file is implemented behind the scenes in separate threads.

      From a log analysis and diagnostics point of view, this is not a problem as each log entry includes a timestamp that shows the instant when the log entry was requested (rather than the time it was actually written to a log file)

      The same principle applies when we use more complex technologies like the Oracle Service Bus and Oracle Integration Cloud (OIC). Each offers dedicated log activities that write to *-diagnostic.log files or the OIC activity stream.

      OIC Nov 20 Release - Netsuite adapter New Features by Niall Commiskey
      Searching on Item
      Item and Transaction are super records which can have many constituent types.
      For example -
      Inventory Items - physical products that can be bought or sold.
      Assembly Items - physical components that need to be assembled into a finished product.
      There are also non-inventory items e.g. for digital assets etc.

      NetSuite Integration Series: Part 2: Keep data in Sync between Oracle CX Sales (Engagement Cloud) and NetSuite by Naveen Nahata´
      The purpose of this post is to introduce readers to the realtime integration between Oracle CX Sales (formerly Engagement Cloud or Sales Cloud) and NetSuite.
      We explore how to keep customers in sync between Oracle CX Sales and NetSuite when CX Sales is the source of truth. We will build this integration using Oracle Integration Cloud (OIC), which is an offering that helps customers build and orchestrate complex integrations between various systems.
      The same principal can be applied to objects other than the Customer and to certain objects in Oracle ERP Cloud which support Business Events - triggers which notify OIC whenever an object is changed (Created, Updated, Deleted)
      One of the challenge in syncing data between the two systems is that each system has it's own primary identifier and mapping the two requires some way to store cross-reference - which ID in System 1 maps to which ID in System 2

      Track scheduled instances from submission by Arya Sanyal
      "Just clicked on Submit Now action, and when I navigate to Tracking there's no instance! Kind of lost, I click Refresh multiple times to know whether my integration actually triggered."
      "Started a schedule, but on Tracking there's nothing to indicate I have started something until the instance actually starts executing!"
      Sounds familiar? We have an enhancement to help you with a more streamlined monitoring experience for scheduled integrations.
      As soon as you trigger a Submit Now or start a schedule, an integration instance gets created immediately. This also shows up on Tracking and confirms not only the fact that your action is successful but also allows you to track the execution no sooner than you submit.

      OIC - Oracle Field Service via REST by Niall Commiskey
      Yes, there is an Oracle Field Service Adapter in OIC and yes, it provides compelling functionality in respect of common use cases, such as the one described in the OFS adapter documentation - This scenario describes the interaction between the Oracle Field Service and an application that receives and processes alerts for municipal services.
      • A municipal employee receives an alert on the municipal services monitoring application indicating that there is a natural gas leak near a busy downtown intersection.

      Back to top

      Business Process Management & Innovation Section

      Process Cloud Service (PCS) Overview by Surbhi Sharma
      This blog is aimed at the beginner who has started to learn Oracle Integration Cloud (OIC) and want to get familiar with Process Cloud Service (PCS). To learn more about Oracle Integration and its sub-parts then check our blog posts, containing all the key points a beginner should know about Oracle Integration Cloud (OIC).
      What Is Process Cloud Service?
      Oracle Process Cloud Service is used for process automation, its a subscription-based cloud service for process automation. Allowing you to easily extend your existing SaaS and On-Premise.
      PCS offers insights and management of business processes, and a full lifecycle process management environment including development, test, and production.
      Process Cloud Service Overview
      PCS offers rapid design, automate, and manage business processes in the cloud.
      It utilizes two work environments the design-time environment used for developing and testing applications, and the runtime environment used for monitoring process applications.
      Design-Time Environment:
      • User-friendly UI for designing process, rules, forms, data, and metrics
      • Includes QuickStart Apps to quickly create custom business applications
      • Provides test environments for refining and testing processes
      • Allows process applications (metadata and data) from cloud to on-premises
      The Runtime Environment:
      • Makes it easy for you to view, complete, reassign, and delegate tasks
      • Lets you stay organized with filters
      • Lets you share documents and collaborate with others on your team
      • Provides tools to track process flows, view detailed audit trails, troubleshoot, and fix processes
      The design-time environment is also called Composer, and the runtime environment is also called the Workspace. The terms design time and Composer, and runtime and Workspace are used interchangeably throughout this guide.
      PCS Composer Page
      When you click Develop Processes on the Home page, the Composer page opens.
      The Composer page is a core component of the design-time environment. It provides access to common application-related features.
      When you sign in for the first time, the system automatically creates a default space called My Space which will be used for creating the process.

      Connecting PBCS applications with OAC to Create Analyses and Visualizations by Bhuvaneswari Duraisamy
      Oracle Planning and Budgeting Cloud Service (PBCS) is a popular planning solution on the cloud. It is the first Hyperion EPM product on cloud which is more suitable for enterprise wide planning, budgeting and forecasting on the cloud. Organizations often use PBCS to compare the budget and forecast numbers against actuals from transactional system. Oracle supports direct connectivity between PBCS and OAC without any connection adapter options.
      In this blog, I will walk you through a series of steps to use PBCS applications as source to create reports/Visualizations in Oracle Analytics Cloud.
      • Download and install Oracle BI Administration Tool V12. or later.
      • Navigate to admintool.cmd file and edit the file to add INSTANCE_NAME=%DOMAIN_HOME%

      Back to top

      Additional New Material for PaaS Community
      Code class By getting a fresh certification in Oracle Cloud Infrastructure, our own Alexa Morales learns to love virtual, hands-on labs.
      Future of CX Oracle’s Larry Ellison shares thoughts on the changing role of sales force automation apps, the three stages of software maturity, and how the pandemic has forever changed the workplace. Or view the conversation.
      Autoscaling your workload on Oracle Cloud Infrastructure
      Oracle Cloud Platform Virtual Summit: Build Applications Faster with Low Code December 16
      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 – webinars

      Every month’s you have the opportunity to join our live community webcast to learn something new and to ask your questions. These one hour product updates include a live demo.
      Special thanks to the excellent speaker team! Since June 2020 more than 1863 persons have attended the live webcasts and many more the on-demand versions. Missed one of them? Watch them on-demand here (membership required). Like the webcast, want to suggest a topic? Send us your feedback #PaaSCommunity!

      Back to top

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