| Nov 24, 2017
This spells out the Oracle Developer Community Asia-Pacific ACE Director Tour 2017, thankfully we can put a lot of abbreviations in there, because that is a long name. So I went on the ODC APAC ACED Tour 2017, altho I only did one third of it, I visited both New Zealand and Australia. Being in the great company of Debra Lilley, we travelled to Wellington, Auckland & Sydney, to spread the word about the (more...)

Jarvis Pizzeria: Notification Task in PCS

| Nov 19, 2017
So far we have covered most standard components of the PCS suite. However, we haven’t looked at the “Notification Task” in-depth yet. We have used the on-premises variant at various projects but it was the hassle of setting up the User Messaging Service (UMS) that made you reluctant to use this feature on beforehand. Will the PCS variant be a gamechanger? Let’s find out!
We implemented a basic process with a standard notification task and (more...)

Jarvis Pizzeria: Workaround for XSD list-element issue in WebForm

| Nov 12, 2017
In a previous blog we have made notices that it is not possible to create a Webform based on a xsd-type that contains a list elements. In our case a list of pizza ingredients.
In this post we will give an alternative way to create a webform that displays the data, including the list of ingredients. For this we have created a new form IngredientsWebForm.
As we tried before, It does not work to drop (more...)

Jarvis Pizzeria: Human Tasks: Design First WebForms in PCS

| Nov 5, 2017
To create simple Human Tasks we use web forms in Process Cloud Service (PCS). Within the Delivery Process of the Jarvis Pizzeria, we are going to implement the HT for ‘Try Contacting the Customer’. This human task should become available after we have checked that the Customer is not a member and we do not know his email address.  
Try contacting the non-regular / member from Jarvis Pizzeria, in the swimlane of the CallCenter.

The APPROX_MEDIAN Function – A Test Case

The aim of this post is not to explain how the APPROX_MEDIAN function works (you find basic information in the documentation) but to show you the results of a test case I run to assess how well it works.

Here’s what I did…

I started in the Oracle Database Public Cloud an instance of version 12.2.

