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.
CEO at Fusion Applied
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.
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