My Oracle Support Banner

Root Cause For Mismatch between WMS_LPN_CONTENTS and MTL_ONHAND_QUANTITIES_DETAIL table fixed. (Doc ID 1511891.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.2 version, Materials Management

ACTUAL BEHAVIOR
---------------
Mismatch occurs between MMT and WLC while performing splitting the LPN A to LPN B and dropping LPN B.

EXPECTED BEHAVIOR
-----------------------
Rectify the mismatch

STEPS
-----------------------
The issue can be reproduced at will with the following Example steps:
1. Create a PO with the same item and 23 qty.
2. Create receipt into LPN # 1 - Qty 10
3. Create receipt into LPN # 2 - Qty 13
4. Load LPN # 2 only
5. Split LPN # 1 into LPN # 2.
6. Drop LPN # 2 using Move any LPN form.
7. Check On-hand
8. Available qty is showing as '0'.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.