Development and Runtime Experiences with a Canonical Data Model Part II: XML Namespace Standards

This blog is about XML namespace standards. Primary for using them in a Canonical Data Model (CDM), but also interesting for anyone who has to define XML data by creating XML Schema files (XSD). This blogpost is the second part of a trilogy about my experiences in using and developing a CDM. The first blogpost is about naming & structure standards and the third blogpost is about dependency management & interface tailoring.

XML Namespace Standards


Development and Runtime Experiences with a Canonical Data Model Part III: Dependency Management & Interface Tailoring


This blogpost is part III, the last part of a trilogy on how to create and use a Canonical Data Model (CDM). The first blogpost contains part I in which I share my experiences in developing a CDM and provide you with lots of standards and guidelines for creating a CDM. The second part is all about XML Namespace Standards. This part is about usage of a CDM in the integration layer, thus how (more...)

OUG Ireland 2017 Presentation

Here are the slides from my presentation at OUG Ireland 2017. All about running R using SQL.

Oracle Application Express (APEX) 5.1.1

I read Joel Kallman’s post this morning announcing the release of APEX 5.1.1. We’ve got APEX 5.1 across the board, so I downloaded patch 25341386 from MOS, as instructed, and went to work patching stuff.

The patching was just like every other patch I’ve done for APEX (see here), super easy. 🙂

I thought there was a problem with the APEX images, but it turned out I was a donkey and I’d copied (more...)

Running Oracle REST Data Services (ORDS) Without Oracle Application Express (APEX)

Can you? YES. Absolutely, even. No mention of APEX – not that that’s a bad thing. Go from your app to your Oracle Database resources via REST (GET|POST|PUT|DELETE), and your responses come back via JSON. No APEX required. Ok, but what about ORDS & APEX? If you want to provide a RESTful API for your... [Read More]

Webcast: “12.2 Technical Upgrade Overview and Process Flow”

EBS 12.2 upgrade webcastOracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for an overview of how to optimize your EBS 12.2 installation, see:

Udayan Parvate, Senior Director Release Engineering, Quality and Release Management, shares a high level overview of the 12.2 technical upgrade and the sequence of technical steps to follow in the 12.2 upgrade process. This (more...)

Apex patch for 5.1

If you are running Application Express, there is a new patch available.  Lots of fixes which you can read about here

I just downloaded patch 25341386 and followed the installation instructions and it went through with no problems at all in just a few minutes.

Verifying Application Express version...
...have version

PL/SQL procedure successfully completed.

Verifying Application Express version...
...have version (more...)

Frequent APEX questions

I've put a call out on the OTN APEX forum asking for suggestions from the community on what they think are frequent APEX questions, be it within the forum or elsewhere.

In part, I'm chasing ideas for content in future presentations, or blog posts. I welcome others to do the same. I think if we share our perception of common questions, better resources will come.

So please, feel free to contribute in any way, shape, (more...)

Take a few minutes to patch Oracle APEX 5.1

Yesterday a first patch set of Oracle Application Express (APEX) 5.1 has been made available to patchesIf you encounter issues, you can ask for support and most likely a bit later a patch is made available through The APEX team is doing a great job with this.For example some people... [Read More]

Take a few minutes to patch Oracle APEX 5.1

Yesterday a first patch set of Oracle Application Express (APEX) 5.1 has been made available to download.

one-of patches

If you encounter issues, you can ask for support and most likely a bit later a patch is made available through The APEX team is doing a great job with this.

For example some people using APEX Office Print had an issue which was caused by a bug in APEX_JSON (more...)

Make Radio Group look like UT Buttons

It's pretty easy to convert links in APEX reports to use the Universal Theme button look & feel, as I described here

We can apply the same technique to radio groups, but it requires a little more work than just adding some classes, but nothing like jQuery mobile radio fiddles.

It took me a few goes to get the correct string in the correct APEX attribute to make the individual buttons (more...)

What is a figure without any context?

We are currently living in the information age. Several devices, (mobile) applications and computer programs are generating and collecting lots of data. A lot of decisions are made based on a “gut feeling“. In a lot of cases, this will not be any problem. If you cannot trust your gut, who or what can you … Continue reading "What is a figure without any context?"

Apex 5.1.1 released

| Mar 29, 2017
The latest version of Oracle Application Express has been made available yesterday for download from Oracle as reported by Joel Kallman. As usual a number of issues and bugs have been fixed, read more in Apex 5.1.1 patch set notes. Enjoy.

Index Statistiken und Column Group Statistiken (Extended Statistics)

Nach einiger Zeit widme ich mich mal wieder einem meiner Hobbies: der Zusammenfassung des aktuellen Artikels von Jonathan Lewis. Diesmal geht es darum, dass der Herr Lewis gerne den - von mir häufig wiederholten - Vorschlag macht, bei der Löschung eines aus Zugriffssicht überflüssigen Index entsprechende "extended statistics" für die fragliche column group anzulegen, da der Optimizer die distinct key Angabe eines Index zur Durchführung eines Sanity Checks bei der cardinality-Bestimmung verwenden kann - was (more...)

Five Best Practices for Platform as a Service Success


Research firm IDC estimates that the market for platform as a service (PaaS) solutions will have a compound annual growth rate (CAGR) of 30 percent and reach $14 billion by 2017. PaaS provides application runtime, database, integration, messaging, and other services in the cloud, accelerating application development and reducing infrastructure acquisition and maintenance costs. Here are five best practices for maximizing the business value of your PaaS solutions. Get the report here.

SOA & BPM (more...)

ODPI-C 2.0.0 Beta 2 is out with runtime client linking

| Mar 28, 2017
Anthony Tuininga just released ODPI-C 2.0.0-beta.2 on GitHub. The release notes list all changes. ODPI-C is an open source library of C code that simplifies the use of common Oracle Call Interface (OCI) features for Oracle Database drivers and user applications. It sits on top of OCI and requires Oracle client... [Read More]

See You At Collaborate 2017 Inventory Sessions!

Attending Collaborate 2017 in Las Vegas? So are we! Be sure to check out our two EBS Inventory related sessions.

Learn more about Consignment functionality and tools in our Consignment Inventory as Consignee/as Consignor session, Sunday Apr 2, at 12:30 PM – 1:30 PM, in room Surf A. We'll cover:
  • EBS Proactive Tools for Consignment
  • Best practices for processing Consignment
  • Tips for processing Consignment transactions

Also learn more about WMS and MSCA Tools and Best (more...)

Oracle Application Express 5.1.1 now available

Just in time for APEX World 2017, Oracle Application Express 5.1.1 is now released and available for download.  If you wish to download the full release of Oracle Application Express 5.1.1, you can get it from the Downloads page on OTN.  If you have Oracle Application Express 5.1 already installed, then you need to download the APEX 5.1.1 patch set from My Oracle Support.  Look up patch (more...)

How to Patch an Exadata (Part 6) – Timing

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6



6: Timing

Now that we know how to patch every component and the different options available to do so (rolling, non-rolling), which one is the best? How much time does it take?

The answer is obviously “it depends” but I will try to bring few insights so you can have a (more...)

Oracle Retail Planning and Optimization – 24/7 Digital Training Now Available!

Are you transitioning to Oracle Retail Planning and Optimization? Do you want to plan better assortments and maximize your return on investment?

Oracle University now offers the Oracle Retail Learning Subscription: Planning and Optimization (End User Edition).

Purchasing this learning subscription helps you get the most out of your Planning and Optimization services.

Here are 5 reasons why this learning subscription should interest you.

1) Get 24/7 Access to a Library of Continuously Updated Digital (more...)