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

Last updated on OCTOBER 19, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
INVMWBIV - R12 - Material Workbench / Onhand Quantity Screen
INVMATWB - R11i - Material Workbench / Onhand Quantity Screen

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: WHS
     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

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