Flex fields Mapping Tool by BPM SOA Solutions Team


How many times have you had to repeat the same sequence in the BPM workspace to map a Human Task payload attribute to a public Flex Field? Let's do a bit of re-cap:

  1. login to the Workspace with administration permissions
  2. go do Administration
  3. go to Public Flex Fields
  4. create all Labels

And then, for each human task:

  1. search for the task
  2. choose the payload attribute
  3. search for the label to use (you can create them (more...)

Next Chapter … Time for a Change

It has been about three months since I’ve published a post. Well this time it has been a mix of work and decision making on my next chapter in my career that has kept me from posting. Hopefully, in the near future I will have more time to publish articles on topics I really want to discuss.

For the people close to me, many of you already know what this change is. I appreciate that (more...)

Video : Table Point In Time Recovery (PITR) in Oracle Database 12c

It’s been a while, but here is a the latest video.

If videos aren’t your thing, you can read the articles here.

The star of this video is Uwe Hesse, who I recorded at (more...)

UKOUG Database SIG : See you on the 25th Jan 2017

In about 4 days (Wednesday 25th Jan 2017) I’ll be one of the presenters at the UKOUG Database SIG in Solihull.

I was originally doing a single session, but someone pulled out so Patrick asked if I could fill in.

I’ve spent this morning bringing my slides and some related articles up to date, so I think I’m ready to go! 🙂

I did a talk at work last week, which was my first presentation of the year, (more...)

Unable to compile a composite that contains a Java embedded activity with Maven by Markus Lohn


Maven is not compiling the composite when a BPEL process contains java embedding. Just incorporating java embedding makes the maven compilation to fail. If the java embedding is removed then the composite compilation is successful in Maven. This issue can be reproduced  with JDeveloper 12.1.3.x


First I tried to solve this issue by adding dependency declarations for orabpel.jar in the soa maven plugin section and the pom.xml itself. (more...)

Auditing Oracle database stopping and starting using the ELK stack

This blog post is about two things: one how you can monitor who is bringing you database up and down (there is a twist at the end!) and two how you can very conveniently do that with aggregated logs in a browser with a tool called ‘Kibana’, which is the K in ELK.

What is the ‘ELK stack’?
The ELK stack gets it’s name from Elasticsearch, Logstash and Kibana.
– Elasticsearch is an open (more...)

What’s New With Oracle Certification – January 2017

Stay up to date with the Oracle Certification Program, view exams released into production, get information on current promotions and learn about new program announcements below.

Now Available in Beta:

1Z1-070 | Oracle Exadata X5 Administration (Ends Jan 31, 2017)

Oracle Exadata X5 Administration covers Exadata Database Machine features and configurations, Exadata Storage Server, migrating to the Database Machine, and maintaining, monitoring and optimizing the Database Machine after initial configuration. A candidate passing the exam (more...)

Free PaaS trial services & certification for Oracle Partners!

Dear Integration Experts

As an Oracle Partner Network Gold member or higher we would like to offer you:

  • free ICS trail services
  • free ICS certification

As a community member you receive also our monthly updates with the latest PaaS information including sales &  marketing kits, product updates and trainings. Please first login at Oracle Partner Network and then visit SOA Partner Community. (more...)

onecommand fails to change storage cell name

It’s been a busy month – five Exadata deployments in the past three weeks and new personal best – 2x Exadata X6-2 Eighth Racks with CoD and storage upgrade deployed in only 6hrs!

An issue I encountered with the first deployment was that onecommand wouldn’t change the storage cells names. The default cell names (not hostnames!) are based on where they are mounted within the rack and they are assigned by the elastic configuration (more...)

EMCLI: Add a Database Target with Specific DB System Name

On Oracle Community forum, I’ve seen a good question about using EMCLI to add targets. The forum user says that they decided to name the database targets with combining db_name and hostname. As you may know, when you add a database target, EM also creates a database system for the new target (or assign it with an existing one). The new database system’s name is generated by adding “_sys” to the database target name. Let’s (more...)

PCS 16.4.5 New Features incl. Quickstart Masters, Automated Archive & Purge, REST connectors… by Niall Commiskey

imageLots of great new features, just in time for the Holiday Season.
Thanks to my colleague Kathryn L.
I will be adding to this post over time, so, currently, it is not an exhaustive list.

1. Ability to see Conversations in Tracking

Note: the second icon on the right, under the docs icon.

2. Quickstart Master new functionality

For those of you who have yet to meet a Quickstart Master - here's a quick intro.


Oracle VAR_POP Function with Examples

This article will explain the Oracle VAR_POP function and show you some examples. Purpose of the Oracle VAR_POP Function The VAR_POP function finds the population variance of a set of numbers, excluding NULLs. What does this mean? The population variance is a calculation that determines the difference or variation in a complete set of numbers. […]

Decipher EBS Product Prefixes with EBS Technical Reference Manual

Oracle E-Business Suite is a collection of over 200 individual products.  These products are grouped into product families such as Financials, Supply Chain Management, Human Resources, and so on.  Each product has its own ID, officially called an "Applications Product Prefix." Product prefixes can be either two or three characters in length.

If you're looking at a patch's README or some technical documentation, you might see a product ID that you don't (more...)

The Hottest Tech Skills for 2017

Written by Nicole Fornacon, Oracle University Marketing Director, EMEA/APAC

New year, new you, new job?

2017 is here, and if your New Year’s resolution includes a career shift, a promotion or even landing your first job, then it's crucial to be aware of the skills employers seek.

To find out exactly which skills employers are looking for, and what it takes to successfully land a job, LinkedIn examined billions of data points and analyzed hiring (more...)

EBS 12.1 Data Masking Template Certified with EM 13c

We're pleased to announce the certification of the E-Business Suite 12.1.3 Data Masking Template for the Data Masking Pack with Enterprise Manager Cloud Control 13c. You can use the Oracle Data Masking Pack with Oracle Enterprise Manager Cloud Control 13c to mask sensitive data in cloned Oracle E-Business Suite environments.  Due to data dependencies, scrambling E-Business Suite data is not a trivial task.  The data needs to be scrubbed in such (more...)

Oracle buys Apiary

On January 19, 2017, Oracle announced that it signed an agreement to acquire Apiary, which creates the most comprehensive API Integration Cloud by adding the leading API design and governance solution. The proposed transaction is subject to customary closing conditions. Until the transaction closes, each company will continue to operate independently.

Apiary's pioneering APIFlow solution provides the framework and tools for developing application programming interfaces (APIs) that share enterprise services and data and help create (more...)

Oracle E-Business Suite Adapter and Integration Cloud Service

[Guest author: Rekha Ayothi]

I wish you all a very happy New Year!

In my previous article, I gave an overview of Oracle Integration Cloud Service (ICS) and Oracle E-Business Suite Adapter. In this article, I will focus on integrations using EBS Adapter.

Usually, integrations include a source (or trigger) connection that sends a request or message to ICS, and a target (or invoke) connection to which ICS sends a request or message. For (more...)

Oracle VAR_SAMP Function with Examples

In this article, I’ll explain the Oracle VAR_SAMP function and show you some examples. Purpose of the Oracle VAR_SAMP Function The VAR_POP function will return the sample variance of a set of numbers, after excluding NULLs. What does this mean? The sample variation calculates the variation of a sample of numbers from the overall set. […]


Dear SOA & BPM Partner Community,

Want to try Oracle PaaS solutions hands-on? Make sure you attend the PaaS Partner Community Forum which takes place March 27th & 28th & 29th 2016 in Croatia. During the Community Day partners will share their best practices and details about successful cloud implementations. Join us for a week full of keynotes, breakouts, hands-on sessions and networking opportunities.

On a regular base new versions of the (more...)

JRE 1.8.0_121 Certified with Oracle EBS 12.1 and 12.2

Java logo

Java Runtime Environment 1.8.0_121 (a.k.a. JRE 8u121-b13) and later updates on the JRE 8 codeline are now certified with Oracle E-Business Suite 12.1 and 12.2 for Windows desktop clients.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the (more...)