Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get Invoke XML Payload using SQL query

912502Apr 8 2013 — edited Apr 9 2013
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2013
Added on Apr 8 2013
1 comment
621 views