Subinventory and/or Locator Mismatch Between WLPN and MOQD (Doc ID 2759578.1)

Last updated on AUGUST 08, 2023

Applies to:

Goal

On : 12.1.3 version, Materials Management

LPNs are identified with subinventory and/or locator mismatch from the below script:

SELECT wlpn.lpn_id ,moqd.subinventory_code, moqd.locator_id
FROM wms_license_plate_numbers wlpn, mtl_onhand_quantities_detail moqd
WHERE wlpn.organization_id=moqd.organization_id
AND wlpn.lpn_id=moqd.lpn_id
AND wlpn.lpn_context=1
AND (wlpn.subinventory_code<>moqd.subinventory_code OR wlpn.locator_id<>moqd.locator_id)
AND moqd.containerized_flag=1;
 

What is Root cause ?

Solution

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