My Oracle Support Banner

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

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
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


EXPECTED BEHAVIOR

-----------------------
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"

 

NOTE:
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.



STEPS
-----------------------
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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.