![](https://spicatech.in/wp-content/uploads/2023/06/Bulk-Inventory-load-into-OMS-1.jpg)
Inventory load is a two-step process, where the inventory is loaded into YFS_INVENTORY_SUPPLY_TEMP table is the first step and Syncing the inventory is second.
When it comes to loading the inventory into OMS in full sync mode there are certain parameters we have to consider while designing the solution. Parameters like,
![](https://spicatech.in/wp-content/uploads/2023/06/1-1.jpeg)
Inventory Load – Parameters
Process:
![](https://spicatech.in/wp-content/uploads/2023/06/2-1.jpeg)
Inventory Load: load and sync Process
![](https://spicatech.in/wp-content/uploads/2023/06/3-1.jpeg)
Inventory Process: Adjust Inventory Service
Configuration
Service Creation
Async Service is created to receive all inventory details sent by Ship node through queue and those Inventory details get entered into YFS_INVENTORY_SUPPLY_TEMP table by using loadInventoryMismatch API.
![](https://spicatech.in/wp-content/uploads/2023/06/4-1.jpeg)
Service : Syncing Inventory Information
Synchronous service is created to calculate the mismatch and sync the full inventory into OMS by using syncLoadedInventory API.
![](https://spicatech.in/wp-content/uploads/2023/06/5-1.jpeg)
Application – Application Platform – Process Modeling – General – General – Transaction – Inventory change [ Event: ON_INV_MISMATCH ]
![](https://spicatech.in/wp-content/uploads/2023/06/6-1.jpeg)
On_Inv_Mismatch Action:
![](https://spicatech.in/wp-content/uploads/2023/06/7-1.jpeg)
Service Name: MsgPublisher
![](https://spicatech.in/wp-content/uploads/2023/06/8-1.jpeg)
Create New Async Service for loading Inventory by using adjustInventory API
Service : Loading the Inventory into OMS
![](https://spicatech.in/wp-content/uploads/2023/06/9-1.jpeg)
Test Case
If Apply Difference is N, syncLoadedInventory api will calculate the mismatches and dropped those information in the event (ON_INV_MISMATCH) and adjustInventory API will explicitly called to load inventory into OMS in Async Mode.This is happening for avoiding the over load on the API and also for increasing the performance. Load Inventory Mismatch & EOF Input
![](https://spicatech.in/wp-content/uploads/2023/06/10-1.jpeg)
![](https://spicatech.in/wp-content/uploads/2023/06/11-1.jpeg)
![](https://spicatech.in/wp-content/uploads/2023/06/12-1.jpeg)
Inventory were adjusted by converting Mismatch xml into Adjust inv api input xml through Java code
![](https://spicatech.in/wp-content/uploads/2023/06/13-1.jpeg)
![](https://spicatech.in/wp-content/uploads/2023/06/14-1.jpeg)
![](https://spicatech.in/wp-content/uploads/2023/06/15-1.jpeg)
![](https://spicatech.in/wp-content/uploads/2023/06/16-1.jpeg)
Database Table
![](https://spicatech.in/wp-content/uploads/2023/06/17-1.jpeg)
Thank you for taking time to go through this one!
Please feel free to leave a feedback or comment.
#LetsTalkRetail #SpicaTech