Synchronizing Inventory Balances

When Oracle Fusion Cloud Inventory Management integrates to an external execution system, summary inventory balances are still maintained at a high level in Oracle Inventory Management.

These provide summary inventory availability (for example, available or unavailable) for each inventory bucket (Subinventory level summary) for inquiry/reporting, reservations, global order promising, and planning. Details such as zone/row/aisle/bin and how material is packed into license plate numbers (LPNs) are maintained in the warehouse management system.

If the available balance of the source warehouse management system or third-party logistics provider must be in sync with the available balance in Oracle Inventory Management, you must extract the inventory balances from the warehouse management system or 3PL to the same level of summarization as tracked in Oracle Inventory Management, along with all the details (such as lots and serial numbers). Then you can start the inventory balance message and use either the Inventory Balance Message Import file-based data import (FBDI) or the Inventory Balance Transactions REST resource to post inventory balance messages from the external source. Use the Manage Inventory Balances scheduled process to process the imported inventory balance messages in the interface tables.

When synchronizing inventory balances, the on-hand balances in the external execution system (3PL, warehouse management system) are assumed to be the source of truth. As an example, if Item A has an on-hand balance of 100 in the external execution system and Oracle Inventory Management has an on-hand balance of 98, the Oracle Inventory Management system will synchronize the two balances and perform a miscellaneous receipt of 2 so the on-hand balance will be 100 in both systems.

Note: You should use an inventory-balances approach to find the root cause of on-hand inventory mismatches between Oracle Fusion Cloud Warehouse Management and Oracle Inventory Management and to rectify the operational/integration issues. Don't use inventory balances to quickly update the on-hand inventory in Oracle Inventory Management without addressing the underlying cause. We recommended approvals when running the Manage Inventory Balances scheduled process to review and resolve discrepancies.