Category Archives: Common

Common Middleware Subjects

Fusion Middleware Partner Community Forum XX

Oracle Partner Community Forum

During the 1st week of March I had the pleasure of visiting the beautiful city of Budapest. Location of the 20th(!!) Oracle Fusion Middleware Partner Community Forum (#ofmForum). More than 180 delegates from more than 30 countries will visited the Boscolo Hotel Conference Center to share, learn and network with other Fusion Middleware minded. Oracle offered a great package for staying in the Boscolo hotel where the conference was, however in this era of “digital disruption” I decided to book a AirBNB appartment just 1 block from the hotel.

Boscolo hotel

Boscolo hotel


Day 1:

Oracle ACE briefing
Due to the amount of Oracle ACEs in Budapest, Jürgen Kress organized a sort of EMEA Oracle ACE briefing session. Where the ACE community had the opportunity to talk to both keynote speakers Andrew Sutherland and Amit Zavery. The topics where current and near-future Oracle Fusion Middleware products and PaaS Cloud Services.

Oracle Platform as a service (PaaS)

After Jurgens welcome speech it is time for Oracle Amit Zavery to start the community forum with a keynote. His session explains the Oracle Fusion Middleware strategy which (no surprise here) is cloud, cloud and some more cloud. Or as Amit stated himself: “Cloud is pervasive across everything we do at Oracle these days”. Cloud Platform for the digital business, was a phrase used multiple times.

Oracle Fusion Middleware Update
Andrew Sutherland (Senior Vice President of Technology and Systems) takes us on the trip explaining the digital disruption taking places in numerous markets at the moment. Think of websites/services like AirBNB, Spotify, Uber that are immediate threats to the current order counterparts. Board rooms should be scared of Digital Disruption. Digital Business needs both speed and agility. Modern business is all about real time and we should avoid processes which depends on batches.

SOA Suite 12c & cloud platform
The session explained important elements of service integration with both the current Oracle SOA Suite 12c and the future roadmap for Oracle towards the cloud. Including a sneak peek to the soon to be released Integration Cloud Service (ICS). The session also allowed for a great presentation (and live demo) about Stream Explorer 12c by Oracle ACE Director Lucas Jellema.

BPM Suite 12c & cloud platform
With the release of Oracle BPM 12c some new features were added to allow better (web based) modelling and on the other hand improve developer productivity. Not strange, since the same web interface will be used for the soon to be released Process Cloud Service. The session also allowed us to get a sneak peak of the new Process Cloud Service which is a fully self-service, PaaS service on the Oracle Public Cloud that allows for complete life cycle management of processes.

Social Event @ Spoon Budapest
The (official) part of day 1 ended with a dinner hosted by Oracle at the Spoon restaurant boat in the Donau river. While meeting old friends (and creating new ones) enjoying the fantastic diner with a marvelous view on the Buda Castle.

Spoon Restaurant @ Budapest

Spoon Restaurant


Day 2:

API Management (SOA track)
Robert van Molken & Yogesh Sontakke present the Oracle vision on API management.API management is about managing, discover, govern, monitor, and support your business APIs (services). The presenters first showed the highover positioning of products like Oracle API Catalog, Oracle API Gateway, Oracle API Manager & Oracle Service Bus. Later Robert went in depth for us showing details how to use the Oracle API Catalog with a live demo (very brave) and Yogesh did the same with the Oracle API Manager.

Oracle Business Actiivty Monitoring 12c (BPM track)
Mark Simpson explains that BAM is now adopted by the BPM team which shows the strategic focus from Oracle. Oracle BAM 12c is a completely redesigned product that provides real time insight into process. Oracle BAM 12c has some new features as geomaps, multi-browser support (no more IE yeah!), mobile enablement & better role based security options. The session showed different key features in BAM to support 4 important sections of information: Operation Analytics, Business Analytics, Operational Intelligence & Strategic Analytics. Mark also handed us some dashboard d

Oracle ACM Implementation Best Practices (BPM track)
Presented by both Danilo Schmiedel & Andrejus Baranovskis telling their experiences about implementation of ACM at 3 different (insurance) companies. Danilo first started with the characteristics of unstructured processes and the requirements that knowledge workers have on the IT solution. Also the importance of early-on case UI design is essential to achieve insight on business information requirements. Needed for dynamic case management is the definition of your activities, milestones, rules, events, data & case stakeholders. Danilo also mentions the ProM Tools for Process Mining research and extraction of knowledge about a (business) process from its process execution logs. Surely need to look at that. After the session there was a very valuable talk with Dirk Janssen, Harrie van Oosten &  Danilo Schmiedel to share experiences we with the Oracle BPM/ACM implementations in both Germany and the Netherlands.

Speaker & ACE Dinner
Finalized my stay in Budapest with a great diner in the hills of Buda.


Leave a comment

Posted by on 12-03-2015 in Common, Events


Tags: ,

Transformation on XMLType in Oracle XML DB

When using a XMLType table/column in Oracle XML DB to store structured data you are able to perform transformations with the XMLTRANSFORM command. We have a requirement to remove all namespaces for the inserted XML content and decided to implement this mechanism in the database.

Probably piece of cake for a Oracle XML DB guru, I needed Google ;-)


