My Oracle Support Banner

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 OCTOBER 29, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Identify SQL: ident_ord12_second_qty_corruption.sql
Datafix SQL: df_correct_sec_qty_scripts.zip
INV_DEVIATION_LO_ERR : The quantity entered is lower than the allowed deviation for the item.
INV_DEVIATION_HI_ERR : The quantity entered is higher than the allowed deviation for the item.

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

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
 Onhand
 Delivery Details
 Transaction history
 Reservations
Solution


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