Oracle
March 2020 Edition Oracle PaaS Partner Community Newsletter
Dear PaaS Partner Community,
Congratulations to more than 850 consultants who achieved the Oracle Cloud Platform Application Integration Associate certification this fiscal year! To become an certified expert we offer you hands-on Oracle Integration and Digital Assistant bootcamps across the globe including Dallas, Redwood Shores, Sao Paulo, Riyadh, Utrecht, Reston, Delhi Mumbai and Webtraining.

Watch Dhwani Shah (part 2), how Evosys transforms Real Estate solutions based on the Oracle Cloud Platform.  We want to promote also your customer success, submit your story via the customer reference program.

Based on the huge demand we offer free online trainings for SaaS Integration:
Oracle Application Integration Cloud Sales Specialist including free online exam!
Oracle Application Integration Cloud Platform for Solution Engineer including free online exam!
• Free live virtual hands-on SaaS Integration Bootcamps to become an Oracle Cloud Platform Application Integration 2019 Associate | 1Z0-1042.

In the process & innovation section Jan shares an article When and How to Create an Integration to Call a Service from a Process? And Ankur on Managing Oracle Process Cloud Service (PCS) Application.
Jürgen Kress
For a short summary of our key monthly information watch the PaaS Partner Updates on YouTube. The March edition highlights sales kits for partners, and hands-on chatbot & integration trainings for SaaS partners. This month’s community webcast will be an update on ERP Integration by Niall Commiskey. Join our PaaS Partner Community Webcast March 25th 2020.

Want to publish your best practice article & news in the next community newsletter? Please feel free to send it via Twitter @soaCommunity #PaaSCommunity!
Table Of Contents
Community Announcements
Integrate SaaS hands-on Bootcamps in Bengaluru, Dallas, Redwood Shores and Webtraining
SaaS Hands On Bootcamps
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! 

Locations:
Dallas, USA March 3rd-5th 2020
Bengaluru, India March 18th-20th 2020
Virtual web training India April 13th-15th 2020
Redwood Shores, USA April 21st-23rd 2020
Virtual web training EMEA May 4th-6th 2020
Registration Page cta-arrow
Accelerate ERP Integration with Application Adapters PaaS Partner Community Webcast March 25th 2020
Offer
Attend our March edition of the PaaS Partner Community Webcast live on March 25th 2020 at 16:30 CET.
Presenter: Niall Commiskey

Integration to applications is dramatically simplified by the use of application adapters that eliminate the complexity associated with web services and other connectivity methods. Simplify your integration to connect with virtually any application, service, or data store. 
Attend the Webcast cta-arrow
Free on-demand PaaS Partner Community Webcasts 
Thanks for attending our monthly community webcasts. Every monthly 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:
bullet
bullet Extend SaaS with Visual Builder Cloud Service
bullet Integration Adapters
bullet Integrate SaaS
bullet Digital Assistant Update
free on-demand community webcasts cta-arrow
PaaS Partner YouTube Update March 2020
PaaS Partner
The March video includes three topics:
• Oracle sales kits for Partners
• Hands-on Bootcamps for Integration & Digital Assistant
• Integrate ERP community 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).
Watch the video here cta-arrow
Watch Dhwani Shah, Evosys how Oracle Digital Assistant and Oracle integration benefits their clients (part2)
PaaS Partner Success
On receiving the award in the category, Innovate SaaS Contribution 2019 at Oracle Emerging PaaS Partner Community Forum in Spain, Dhwani Shah, PaaS Solution Architect in Evosys, shares her views on Evosys’ expertise in PaaS solutions and integrations. For more information please visit the solution catalog.

