Hello All,

I am looking through ION guides and trying to find out how Transactional handling is done in ION if there are different application but couldn't find a good solution. I am taking one such example which i am trying to do.

I have an Oracle DB where Inventory adjustment data is stored from a WMS software. I need to process those Adjustments in LN also and mark them complete in Oracle once it is processed successfully.

So the approach which i am following is " Create a SP in Oracle and Generate an XML Document which has all the Adjustment Orders, Splitting it into Multiple XML's and mapped it to Proccess.InventoryAdjustment ". Now challenge here is ID generated by LN ERP for inventory adjustment is different(As adjustment order is Auto Generated No) and ID which is there in Oracle is different. How can i update back the Oracle table once adjustments are processed in LN.

Any help is deeply appreciated.

Thank You

Anmol

This is how I can visualize this interface on top of my mind.


You can create a flow having source as DB Connector with Oracle as DB and a stored procedure which returns XML data. Then this XML data passes through a transformer to produce a nice BOD for adjustment order which goes in LN and creates the order and returns back the response, this response then goes again through a transformer, and generates an XML which will end up as a parameter to another Oracle stored procedure which will update the required table.


OracleDB(Select Record Procedure) -> Transformer -> BOD(LN) -> Transformer -> OracleDB(Update Record Procedure)


I hope that made sense. Theoretically looks feasible to me.

Yes makes sense. Also in acknowledgment it will send back the original application area so thinking to utilize that to pass the unique values between two applications.