Then I created a table with several numerical columns (the name of each column shows how many (more...)

Jarvis Pizzeria: Handle SOAP Faults within PCS

| Oct 29, 2017
As we are very optimistic developer we started out with modeling and testing the happy flow of our Jarvis pizzeria. But as experience learns it is the big bad world that obliges us to deal with both expected and unexpected failures. This blog post we will look into the handling of SOAP faults that PCS has to offer out-of-the-box.

As a starting point we have created a basic process with one service call:
This SOAP (more...)

Jarvis Pizzeria: Test against the Development or Production environment

| Oct 23, 2017
Within PCS there are actually two different environments, a development environment and the production environment. Once you have deployed your application it is available in the production environment as a certain version of the application. However, you might want to test your application before you deploy a new version. You can also test your environment against the so called ‘development environment’.

The blue button bar has a Test as well as an Deploy button on (more...)

VBCS: Action Handlers, send an email

| Oct 18, 2017
Within VBCS, Virtual Builder Cloud Service, you can add custom actions in menus or on buttons. We will explore this feature in this blog by allowing people who visit our Tech17 application to send an email to a speaker.

Within the REST service, I added the email field, so it does now come back in the collection as well. I changed the extension and business objects accordingly, I will not cover that in this blog (more...)

Jarvis Pizzeria: Using an imported XSD in PCS

| Oct 15, 2017
In the post ‘Import the 12c On-premises Preparation Process’ we saw the Business Types that were imported (also shown here)
We already stated that we had an issue with enumerations. But is this the only issue with the xsd? Unfortunately not, as will become clear soon.
Making task forms was not part of the import blog, however, in this blog we are going to do this. We will do this based on the (more...)

VBCS: Integrate VBCS with PCS

| Oct 11, 2017
The integration between VBCS (Visual Builder Cloud Service) & PCS (Process Cloud Service) is getting a lot better, you can now create and start processes from within VBCS. It is also possible to create a tasklist or task screens within VBCS. In this blog I will show you how to set up VBCS to be ready for these features as well as how to create a process and tasklist connected to this process. 

In (more...)

Jarvis Pizzeria: Deployment and using the workspace

| Oct 9, 2017
Having played around with all the features PCS has to offer it is now time to see some action. In this blog we will show you how to deploy your application, start the application and see how it behaves within the workspace.

But first of all, we need to have a application that is ready to deploy. In other words, our minimal deployable product consists of an application without any errors. Pressing the validate button (more...)

Jarvis Pizzeria: Using the REST interface to start a Process

| Oct 2, 2017
In this previous blog, we already explained how you can start your process from a SOAP interface. It is also possible to do this with a REST call. For this you need to find out a couple of things about your process after which you can do a post on the Oracle API to start the process. You can use any REST client you want, in this example we use Postman.
First of all, you (more...)

CIDR for Dummies DBA in Cloud

For DBAs of Cloud, its imperative to learn various networking concepts and CIDR is one of them. Without going into much detail, I will just post here quick note as what CIDR is and how to use it.

A CIDR looks something like this:

The represents range of IP addresses, and no its NOT from to Here is what (more...)

VBCS: See all Projects

| Sep 29, 2017
When you are collaborating in VBCS, Visual Builder Cloud Service, it can be tricky when you work together on one identitydomain. For example, Daphne created an application for us to demo on OOW17 since she is doing the first part of the demo and was testing our demo script. Now that she is done, I can take over and prepare the second part of the demo script.

However, where is the application? I only see (more...)

Jarvis Pizzeria: Using the SOAP interface to start a Process

| Sep 26, 2017
We as old-fashioned SOA/BPM Suite developers, are used to test deployed services using tools like SoapUI. In this blog post, we will show you how to start a Process in the Oracle Process Cloud from the SOAP UI interface.
On premises with SOA or BPM we used to start by obtaining the required wsdl from the Enterprise Manager.
However, for PCS there is no such thing as an Enterprise Manager, so how do we get (more...)

Jarvis Pizzeria: Decision Model in the Delivery Process

| Sep 17, 2017
To make the delivery of the pizzas to our customer, we need to decide how to deliver the pizzas. In our process we’ve already got the order data, so we know what the order is and where it needs to be delivered, but what is the best way to deliver the pizzas?
We will create a decision model in PCS to help us with this decision. In the delivery process we will call the decision (more...)

Jarvis Pizzeria: Implementing Rules

| Sep 10, 2017
When the order comes in, payment needs to be made first before we start preparing the pizza. Our order payment process supports three possible payment options:
  • Creditcard: obviously a commonly accepted payment option
  • Cash: although we are a very tech-savvy company we would also like our old-fashioned customers to be able to pay the pizza with cash money
  • Deferred payment: our most trusted customers can pay their order in a deferred way.  Deferred payment means (more...)

VBCS: Calling a REST endpoint

| Sep 8, 2017
Oracle Application Builder Cloud Service (ABCS) has been renamed to Visual Builder Cloud Service (VBCS), so this blog series about ABCS continues as a blog series about VBCS. In this blog I will explain how to call a REST endpoint and create a Business Object based on this REST Service. There are several ways to do this, but I will start with the most basic one. The data that we get from the REST service (more...)

Jarvis Pizzeria: The Document Only Delivery Process

| Sep 3, 2017
Let's have a look at the Delivery Process of the Jarvis Pizzeria. In this blog post, we will explain the functionality of the Delivery Process with the help of the Document Only feature when creating a new process.

When we create a new process we can select the option ‘Document Only’ in the Create Process popup.
Document Only processes are for descriptive use only and are not part of the working and running application. It (more...)

Jarvis Pizzeria: Import the 12c On-Premises Preparation Process

| Aug 28, 2017
In the Functional description of the Preparation process we stated that we would describe all steps required to migrate a sample 12c preparation process to PCS. So let’s get started.
As a starting point, we have the 12c on-premises preparation process as exported application. A picture of the BPM process is shown below.

The first attempt: directly import the exported file in PCS.

In the Composer select Import Model from the hamburger menu at the (more...)