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 DECEMBER 28, 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.

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!

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