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 21, 2020
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.
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.
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.
The quantity entered is lower than the allowed deviation for the item.
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.
Expect the On-Hand and Secondary Quantity to be in sync.
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
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