Currently we have a synchronous PO interface (Proxy <-> PI <-> SOA. PO triggered in SAP is sent to PI and PI calls Vendor webservices, to create PO and sends response back with Sales Order# which updates in SAP.
The new additional requirement is to Read 3rd party oracle database for 3 fields. One field content is xml, which is similar to the SOAP request for PO create. Xml content read from that field need to be used as soap request to the Vendor WS and write the response xml back in to field on the Oracle database table. JDBC <-> PI <-> SOAP.
Please guide how to achieve this using PI as middle ware.