My Oracle Support Banner

WMS Standard Datafix Instructions (Doc ID 2614757.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Oracle Inventory Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


This document provides the detailed instructions for common data issues identified in Warehouse Management Analyzer. Please use this document in the following order:

A. Identification Scripts:

This will confirm if you are having this data corruption.

B. Verifying your file versions:

This will allow you and Support to confirm if you are already using a known fixed version.

C. Root Cause Analysis.

It shows all the relevant information about this issue Root Cause.

D. Datafix Intructions.

It will provide steps for fixing the data corruption.


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
 A. Identification Scripts:
 B. Verifying your file versions:
 C. Root Cause Analysis.
 D. Datafix Intructions.
 1. Invalid LPN Context Resides in WIP
 2. WMS_LPN_CONTENTS vs WIP_LPN_COMPLETIONS Mismatch LPN for Context Resides in WIP
 3. WIP Completed Serials are not matching with Serials in LPN
 4. WIP Completed Lots are not matching with Lots in LPN
 5. Onhand found in MTL_ONHAND_QUANTITIES_DETAIL for Resides in WIP LPN
 6. Receiving Supply in RCV_SUPPLY found for Resides in WIP LPN
 7. Receiving Transaction record found for Resides in WIP LPN
 8. MMT record found for LPN in Context "Resides in WIP"
 9. Corrupted Move Order Lines found for "Resides in WIP" LPN
 10.  Last Material Transaction is not "Issue from Stores"
 11.  Last Receiving Transaction is not delivered
 12.  Onhand exists in MTL_ONHAND_QUANTITIES_DETAIL for "Issued out of Stores" LPN
 13.  Pending Transactions exist in MTL_MATERIAL_TRANSACTIONS_TEMP for "Issued out of Stores"
 14. Interface Transactions exist in MTL_TRANSACTIONS_INTERFACE for "Issued out of Stores" LPN
 15.  Open Move Order Lines exists for "Issued out of Stores" LPN
 16.  Serial Numbers should not exist for "Issued out of Stores" LPN
 17.  Receiving Supply exists for "Issued out of Stores" LPN
 18.  MOQD DOES not exist for "Loaded in Staging"/"Packing Context" LPN
 19.  LPN context is 12 and inventory interface is not yet complete
 20.  LPN Context=1(Resides in Inventory) but no matching LPN_ID in MOQD
 21.  LPN Context=1(Resides in Inventory) has MOQD but no WLC
 22.  LPN Context=1(Resides in Inventory) has MOQD but no MSN
 23.  LPN has MOQD VS MSN Mismatch
 24.  LPN Context=1(Resides in Inventory) has MOQD but missing WLC
 25.  Incorrect serial_summary_entry for serial controlled at SO issue Item
 26.  Pending transactions against lpn warning for period close
 27.  Pending transactions for LPN against closed MTRL
 28.  Cost Group Comingling In Ohand for Items In LPN
 29.  Receiving Context LPN is locked by another user

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