EBS WMS: Data Cleanup Script For Zero Quantity Records In MTL_ONHAND_QUANTITIES_DETAIL Table
(Doc ID 1577990.1)
Last updated on NOVEMBER 28, 2023
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
Generate reports on the quantity on hand details of the items from MTL_ONHAND_QUANTITIES_DETAIL table showing items with zero quantity.
When you query the MTL_ONHAND_QUANTITIES_DETAIL table it has 2 records for that item whose sum of Primary transaction Quantity is equating to zero.
Concurrent request "Consolidate Inventory Onhand Quantities" is not going to work in WMS enabled organization
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document