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[…]

Tech Tip: How to trace SOA Suite SQL

Once you start working with BPM/SOA suite, there may be times, especially when you are debugging, when you need to see what SQL queries the BPM/SOA Suite engine is submitting to the SOA Infra database. This video shows you how to trace SOA Suite SQL. Trace SOA Suite SQL If you are interested in Oracle Read more about Tech Tip: How to trace SOA Suite SQL[…]

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[…]

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[…]

Are your exceptions not being logged in SOA Server?

A couple of days back one of the developers I work with reported that it takes a long time to debug issues when some of the services we call from our BPM process throw exceptions, because he couldn’t find the stack trace of the service in any of the SOA server logs. In our Development environment we Read more about Are your exceptions not being logged in SOA Server?[…]