Skip to main content

Oracle SOA Database Adapters provide a polling mechanism that will periodically query a table to see if a there is a new or changed record.  If so, it can trigger a BPEL process.  This is enormously useful.  However, on one client I ran into a series of issues with database pollers in a clustered environment when they … collided.  (queue dramatic music)

A tenet of any integration toolset is the ability to interact with databases. With standards in place, this for the most part is fairly easy. But sometimes, the particulars of a database can create some unexpected complexity. One example of this is an integration solution developed within Mulesoft that invokes Oracle PL/SQL stored procedures and functions. In this scenario, knowing about some of the complexity beforehand will ensure less frustration by a developer during the development phase.

Invoking Oracle ACM from a web service call is not difficult but unfortunately is also not well documented.  I know … you’re shocked. 

To explain this as simply as possible, let’s use a Loan Origination process as a prototypical ACM example to review the high-level steps.

In this 11g process example, we’re invoking ACM from a CRM system via a web service call.  The web service will invoke a BPEL process which does the following:

The more rigid an organizational structure becomes, the more hindered its teams will be.  Agile should not lead to fragility, but should empower teams to create independently in an iterative framework.  Anything less just isn’t Agile.  
The citizen developer is digital transformation embodied people, empowered by information, empowering information.
Subscribe to None - Use Upload