Material Workbench Querying Status In View By Location Doesn't Drill Down To Lot (Doc ID 2986993.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

On : 12.2.12 version, Onhand and Availability

Actual behavior

While querying the  Material Workbench form user cannot drill down the view tree until lot level. This is happening for both LPN packed items and non-LPN items as well.

On the Material Workbench when querying specific status in Organization view by location where stock is not packed in LPN, does not drill down to item and lot. If you are on the locator you can see item code, but not the lot at all.
Expand On-hand - Subinventory - Locator - Item => cannot drill down farther than item number in order to observe lot number.

On the Material Workbench when querying specific status in Organization view by location where stock is packed in LPN, does not drill down beyond LPN. If you are on the LPN you can see the locator and item code, but not the lot at all.
Expand On-hand - Subinventory - Locator - LPN - Item => cannot drill down farther than item number in order to observe lot number.

Expected behavior

The user should be able to access the lot level on the Material Workbench when querying specific status in org view by location

Steps

The issue can be reproduced at will with the following steps:
1. Query to WMS responsibility;
2  Go to Inquiry > Material workbench form;
3. Search for an item with onhand at lot level > Drill down in the left part of the screen;
4. Unable to drill down to lot level.

Changes

Cause

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