INVMWBIV: Material Workbench Onhand Quantity Results Do Not Display (Missing) The Item and Item Description (Doc ID 2197377.1)

Last updated on MAY 31, 2022

Applies to:

Symptoms

When view the onhand quantity and entering just organization code the information returned does not show the item or item description

EXPECTED BEHAVIOR
Expect to see the item and item description

STEPS
1. Navigate to Responsibility: Inventory : On-hand, Availability -> On-hand Quantity
2. Search for the items using the following parameters:
     Organization Code: <specific org>
     View By: Location
     Detailed: checked
3. Click Find button
4. Information returned shows the Organization Code and Subinventory
5. However, the item and item description fields are null

Changes

 Applied a patch that delivers file $INV_TOP/patch/115/sql/INVMWQMB.pls and version 120.71.12010000.66

Cause

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