Oracle Business Rules: Sums and Averages in Test Conditions

Sometimes in test conditions in rules, there may be a need to test for sums or averages of a collection of values, and these kinds of aggregated values may not be directly available as input facts. For example, in an expense report, you may want to test if the total expenses are above a certain Read more about Oracle Business Rules: Sums and Averages in Test Conditions[…]

Simple Introduction to using the Enterprise Manager SOA/BPM Facade API

Overview There may be times when you need to expose just a small section of what is displayed in the Enterprise Manager console for SOA/BPM (EM console). A simple example can be where stakeholders on the systems integration or customer teams want to monitor a dashboard of statistics on how many instances of a composite Read more about Simple Introduction to using the Enterprise Manager SOA/BPM Facade API[…]

How to debug the SQL generated by the DBAdapter

To debug DBAdapter execution, it is very helpful to know the exact SQL being generated by the adapter. This post describes how you can set up your environment so that you can inspect the SQL being generated. Enable JDBC Debugging Log in to the WebLogic Console, select Servers Select each server on which you want Read more about How to debug the SQL generated by the DBAdapter[…]

How to write a Java Client supplying username/password for a WebService secured using the oracle/wss_username_token_service_policy

In the EM Console go to the ‘Test’ page for the service you are developing a client for and copy the WSDL url. In JDeveloper, in your Java Project, create a new Web Service Proxy When setting the wsdl url, change ‘wsdl’ to ‘orawsdl’ Go through the wizard accepting the defaults and setting appropriate package Read more about How to write a Java Client supplying username/password for a WebService secured using the oracle/wss_username_token_service_policy[…]

How to add a document in IPM using Imaging Services

Here is how you can add a document programmatically using Oracle Imaging APIs — Document and Document Content Services. The example shown is a simple java client that you can use to test the document creation and check-in. Make sure your project has the imaging-client.jar, from IPM lib, included in its class path. Create a Read more about How to add a document in IPM using Imaging Services[…]

SOA Server OutOfMemoryError Issue in JRockit JVM

The Challenge This is a real scenario from one of my clients. I built a killer Oracle BPM / ADF app and deployed to a newly configured SOA server running in JRockit JVM in Linux. I see that the server starting to behave rather slowly after couple of deployments. I check the memory settings, the Read more about SOA Server OutOfMemoryError Issue in JRockit JVM[…]

Web Services Attachment with MTOM

Intro I was preparing for a blog about binary attachment using web services. Just this week, I had to write a client code to help one of my co-workers test uploading binary data via Document Content Web Services for his newly installed I/PM framework. What a coincidence! This post shows how you can upload and Read more about Web Services Attachment with MTOM[…]

What does the BPM Human Task Enable Auto Claim Do

The Enable Auto Claim feature on a human task is ‘ON’ by default. Because this is ON by default, I find it easy to forget what it exactly does. I wanted to quickly document what this feature does in this post , so that I don’t forget it myself. The feature is ‘ON’ by default. Read more about What does the BPM Human Task Enable Auto Claim Do[…]

Create a SOA-MDS Connection in Jdeveloper for SqlServer

Creating a SOA-MDS connection in Jdeveloper is a fairly straight forward affair. You create a new database connection in Jdeveloper resource palette to the MDS repository using the correct user. Next, create a new SOA-MDS connection in resource palette. Select Connection Type :-> DB Based MDS. Choose the previously create database connection to the MDS Read more about Create a SOA-MDS Connection in Jdeveloper for SqlServer[…]

Sharing Fault Policies Across Your Oracle BPM 11g Projects

This post is specifically about how to maintain and share enterprise level Fault Policies that can be re-used across all your BPM 11g projects. I’m assuming that you know enough about BPM/SOA Suite Exception Handling in general  using Fault Policies. If you are looking for more basic information on Fault Handling,  check Using Fault Handling Read more about Sharing Fault Policies Across Your Oracle BPM 11g Projects[…]