We want to promote your customer success! Have you implemented successful a solution based on the Oracle Cloud Platform? Submit your success story via the customer reference program.
Watch the video here cta-arrow
New Oracle Implementation Certifications
Offer
Enablement and certification is key to cloud success.
At the Oracle Competence Center and Online Learning Library partners can attend free on-line classes and certifications. Additional we offer the latest implementation exams ($245 or free vouchers) for:
bullet Oracle Cloud Platform Application Integration 2019 Associate | 1Z0-1042
bullet Oracle Cloud Platform Digital Assistant 2019 Associate (1Z0-1071)
bullet Oracle Cloud Platform Enterprise Analytics 2019 Associate | 1Z0-1041
bullet Oracle Cloud Platform Content and Experience 2019 Associate | 1Z0-1040
On-demand integration training cta-arrow
Integration Section
Flag OIC
Oracle Integration at GitHub by Gary Hostt
This guide acts as a repository for getting started with Oracle Integration and where to find relevant resources.
Oracle Integration, OIC, is a fully managed service offered by Oracle, ranked as a leader in application integration by Gartner. OIC offers application integration, typically triggered by an enterprise's business events. We have many successful customers that have digitally transformed their businesses.
OIC substantially differs from Oracle's ODI, EDQ, and GoldenGate offerings. The latter 3 offer data integration - moving larger quantities of data, typically to a data warehouse, for analysis. OIC can eliminate the pain points caused by point-to-point integrations. If this is your first time hearing about OIC, check out the OIC Product homepage.
If you do not have an OIC environment, you can start with this tutorial. You can follow these instructions so spin up an instance. Once you have OIC spun up, start with these beginner tutorials. 
Integrations leveraging Process
Oracle Cloud Platform Application Integration 2019 Associate by Ankur Jain
In this article below topics are covered:
• Exam Details
• Course Fee
• Why Certification?
• Where to register for Certification
• Exam Topics
• Exam Material
• How to view the result
Exam Detail
• Exam Title: Oracle Cloud Platform Application Integration 2019 Associate
• Exam Number: 1Z0-1042
• Course Fee: Rs. 10,475 / $ 245 USD
• Question Type: Multiple Choice
• Duration: 105 minutes
• Number of Questions: 60
• Passing score: 66%
Why Certification?
Using this exam, Oracle will validate and examine your knowledge in Oracle Integration Cloud, SOA CS & API CS.
If you pass this exam then this will help you to grow in your career and will help you to get a job in Oracle Integration Cloud which is on boom now.
Migrating from ICS4SaaS to OIC4SaaS
Introducing the Box Adapter in Oracle Integration by Yogesh Sontakke, and Tuck Chang 
As many of you might know already, at Oracle Open World (OOW) 2019 a few months ago, we announced our partnership with Box to empower our customers to connect their cloud and on-premises Oracle and third-party applications with Box via Oracle Integration (OIC). Read the announcement from OOW here.
Box offers enterprises content management as a cloud service, enabling organizations to share files, collaborate between team members, and manage the lifecycle of content securely. As a cloud service, Box can scale as its customers needs grow in size and depth of complexity including attaching custom metadata to content and watermarking content for review.
Bulk Recovery
ERP Integration using File Based Data Import: Oracle Integration by Ankur Jain
The Oracle ERP integration is one of the most common integration requirement in today’s world as most of the big organization is having Enterprise Resource Planning(ERP) to manage enterprise functions including accounting, financial management, project management, and procurement etc. The article is focused on the aspects which is required in order to connect Oracle ERP system with Oracle Integration Cloud (OIC) using File Based Data Import (FBDI).
For this article, we’ll consider the import of Account Receivables (AR) invoices as an example. 
French Articles Sanae Bekkar
A Simple Guide to Connect to a Private FTP Server using FTP adapter by Dinesh Pant
You can now integrate with an FTP server even when it is in private network and not accessible publicly. This is made possible with the latest feature where a Connectivity Agent can be configured to be used with the FTP adapter.
The FTP adapter supports connectivity to:
• FTP/SFTP hosted on-premise - through a connectivity agent
• FTP/SFTP hosted on cloud - without a connectivity agent, as before
Connection Properties:
Provide connection property values:
Enter the FTP/SFTP host address and port
SOA on Kubernets
How to embed CDATA into XML: Oracle Integration Cloud by Ankur Jain
There is a scenario where you are required to consume SOAP API and the API require to send CDATA as part of the request. In the article, we are going to showcase how to embed the CDATA into the XML request in Oracle Integration Cloud.
Some important link which might help you to extend your knowledge
Call External REST API: Oracle Integration Cloud
SOA on Kubernets
OIC Feature Flag - Data Stitch by Niall Commiskey
Data Stitch action in Orchestration
Available to you as feature flag
(oic.ics.console.integration.stitch-action)
Available from version -All text in italics is from ORCL docs.
This is a new capability within the orchestration designer that enables customers to initialize and progressively update complex variables within integration flows. IT specialists can now use the "Global Variables" section of the designer to define new variables in the integration flow that can hold complex content and use the data stitch action to progressively populate and/or manipulate whole or parts of the document. You can simply drag and drop the "Data Stitch" action from the component palette into the canvas and graphically model the data assignments as an ordered sequence of statements to populate scalar or complex variables wholly or partially. Designers can add multiple data stitch actions at various points in the integration flow to update existing or append new sections to previously declared and populated variables using data from various sources.
Couldn't have said it better myself, net, net - Data Stitch allows us to create and manipulate complex variables within an integration orchestration. This was something missing in OIC, for those coming from SOA Suite/SOA CS. 
SOA on Kubernets
Integration Versioning: Oracle Integration Cloud by Ankur Jain
In this article, we are going to showcase the concept of Integration Versioning in Oracle Integration Cloud.
Some blogs that might help you extend your knowledge
Multiple resources with single REST: Oracle Integration
Oracle Integration Cloud Service Lookups
What is Versioning
You might be wondering what a number on software’s, integrations and applications. These numbers are called version of the applications. 
SOA on Kubernets
Deploying SOA Composites from Oracle JDeveloper to Oracle SOA in WebLogic Kubernetes Operator Environment by Ravi Pinto
Inputs provided by Ashageeta Rao and Vivek Raj
This post provides steps to deploy Oracle SOA composites/applications from Oracle JDeveloper (that runs outside the Kubernetes network) to the SOA instance in WebLogic Kubernetes Operator Environment.
Pre-requisities
Note: Replace entries inside specific to your environment
1. Get the Kubernetes Cluster Master Address and verify the T3 port which will be used for creating application server connections. You can use below kubectl command to get the T3 port: 
SOA on Kubernets
Get XML Document from SOA Infra table by Martien van den Akker
Today I'm investigating a problem in an interaction between Siebel and SOASuite. I needed to find a set of correlated messages, where BPEL expects only one message but gets 2 from Siebel.
To get all the messages that are related to two flows that run parallel based on the same message exchange.
The thing is that of course you want to see the contents of the message in the xml_document. This attribute is a BLOB that contains the parsed document from oracle xml classes. You need the oracle classes to serialize it to a String representation of the document. I found this nice solution from Michael Heyn.
SOA on Kubernets
Unable to create an error notification rule in Oracle SOA Suite 12.2.1? Patch 26088894 is not the fix by Ahmed Aboulnaga
On Oracle SOA Suite 12.2.1.0.0, when we tried to create an error notification rule to alert on failed ESS scheduled jobs, we experienced an issue where the dropdown was not showing any schedules. Unfortunately, the solution to apply patch 26088894 does not work.
Patch 26088894
Patch 26088894 is a zero downtime ESS patch and applicable for Oracle SOA Suite versions 12.1.3, 12.2.1, 12.2.1.1, and 12.2.1.2.
It addresses the issue of the Adapter Schedule generating a Null Error on the GUI, which may appear to be the issue we experienced, but it is not.
Problem: Error Notification Rule Issue
Business Process Management & Innovation Section
Jarvis Pizzeria
OCI: When and How to Create an Integration to Call a Service from a Process? By Jan Kettenis 
With the Oracle Integration Cloud, when you have to call a service from a Process you can choose to call an external service directly or you can put an Integration in between. This article gives some directives why you may want to do the latter, and how to prevent a pitfall that is easy to step in to.
To call a service you have to import the WSDL with it's XSD's. With that Business Types are auto-generated for all complexTypes in that XSD. Recently I was refactoring a case where this resulted in some 220 (!) Business Types being generated from 1 single external service, of which only a few were actually used. Granted, it concerned a service with a very complex interface, but for some reason all the external SOAP services we have to consume are moderate to very complex and easily generate 50+ Business Types. Not only that, they also use relatively long namespaces. Can you imagine what will happen when you have to call 5 of these services from the same Process application! You barely can see the forest from the trees, and you may find it pretty difficult to identify the correct Business Type to use for your request
OIC Force Dehydration
Managing Oracle Process Cloud Service (PCS) Application by Ankur Jain
Managing Oracle Process Cloud Service application includes assigning roles to users or groups to initiate the process, approve/reject the assigned task etc.
Roles assigned to end users define their permissions, such as task assignment and whether they can start an application.
By default, roles get created for each swimlane defined in an application’s processes.
Some important link which might help you to extend your knowledge
Web Application in Oracle Visual Builder
Parent Child relationship in Oracle Visual Builder
Dependent/Cascading List Of Values (LOV) in VBCS
Default Roles of PCS application
Process Owner: Users assigned this role can view process activity history, take actions (such as approve or reject), alter process flow, and view form data for applications they own. Process owners typically manage activated business processes and use metric analysis tools such as dashboards to monitor business processes and alter task flow as needed.
Additional New Material for PaaS Community
Digital Transformation: We’ve Faced the Same Challenges at Oracle  cta-arrow
Data Science Is a Team Sport. Up Your Game cta-arrow
Top 10 Strategic CIO Priorities for 2020 cta-arrow
Oracle Builds on Cloud Momentum with Five New cta-arrow
Video: Introducing Oracle Cloud Free Tier cta-arrow
Twitter SOA
Top tweets PaaS Partner Community – March 2020
Send us your tweets #PaaSCommunity and follow us on twitter https://twitter.com/soaCommunity
PaaS Community tweets cta-arrow
Training Calendar
Training Calendar PaaS Partner Community
For the latest training's please visit our PaaS Community Training Wiki here (membership required) feel free to add your events!
PaaS Community Training Wiki cta-arrow
Join the Oracle Developer Meetup groups
We launched three new local Meetup locations in Cairo, Frankfurt and Porto! 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:
Utrecht,
Netherlands
Join Now cta-arrow
Brussels,
Belgium
Join Now cta-arrow
Cairo, Egypt
Join Now cta-arrow
Cologne,
Germany
Join Now cta-arrow
Frankfurt,
Germany
Join Now cta-arrow
Lisbon,
Portugal
Join Now cta-arrow
Lille,
France
Join Now cta-arrow
London,
UK
Join Now cta-arrow
Madrid,
Spain
Join Now cta-arrow
Istanbul,
Turkey
Join Now cta-arrow
Porto,
Portugal
Join Now cta-arrow
Oslo,
Norway
Join Now cta-arrow
Sao Paulo,
Brazil
Join Now cta-arrow
PaaS free trial accounts OIC & SOA CS and PaaS for SaaS at Demo.Oracle.com
Cloud Trials
As part of our communities we do offer free PaaS accounts.
To request a free 30 days cloud trial, which can be extended or an additional month, please add yourself to our community wiki:
PaaS Demo Accounts (Community membership required).
Free Cloud Trial cta-arrow
My private Corner – Invest time to become a certified expert!
Offer
Currently many business trips & conferences get postponed. Use this time to become a certified Oracle Integration expert. We offer free online trainings:
Oracle Application Integration Cloud Sales Specialist including free online exam!
Oracle Application Integration Cloud Platform for Solution Engineer including free online exam!
• Free live virtual hands-on SaaS Integration Bootcamps to become a Oracle Cloud Platform Application Integration 2019 Associate | 1Z0-1042. As our virtual workshops are always overbooked we decided to offer additional dates. We will offer this additional opportunities for partners who are on the waiting list.
My university professor reminded us each semester that education is a lifetime gift!
Invite your colleagues to join the PaaS Partner Community
free registration cta-arrow
Community Resources
Slack cta-arrow
Workspace cta-arrow
Stay Connected
Facebook Linkedin Twitter Youtube
#PaaSCommunity