My Oracle Support Banner

Secondary UOM Quantity Cycle Count Adjustments Are Not Recorded For Dual UOM Item (Doc ID 2532385.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version and later
Oracle Fusion Inventory Management - Version and later
Information in this document applies to any platform.


Secondary UOM Quantity Cycle Count Adjustments Are Not Recorded for Dual UOM Item

Items with secondary UOM quantity which is adjusted on cycle count does not have inventory cycle count adjustment transactions recorded in onhand.
When both the item primary and secondary UOM quantities are adjusted on a cycle counts onhand reflects the cycle could adjustments.
The inventory cycle count adjustment transactions are not appear either in the Pending Transactions or the Completed Transactions in
case only the secondary UOM quantity was adjusted.

On recording cycle count adjustments using secondary quantity, inventory cycle count adjustments will generated to update item onhand.

The issue can be reproduced at will with the following steps:
1. Create item with dual UOM (UNITS are primary UOM, VIAL are secondary UOM)
2. Create cycle count for item with dual uom
3. Create count sequence
4. Record count sequence
  a. Primary Suggested Quantity=2412 UNITS
  b. Primary Adjustment Quantity=0
  c. Secondary Count Quantity=1 VIAL
  d. Secondary Suggested Quantity=.26
  e. Secondary Adjustment Quantity=.74
5. Submit the adjustment
6. Approve the adjustment
7. Open Manage Item Quantities UI
8. Query dual UOM item
9. Primary Quantity=2412
  Secondary Quantity=.26




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

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