My Oracle Support Banner

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

Last updated on JANUARY 09, 2018

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:

SELECT MOQD.LOCATOR_ID LOCATOR_ONHAND, MLPN.LOCATOR_ID LOCATOR_LPN
FROM MTL_ONHAND_QUANTITIES_DETAIL MOQD, WMS_LICENSE_PLATE_NUMBERS MLPN
WHERE MOQD.LPN_ID = MLPN.LPN_ID AND MLPN.LICENSE_PLATE_NUMBER = '&LPN_NUMBER';

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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