My Oracle Support Banner

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

Last updated on MARCH 15, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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