The Infor Communities is globally accessed system by
Infor and its customers, please do not post or upload
any content that could be deemed as sensitive, confidential or
subject to any data regulation requirements.
If you are unsure whether or not the content contains sensitive,
confidential or has any data regulation requirements,
please seek the advice of your internal security, legal, and compliance experts.
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.
when you are doing a mapping from SP's output XML to Process.InventoryAdjustment, you could fill in the ReferenceID element (It is in ApplicationArea\Sender 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 Sender\ReferenceID 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.
Thank You very Much, That's exactly what i need.