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 188.8.131.52 and later
Information in this document applies to any platform.
This document apply to release 184.108.40.206 and all Release 12.
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:
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';
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