Oracle SOA Suite: Two-way SSL with TLS1.2 made easy (slightly less complicated) by Maarten Smeets


Transport layer security (TLS) is not an easy topic. Many blogs have been written about this already. Surprisingly though, I did not find a single blog which was more or less complete and provided me with everything I needed to know to get this working on SOA Suite 12.2.1. In this blog I try to make the topic more easy to understand and provide a complete end to end example.

Suppose you only want an implementation and do not care much about the explanation, you can skip the ‘Some basics’ section, only execute the commands in bold in the ‘Lets get started!’ section and the steps in the ‘WebLogic and SOA Suite’ section. Do take into consideration any existing SSL related configuration on your own system.

Some basics


SSL stands for Secure Sockets Layer. SSL is the predecessor of TLS. SSL should be considered insecure since in October 2014 the POODLE attack was announced. TLS currently has 4 versions. TLS 1.0, 1.1, 1.2 and 1.3. 1.3 is not widely supported/adopted yet. SSL/TLS provide integrity checks, security and authentication.


A server which hosts traffic on a port which has SSL/TLS enabled, has an identity keystore. This identity keystore contains a private key and a public key/certificate. The public key/certificate can safely be given to other parties. With websites when visiting an HTTPS website (HTTP with SSL enabled), the public key is send to you. The other party / client can use the public key to encrypt messages meant for the server. The only one who can decrypt the messages is the one having the private key of the server. This is usually only the server. Read the complete article here.


BPEL and UMS: no wire target for reference… by Martien van den Akker


A moment ago I stumbled on this question on the Oracle community. User Saurabh  tries to build a composite to send email from BPEL. But on testing the deployed composite in EM it fails with a remote fault. This despite of a correct configuration of the email driver and being able to test that   using soa-infra -> Service Engines -> Human Workflow -> Notification Management.
He found that the problem was a bug in JDeveloper/SOA QuickStart, causing the email activity not being wired to a Email UMS notification reference. Fortunately there is a patch for it, as described in DocId 2235669.1 on support. Apply Patch 24898307 to solve this. Read the complete article here.

Complete Tutorial: Step By Step Configuration of Oracle SOA Cloud by Sandeep Pachauri


Recently I got an opportunity to learn Oracle Cloud for SOA 12C, With using Oracle Cloud you don’t required any IT team who will take care of your server and need to manage them. With new Oracle SOA cloud you just need to maintenance your SOA service.

Let us start how to configure Oracle SOA Cloud.

What is Oracle SOA Cloud????

Ref @Oracle Documentation….

Oracle SOA Cloud Service provides an iPaaS computing platform solution for running integration platform applications in the cloud. The following service types are available for provisioning:

  • Oracle Service Bus is a configuration-based, policy-driven enterprise service bus that provides capabilities for service discovery and mediation, rapid service provisioning and deployment, and governance.
  • Oracle Service Bus is a configuration-based, policy-driven enterprise service bus that provides capabilities for service discovery and mediation, rapid service provisioning and deployment, and governance.
  • Oracle Managed File Transfer Cloud Service securely exchanges files between internal departments and external partners.
  • Oracle API Manager facilitates the creation of APIs that expose the functionality of back-end systems or other services. These APIs are published for use by application developers and are managed and monitored at runtime.

You have complete and unrestricted administrative access to your application environment in the cloud.

Oracle Cloud following components over Cloud:

•Oracle Database Cloud Service—Oracle SOA Cloud Service requires that you first subscribe to Oracle Database Cloud Service. You run a provisioning wizard to select an Oracle database instance and node cluster environment. The database is securely hosted in the cloud. Read the complete article here.

Connecting directly to DBaaS – ICS Definitive Tip #7 by Phil Wilkins


Enriching an integration from data in a database or DBaaS (Database as a Service) is not an unusual requirement. Many integration use cases today need to access a database that is on-premises. The means to connect to the database is fairly obvious – the connection agent. Our book goes into a lot more detail as to why that is, and the implications of using database connections.

However when it comes to Oracle’s DBaaS a service it would be very easy to assume that given that you’re using two different parts of Oracle’s PaaS that it would be straight forward to connect the two together without an agent. However, at least today whether its on-premises or DBaaS you need to use a connection agent. This does mean that you’ll need an IaaS node to host the connection agent.

This quirk is driven by the fact that there are some scenarios that this does actually make sense. For example – the Oracle domains need to have a high level of isolation, so when the DBaaS is in another domain then the decoupling via the agent makes sense. When your database is in a different zone of the cloud – then you’re running DB calls across what is effectively a wide are network – not good. Read the complete article here.

OPEN Banking Workshop: Enrich SaaS with PaaS to build innovations (FSI & CX) March 20th–22nd London


