My Oracle Support Banner

WMS Standard Datafix Instructions (Doc ID 2614757.1)

Last updated on JANUARY 28, 2020

Applies to:

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

Goal

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.

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
 1. Invalid LPN Context Resides in WIP
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 2. WMS_LPN_CONTENTS vs WIP_LPN_COMPLETIONS Mismatch LPN for Context Resides in WIP
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 3. WIP Completed Serials are not matching with Serials in LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 4. WIP Completed Lots are not matching with Lots in LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 5. Onhand found in MTL_ONHAND_QUANTITIES_DETAIL for Resides in WIP LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 6. Receiving Supply in RCV_SUPPLY found for Resides in WIP LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 7. Receiving Transaction record found for Resides in WIP LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 8. MMT record found for LPN in Context "Resides in WIP"
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 9. Corrupted Move Order Lines found for "Resides in WIP" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 10.  Last Material Transaction is not "Issue from Stores"
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 11.  Last Receiving Transaction is not delivered
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 12.  Onhand exists in MTL_ONHAND_QUANTITIES_DETAIL for "Issued out of Stores" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 13.  Pending Transactions exist in MTL_MATERIAL_TRANSACTIONS_TEMP for "Issued out of Stores"
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 14. Interface Transactions exist in MTL_TRANSACTIONS_INTERFACE for "Issued out of Stores" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 15.  Open Move Order Lines exists for "Issued out of Stores" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 16.  Serial Numbers should not exist for "Issued out of Stores" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 17.  Receiving Supply exists for "Issued out of Stores" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 18.  MOQD DOES not exist for "Loaded in Staging"/"Packing Context" LPN
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script
 19.  LPN context is 12 and inventory interface is not yet complete
 A - Identification Scripts.
 B - Verifying your File Versions.
 C - Root Cause Analysis.
 1. Existing Root-Causes? No.
 2. New Root- Causes?
 D - Datafix.

Follow the steps below to fix the data in a test environment first, verify results, then migrate as appropriate:
 1. Identify
 2. Run the datafix script

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