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 JANUARY 09, 2025

Applies to:

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.

OTHER SYMPTOMS
You could receive errors during interface trip stop ship confirm like the following error:
The quantity entered is higher than the allowed deviation for the item.
-or-
The quantity entered is lower than the allowed deviation for the item.

SQL IDENTIFICATION
You can use a script to look for corruptions -- ident_ord12_second_qty_corruption.sql -- that prompts for the order number and checks the related tables.

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

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

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