Integration

Hi all Gurus, I have some peculiar situation,


I need to get the xml data of each instance of certain bpel processes deployed in the soa server. I know that we can get that from the XML_DOCUMENT where we will be having the blob object which will have the xml payload of the instance. But not able to join the CUBE_INSTANCE and XML_DOCUMENT.

Requirement:

My actual requirement is that I need to retrieve the data of each instances of certain soa process deployed in the Soa Server and then make the report of them and further process them to another process. I was able to find that we can get the complete payload from the XML_DOCUMENT but unable to relate with CUBE_INSTANCE. as there are no common columns to make a join and in the Document column of XML_DOCUMENT we can have the blob object which has the complete payload.

Please provide me some guidance. Help appreciated.

Thanks in advance, Venkatesh.