LPN Locator Mismatch Between MTL_ONHAND_QUANTITIES_DETAIL and WMS_LICENSE_PLATE_NUMBERS (Doc ID 367433.1)

Last updated on MAY 24, 2016

Applies to:

Oracle Warehouse Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
This document apply to release 11.5.10.2 and all Release 12.

Symptoms

When attempting to see the content of a LPN in mobile device the following message appears:
The selected LPN has no content

If you query the item in Material Workbench by locator you can see the content in a certain locator, but if you query the LPN in Material Workbench you will see it in a different locator

The locator_id in MTL_ONHAND_QUANTITIES_DETAIL is different from the locator_id in WMS_LICENSE_PLATE_NUMBERS.  The query to check the locators:

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