The objective of this session is to introduce you to How to use the Oracle Cloud to build solutions for the Financial Services Industry. How can Oracle support you to apply with Open Banking standards and to drive digitalization in banking? In a three days hands on workshop you will build a retail banking proof of concept. Making use of banking API’s, chatbots, mobile applications, process automation and integrate with backend SaaS solutions like marketing cloud and sales cloud.

Schedule: March 20th – 22nd 2018

Location: Oracle Office Londonclip_image001
One South Place
United Kingdom

For details please visit the registration page here.

For additional training please see the community training calendar (membership required).

Integrity check, content validation and encryption of files over ICS FTP adapter Mani Krishnan


Oracle Integration Cloud Service (ICS), an industry-leading iPaaS offering, provides rich orchestration and mapping capabilities over FTP connections.   ICS FTP adapter supports connections over secure or non-secure channels.  Files can be transferred and processed by ICS without validating content upon transfer, which is the default behavior.  Files transferred over secured FTP benefit from inherent integrity checks built into the SFTP protocol.  For more information on ICS FTP adapter, see the link to a guide in references section.

Some users might have advanced requirements to validate content of the files during transfer or check for integrity of file explicitly. In this article, let’s take a look at steps to enable content validation against a schema during transfer, to perform integrity checks using MD5 checksum and to implement PGP encryption to secure files over secure or plain FTP connections.

Note that code archives provided with this article do not come with warranty from Oracle. Use discretion and additional testing to reuse code for production. Instructions in this article are applicable to release 17.1.3 of ICS.

Main article

This article is split into three sections, in order to keep them easier to follow. Click on one of the titles below to jump to a section.

Validating MD5 checksum of content

Validating content against a schema

PGP Encryption/Decryption of content

Validating MD5 checksum of content

Some integration use cases might require that the data file’s integrity be verified after transfer and before further processing.  This could be achieved by storing MD5 checksum of the original content, transfer it along with the file, compute checksum after transfer and compare with the checksum provided along with the file.  If they match, then content has not been altered or corrupt during or after transfer.

In the sample orchestration, a data file and a file containing its MD5 checksum are in a .zip file. ICS computes checksum upon unpacking files into ICS.  The checksum computed at source is compared with the checksum of the data file provided with file listing. If they match, orchestration proceeds with further processing. Read the complete article here.

Free Training On-demand – Oracle SOA Suite 12c and Oracle BPM 12C Implementation Specialists Boot Camps in February and April 2018



Oracle SOA Suite 12c Implementation Specialists Oracle Business Process Management 12C

Feb 19, 2018 – Mar 16, 2018 or

Apr 02, 2018 – Apr 27, 2018

Feb 19, 2018 – Mar 16, 2018 or

Apr 02, 2018 – Apr 27, 2018

What will we cover?
Oracle SOA Suite 12c is the latest version of the industry’s most complete and unified application integration and SOA solution. With simplified cloud, mobile, on premises and Internet of Things (IoT) integration capabilities, all within a single platform, Oracle SOA Suite 12c delivers faster time to integration, increased productivity and lower TCO.
The Oracle SOA Suite 12c Implementation Boot Camp provides relevant insight to current and prospective SOA implementers and for those companies interested on becoming Oracle SOA Suite 12c Specialized. Participants will learn how to develop and implement solutions using SOA Suite 12c that will drive their customer organizations run more effectively and efficiently.
Learn To:

  • Create, deploy, and manage cross-application process orchestration with BPEL Process Manager
  • Describe tasks for users or groups to perform with Human Task Service
  • Define and modify business logic without programming by using Business Rules
  • Create dashboards, alerts, and reports in real time with no coding using Business Activity Monitoring (BAM)
  • Implement SOA Services with Web Services Manager
  • Manage and monitor integration flow with Enterprise Manager
  • Use Adapters to connect to enterprise applications
  • Convert complex point-to-point application integration into simplified, agile, and reusable shared service application infrastructure with Service Bus

What will we cover?
This boot camp is an ideal starting point for an implementer who is planning to learn Oracle BPM Suite 12c and use it on BPM projects. The course provides a combination of lecture segments that present conceptual and feature background and hands-on labs that provide practice with the tooling.
It introduces process developers to Oracle BPM Suite 12c. It covers the key concepts, features and processes needed to begin using the design-time and run-time capabilities on BPM projects. Throughout the training, you will benefit from hands-on exercises based upon two case studies. At the conclusion of the course, you should feel comfortable to start using BPM Suite 12c for process modeling, simulation, analytics, business rules and human workflow.
Learn To:

  • Use BPMN modeling notation to document business process
  • Simulate a process model to identify bottlenecks
  • Create business rules that condition flow through a model
  • Develop a sophisticated human workflow task routing
  • Define key performance metrics
  • Build a dashboard containing charts that show key performance metrics
