WMS Standard Datafix Instructions
(Doc ID 2614757.1)
Last updated on MAY 31, 2023
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|
|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 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 Commingling IN ONHAND FOR ITEMS IN LPN|
|29. receiving context LPN IS locked by another user|