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 BPM Training, please sign up at Free Lessons and Training Discounts.


Jaideep has more than 20 years of professional software development experience. He has delivered solutions for several domains including financial services, e-Government, criminal justice, and wireless application services. He is a Certified Scrum Master and has mentored several teams to use agile software development techniques. He has delivered several SOA/BPM solutions based on the BEA/Oracle SOA Suite over the last 6 years . His current focus is on helping customers build solutions using Oracle BPM, Webcenter, ADF and SOA Suite 11g and 12c. Jaideep also trains teams on using Oracle BPM and has developed several self paced online video training courses for Oracle BPM 11g and 12c.

Leave a Reply

2 Comment threads
2 Thread replies
Most reacted comment
Hottest comment thread
3 Comment authors
Jaideepalamgir shaikhPradosh Recent comment authors
newest oldest most voted
Notify of

This short video is very helpful . Thanks Pradosh

alamgir shaikh
alamgir shaikh

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.