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:

Symptoms

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.

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

STEPS
-----------------------
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

Changes

Cause

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