Consolidate Onhand Quantity /Sum Quantity Zero in MTL_ONHAND_QUANTITIES_DETAIL (MOQD) / Concurrent Program Consolidate Inventory Onhand Quantities / Datafix for 0 Quantity Displayed For Finished Goods

(Doc ID 353345.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Inventory Management - Version 11.5.8 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.


No quantity is onhand but items appear in the onhand form with a 0 quantity.

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"

1. Goto Inventory > Onhand, Availability > Onhand quantity
2. Search for a subinventory
3. Enter a quantity of 0
4. See 0 value locators displayed

Due to this issue, locators with zero quantity appear in physical inventory, cycle counting, inventory reporting.


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