My Oracle Support Banner

Inventory Creates Automatic Residual Qty Issue For Seconary UOM When Full Primary Is Absorbed (Doc ID 1360553.1)

Last updated on JANUARY 29, 2022

Applies to:

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


Functionality between 11i pick lots form and select available inventory is different for items that are set up as no default uom control.

In 11i, in the pick lots form if the user selected the entire primary quantity of the lot onhand, by either typing in the value or using the default unallocated quantity button the user did not have to enter in a secondary quantity. The system would take the full secondary quantity that was onhand when the full primary onhand was allocated.

In R12, in the select available inventory form, if the user selects the default quantity button, the full primary quantity of the lot is taken and the system is calculating the secondary quantity based on the item uom conversion instead of just taking the full onhand secondary quantity.

Then if the user transacts this wip issue, a residual quantity transaction to remove the remaining secondary is created. However, if the user does a correction or wip return for the full quantity, this residual transaction is not considered and only the calculated secondary is put back into the lot. This means that the new primary/secondary onhand are not the same as the original onhand quantities.

If the user types in the full primary on-hand quantity in the select available inventory form, the user then has to type in the secondary quantity.

-- Steps
1. Production supervisor > batches
Transact material > select available inventory


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.