My Oracle Support Banner

Serial Numbers Are Not Recognized Via Material Workbench / Serial Number Mismatch Onhand (MOQD) Subinventory/Locator (Doc ID 603452.1)

Last updated on JULY 25, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
MTL_SERIAL_NUMBERS (MSN): Serial Numbers
INVMWBIV.fmb: Material Workbench
MTL_ONHAND_QUANTITIES_DETAIL: Onhand (MOQD)
Subinventory/Locator

Symptoms

Find that a specific item has a serial/locator mismatch when querying on Material Workbench.

Expected Behavior
Expect the item to show correctly with serial numbers in correct subinventory and locator.

Steps To Reproduce:
1. Query for the item.
2. The form returns the correct subinventory and locators.
3. Drill down to serial number in tree.
4. The serial number is not displayed.
5. Query on the serial number the return will show the wrong subinventory and/or wrong locator.
6. Drill down to the serial works here.

Changes

 

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
Changes
Cause
Solution
References


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