My Oracle Support Banner

Material Workbench Shows Items With Zero Onhand (Doc ID 2140603.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Warehouse Management - Version and later
Information in this document applies to any platform.


In material workbench, Inventory for few Items is showing as 0 on hand.

For example, for one problem Item TL-917,

Material Workbench Shows as below


The Item Diagnostics shows as below

Dump of Onhand Table shows as below. there are two rows with quantity -2 and quantity 2 in the onhand table


Expect items with onhand of zero not to display in the onhand quantity form. Expect the search for these items to result in the following message: "On-hand quantity is not available"


Reviewed the following Notes
DOC ID 267272.1  will not help here as only sum(PRIMARY_TRANSACTION_QUANTITY)  = 0  and the script invzmoqd.sql is deleting only rows with primary_transaction_quantity = 0 and transaction_quantity = 0
DOC ID 353345.1 cannot be used as "Consolidate Inventory Onhand Quantities" / scripts invcrmoqdt.sql and invredmoqd.sql can only be used for NON WMS Enabled orgs but VST Org is WMS Enabled.

1. Login into application with Warehouse Manager Responsibility
2. Navigate : Inquiry > Material workbench
2. Enter Item = TL-917 and Org = VST and click Find
3. See rows with zero onhand shows up


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.