Dual Unit of Measure (UOM) Control Item Has Wrong / Zero / Out of Sync Onhand and Available In Secondary UOM - Data Fix Scripts
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.
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.
Expect the On-Hand and Secondary Quantity to be in sync.
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
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