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 BPM Training, please sign up at Free Lessons and Training Discounts.
Latest posts by Jaideep (see all)
- Oracle Business Rules: Sums and Averages in Test Conditions - April 2, 2016
- Rolling Up a BPM KPI into Business Architecture Models - January 28, 2016
- The BPM 12c Process Monitor Dashboard in 5 Minutes - January 6, 2016
This short video is very helpful . Thanks Pradosh
Thanks Pradosh! Glad it helped.
That was great tip Jaideep. i had one question with relation to soa i.e Is there any way we can export payload information of soa instance into files. we tried with soaaudittrailexporter, but it only exports audit xml file where payload information was missing. Or is there any mechanism to search for instance id using payload information in our whole partition/soa-infra. Your help would be much appreciated.
Hi Alamgir,
Thanks for your comment.
To track instances based on payload information, I have used Composite Sensors before. Would that work for you?
https://docs.oracle.com/middleware/1221/soasuite/develop/GUID-324D8481-6CFF-417B-83D3-9ECD1A4B1DA6.htm#SOASE85528
To actually see the payload information, I have used an OWSM log policy …to see the soap messages going across any services being called. Does that work for you?
https://docs.oracle.com/middleware/1212/owsm/WSSEC/webservice-diagnostics-logs.htm#WSSEC1228