My Oracle Support Banner

WMS Standard Datafix Instructions (Doc ID 2614757.1)

Last updated on OCTOBER 25, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
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

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