Dual Unit of Measure (UOM) Control Item Has Wrong / Zero / Out of Sync Onhand and Available In Secondary UOM - Data Fix Scripts (Doc ID 2041773.1)

Last updated on FEBRUARY 24, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
In the Material Workbench form(INVMWBIV), the On-Hand, Available to Reserve and Available to Transact for a dual UOM controlled item with Fixed relationshipt are all 28, however the Secondary quantity for all 3 shows 0

The problem sometimes manifests itself as a secondary quantity that is non-zero but that is out of sync with the primary quantity based on the UOM conversion.

Similar problems are sometimes also seen in transactions or other documents.

EXPECTED BEHAVIOR
-----------------------
Expect the On-Hand and Secondary Quantity to be in sync.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to On-Hand, Availability > On-Hand Quantities
2. Query the item
3. See the Secondary Quantity is 0 (or out of sync with the primary quantity)) even though the On-Hand Quantity shows greater than 0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms