How to get Invoke XML Payload using SQL query
912502Apr 8 2013 — edited Apr 9 2013Hi All,
We are having soa 11.1.1.3 .
We are having issues with EM Console .We dont want to login EM Console to get the payload or check the instance status etc.
I want to write a SQL query to get the payload being sent to parter link .
We have SOA Composite with following data flow.
DB Adapter -> BPEL -> Fiile Adapter
I want to get the XML being sent to File Adapter from BPEL using Invoke activity .I want to get this using SQL query .
Please help me which all tables we need to use . Di Anybody has this query handy ??
Please help me.
Thanks
Surfraz