Transactional Handling in ION

unknown

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

unknown

Hi,

when you are doing a mapping from SP's output XML to Process.InventoryAdjustment, you could fill in the ReferenceID element (It is in ApplicationAreaSender node). When LN will process the incoming BOD, it will return Acknowleddge.InventoryAdjustment. In this one you will have a node OriginalApplicationArea, which will contain the same SenderReferenceID element. You have to extract it and update the correct record in Oracle based on that.

This is the way we do it with SalesOrder.