My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.