For details please visit the registration pages

Feb 19, 2018 – Mar 16, 2018 or

Apr 02, 2018 – Apr 27, 2018

For details please visit the registration pages

Feb 19, 2018 – Mar 16, 2018 or

Apr 02, 2018 – Apr 27, 2018

For additional training please see the community training calendar (membership required).

Integrating with Oracle Field Service Cloud using ICS REST adapter by Shreenidhi Raghuram


Oracle Field Service Cloud (OFSC) helps transform Customer Experience by building efficient field service solutions. It is built on time-based, self-learning, and predictive technology. Oracle Integration Cloud Service (ICS) provides the Oracle Field Service adapter (OFSC adapter) to create inbound and outbound integrations with OFSC. Refer here for OFSC adapter documentation.

The OFSC adapter can be used to create integrations using OFSC as ‘invoke’(outbound into OFSC) and/or ‘trigger’(events flowing from OFSC into ICS). This native OFSC adapter exposes a rich set of operations(for outbound) and events(inbound) for most commonly used business objects. Refer to the below 2 links for the Business Objects and operations/events provided by the OFSC adapter

  • OFSC Invoke operations – link
  • OFSC Trigger events – link

However, OFSC provides a myriad of other REST operations (refer the REST API doc) that can be used to access data stored in Field Service Cloud and integrate with other systems.

This blog will provide details on how the ICS generic REST adapter can be used to build ICS integrations to OFSC.

Using ICS REST adapter with OFSC

The next 3 sections will walk through the REST connection,  Invoke and Trigger configurations required to connect to OFSC using REST adapter. Read the complete article here.

Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service by Serene Tan


In this blog, we will use Oracle Managed File Transfer (MFT) and Integration Cloud Service (ICS) to automate batch uploads into Oracle ERP Cloud. We will perform this upload with invoices, a typical use-case for organisations that work with numerous vendors and would like their vendors to bulk invoice them through say an SFTP file drop.

Steps are as follows:

  1. Drop the file into an SFTP folder that is managed by MFT
  2. MFT picks it up and uploads it into ERP Cloud’s WebCenter Content file repository
  3. MFT calls ICS to trigger a multi-step orchestration to load ERP Cloud
  4. Using the ICS ERP Cloud adapter, the ICS orchestration first loads the file into staging tables and import the invoice into final tables

Folks who have read my previous blog, Using MFT Cloud Service to Automate HCM Batch Uploads – Part 1 will notice how similar this is to HCM Data Loading, except that we use ICS to orchestrate a few post-load steps.

That is because HCM and ERP Cloud (also SCM and SalesCloud) are all Oracle Fusion Applications, modules built on the same platform. Some of you may even be on “Global Shared Instances”, essentially running both your HCM and ERP SaaSes in the same instance. Read the complete article here.

Using Oracle Managed File Transfer (MFT) to Push Files to ICS for Processing by Sherwood Zern



In a previous article I discussed the use of the Enterprise Scheduler Service (ESS) to poll for files, on a scheduled basis, to read from MFT.  In that article we discussed how to process many files that have been posted to the SFTP server.  At the end of that article I mentioned the use of the push pattern for file processing.

This article will cover how to implement that push pattern with Managed-File Transfer (MFT) and the Integration Cloud Service (ICS).  We’ll walk through the configuration of MFT, creating the connections in ICS, and developing the integration in ICS.

The following figure is a high-level diagram of this file-based integration using MFT, ICS, and an Oracle SaaS application.

Create the Integration Cloud Service Flow

This integration will be a basic integration with an orchestrated flow.  The purpose is to demonstrate how the integration is invoked and the processing of the message as it enters the ICS application.  For this implementation we only need to create two endpoints.  The first is a SOAP connection that MFT will invoke, and the second connection will be to the MFT to write the file to an output directory.

The flow could include other endpoints but for this discussion additional endpoints will not add any benefits to understanding the push model.

Create the Connections

The first thing to do is the create the connections to the endpoints required for the integration.  For this integration we will create two required connections.

  • SOAP connection.  This connection is what will be used by the MFT to trigger the integration as soon as the file arrives in the specified directory within the MFT (This will be covered in the MFT section of this article).
  • SFTP connection: This connection will be used to write the file to an output directory within the FTP server.  This second connection is only to demonstrate the flow and the processing of the file and then writing the file to an endpoint.  This endpoint could have been any endpoint, to invoke another operation.  For instance, we could have used the input file to invoke a REST, SOAP, or one of many other endpoints.

Let’s define the SOAP connection. Read the complete article here.