We insert the XSLT stylesheet for removing namespaces in the table:

values ('REMNAM' ,'
<xsl:stylesheet version="1.0" xmlns:xsl=>
<xsl:output indent="yes" method="xml" encoding="utf-8" omit-xml-declaration="yes"/>
<xsl:template match="*">
<xsl:element name="{local-name()}">
<xsl:apply-templates select="@* | node()"/>
<xsl:template match="@*">
<xsl:attribute name="{local-name()}">
<xsl:value-of select="."/>
<xsl:template match="comment() | text() | processing-instruction()">

Then we create a trigger to

create or replace
-- remove namespaces from XMLTYPE input
-- DBMS_OUTPUT.PUT_LINE(:new.data_xml.GetClobVal());
SELECT XMLTRANSFORM(:new.data_xml, x.stylesheet)
INTO :new.data_xml
-- DBMS_OUTPUT.PUT_LINE(:new.data_xml.GetClobVal());

Let’s test the trigger:

values ('
<bk:book xmlns:bk="" xmlns:isbn="urn:ISBN:0-395-36341-6">
<bk:title>Cheaper by the Dozen</bk:title>

When enabling the DBMS_OUTPUT lines we are able to validate the result of the trigger.
JDeveloper DBMS output

Leave a comment

Posted by on 13-08-2013 in Oracle, XMLDB, XSLT


Tags: , , , ,

Oracle BPM / ADF integration Best Practices (#oow)

Last OOW I visited the presentation of Danilo Schmiedel (blog & twitter) and Andrejus Baranovskis (blog & twitter) covering the topic “Oracle BPM & Oracle ADF” integration best practices. With my experience in BEA AquaLogic BPM 6 and Oracle BPM 10 the ADF integration in 11g was all new for me, so with just playing around with it I was very interested in the best practices.combining these 2 Oracle technologies for rich user interfaces.

So last month we started our Oracle BPM 11g project and during “sprint 0” we came to the conclusion that we would have long-running instances with a lot of human interaction and discussed the look-and-feel posibilities with our teams user experience expert. So a good time to look back upon the best practices from both gentlemans. So we used their presentation and advice to discuss the option of creating a generic ADF human task handler.

Check out Danilo’s blogpost about their presentation yourself and off course the presentation on slideshare.

Leave a comment

Posted by on 30-10-2012 in Events


Tags: , , ,

Oracle Open World 2012 – it’s a wrap !

After 5 days with many sessions, keynotes, hands-on-labs and even more parties we can call it a week. Fantastic meeting old and new colleagues/friends/partners and more.

Oracle Open World 2012 ended with a blast! While the blue angels made a fly by above Yerba Buena Gardens the Swedish garage rock band The Hives showed the Oracle crowd why they won awards for being the best live act.

Tomorrow we will return home, hoping to see you all again next year!

Leave a comment

Posted by on 05-10-2012 in Events, Oracle


Tags: ,

Oracle Open World 2012 Wednesday

4th day of the Oracle Open World conference and today my amount of sessions visited was clearly decreasing.

CON7344 – Anatomy of a Scalable Oracle BPM Suite 11g project

The session gave a lof of tips and best practices for running a BPM project in general (not purely Oracle BPM as a product).

Typical issues you may run into during your project:

  • Weak solution design: one super composite with 40+ components, no versioning and archiving strategy
  • Weak preparation of business: task unattended when someone leaves, no process monitoring
  • Weak operational: missing fault handling, no end-to-end monitoring

Mitigate that risk in your project:

  • Sit and think before you build: distinguish micro-process vs enterprise grade processes: Solution architecture & design, define guidelines
  • Engage early with business: demo simple prototype, play sandbox, ask the right questions
  • Engage early with infra: layout infra, control with enterprise manager 12c

Process definition:

  • Identify human task detaiuls: in/out documents, in/out business terms, assignemt patterns, role and mode, escalation rules, out-of-office policy
  • Identify business rules task details: in/out payload, decision table, rule manageability
  • Identify service task details: service and operation, in/out payload

SOA reference architecture. Lessons learned. No super composite.

Consistent developer: same jdev, same jdk, same parameters, build en deploy tools (maven)

Creating human tasks:

  • Make sure to always decouple human task complex payload from the process: use keys in the process, pass it to the human task. Do NOT import complex models (large xsds as human task payload), implement proper validation, leverage validation callback.
  • When assigning task to a performer: always use group assignments mapped against authorization repository, or leverage oracle entitlement server.
  • Always use a process ownmer, so unattended tasks can be rerouted to the owner
  • Leverage mapped attributes for business convenience

Fault handling:

  • Types of bpmn exception: Business exception (user defined exception)
  • Fault policy: catch system exceptions
  • How to define: composite based, component based, reference based

Oracle Open World youtube channel

The keynotes and interviews from OOW 2012 are available on the official Oracle youtube channel. One session that I missed but watched on this channel myself was quit interesting, the movie is called ‘Oracle Fusion Middleware Strategies Driving Business Innovation’

Oracle Partner Network @ OOW

Visited the Oracle Partner Network lounge in Moscone South and talked with some other Oracle partners who also visited Oracle Open World this year.

Appreciation Event @ Treasure Island

Highlight of this years Oracle Open World was obviously the appreciation event held on wednesday evening. As always the event is arranged perfectly with massive amounts of people traveling to and from Treasure Island, and of course the huge amount of food and beverage being offered to all the attendees.

Kings of Leon:

and of course legendary Pearl Jam:

Pearl Jam closing the night with a fabulous tribute to The Who with their song Baba O’Riley !!!


1 Comment

Posted by on 04-10-2012 in Events, Oracle


Tags: ,

Oracle Open World 2012 Tuesday

Not much session today but watched 2 keynotes, walked the demo grounds and attended only 1 Oracle BPM/ADF session which was very good.

CON2787 – Oracle BPM & ADF Integration Best Practices

Very good session by Danilo Schmiedel and Andrejus Baranovskis explaining the best practices for the intregration points between Oracle BPM and Oracle ADF. By default you can use the BPM workspace application or create a custom ADF application where you need to import the BPM workspace JAR libraries. Session started with explanation about the complexity challenges both gentlemen had at their project. A project where long running processes where created, each with a huge amount of human tasks and a load of over 300.000 instances/year.

To prevent creating huge amounts of ADF artifacts for each human task, they created a common data model for the human tasks and use standardization. The generic ADF Human Task Handler then uses routing on security groups an generate/render the correct options (buttons) for that task based upon an external configuration. I found this very interesting and need to look into this further when back home.

During the session some administrative reminders where made about the complex Oracle BPM environment as it existed in their project. “Housekeeping” was the term used, and reminded us to monitor the filesystem, configure Enterprise Manager correctly, arrange proper monitoring, use JRockit Mission Control for tuning and manage the database growth (MDS / SOAINFRA). Make sure you think about purging and read the Oracle Fusion Middleware administration guide about managing database growth.

KEY10724 – Oracle OpenWorld Keynote: Oracle and Infosys

The keynotes on tuesday are something to look forward to. Due to the perfect weather in San Francisco we enjoyed watching them from the Yerba Buena Garden. The keynotes started with Infosys and friends, but finally the big man himself came on stage. You can watch his keynotes on youtube:

Oracle Benelux Party @ Ruby Sky bar

Ended the night in style in one of the hottest clubs in San Francisco, the Ruby Skye. The event was open for Oracle customers, partners and employees from the Benelux region. Party made possible by the Oracle partners VXCompany and Qualogy.

Leave a comment

Posted by on 03-10-2012 in Events


Tags: ,

Oracle OpenWorld 2012 Monday

This monday morning Oracle OpenWorld kicks off with the keynotes “Shift Complexity” which we enjoyed watching outside in the Yerba Buena Gardens at Moscone. Most interesting information during the keynote was the announcement of the ExaData hardware update and a preview of Oracle Database 12c.

CON9245 – Oracle FMW Upgrade: Best Practices and Strategy

Session explained the upgrade path from different Middleware 10 products to version 11g. Amongst others Oracle Portal, OID Suite, OIAM Suite, SOA Suite and Weblogic. The session had an overview of all documents available for upgrading, the different tools you as an administrator have at your disposal to perform the upgrade, the right steps during the upgrade. Especially the SOA Suite (BPEL) upgrade was interesting about different strategies for long running BPEL instances.

CON8475 – Oracle Unified BPM Suite 11g Overview and Roadmap

Overview of Oracle BPM PS6 ( and it’s new features. Especially the Business Process Composer was extended with new kind of features for the Business Analist role in your BPM project. The Business Analist now has the opportunity to simulate the process and play the process using different stake holders (without logging in and out under different users/roles). Another new feature is the possibility for the analist to model the forms used for the process it’s human interaction. More enhanced business rules usage and option for rule testing again in the composer. Another cool feature was the improvement of alter flow, which allows you to suspend a process, change data and move instance forward or backward from the workspace.

The Demo Grounds:

Visited the demo grounds and especially the Oracle Middleware DEMOgrounds. Got some free goodies like a Han Solo icecube maker. Basicly a must-have for the modern man these days. ;-) Very interesting information and had a good discussion and helpful hand at the BPM Process Accelerators part.

CON8669 – Using the Right Tools, Techniques & Technologies for Integration

Session explains the position of both BPEL and BPMN as language (and Oracle product) for process automation. BPEL is there for service orchestration and BPMN is a process execution standard with focus for human interaction. Consider both BPEL and! BPMN for handling your automated processes.

Overview of the different Oracle service brokers:

  • (Vordel) Enterprise gateway, as first line of defense located in a DMZ
  • OSB: stateless, high speed transformation and routing, service result caching (with Coherence)
  • Mediator: SCA, re-sequencer, transform/filter, state full

Integration styles recognized:

  • data centric integration
  • integration through native interfaces (adapters)
  • integration through web services
  • reference data query
  • process centric integration

Best practices as Common/Canonical Data Model (CDM) are explained and the use of design patterns and reference architecture.

Important announcements:

  • Oracle Database 12c is coming … not yet, but soon :)
  • Oracle Exadata X3 Database In-Memory Machine is announced
  • Oracle has a deal with Nokia about their Location Platform (map software) which will be available for developers in Fusion Middleware MapViewer
  • Oracle Coherence 12c is announced


Leave a comment

Posted by on 02-10-2012 in Events


Tags: ,