Material Workbench Shows Items With Zero Onhand
Last updated on JULY 12, 2017
Applies to:Oracle Warehouse Management - Version 126.96.36.199 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms