Secondary Onhand Quantities Get Out Of Sync, Then After Auto Detail in a Batch, Trying to Transact Gives Error, "For a Fixed Conversion the secondary quantity cannot deviate" (Doc ID 2174080.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 12.1.3 version, Inventory Convergence

Problems with Fixed Quantity Conversion items. After a series of transactions in which the secondary quantity has been rounded to five decimals, leaving the onhand secondary quantity slightly out of sync with the UOM conversion, when you then use Autodetail in a batch to create a detailed reservation of the remaining quantity based on picking rules for the lot, plus another reservation for a different lot, when you try to convert the reservations to transactions by releasing the batch, you get the error "For a Fixed Conversion the secondary quantity cannot deviate"

For example, Fixed dual UOM item, LB primary and GL secondary, conversion is 1 GL = 9.30169 LB
Create onhand qty of 50 LB, 5.37537 GL in one lot
Create twelve issue transactions (can be Misc Issue or WIP Issue) of 4.14462 LB and .44558 GL
Note that the secondary qty of .44558 GL has been rounded from 0.4455770940549513
This leaves an onhand of .26456 LB and .02841 GL (based on conversion should be 0.02844)
Use this item as an ingredient in a batch, with planned qty of 5 LB, and set ingredient to Automatic Consumption
Make sure there is available qty of another lot, but that the original lot will be selected first by picking rule
Run Autodetail Line
Two reservations are created, one for the original lot of .26456 LB and .02841 GL, which equals the onhand quantity. Note that this is different from what happens if you enter the reservation manually; in that case the reservation is created with the secondary qty calculated from the UOM conversion, not based on the onhand qty, that is, .26456 LB and .02844 GL
The second reservation for the other lot is for 4.73544 LB and .50913 GL (based on conversion, this should be 4.73544 LB and 0.50909 GL)
Attempt to release the batch, which would create WIP Issue transactions based on these reservations.
Get error, "For a Fixed Conversion the secondary quantity cannot deviate"

As I mentioned, if you create a reservation for the original lot manually and then consume it, this goes through even though the reserved/transacted quantity is slightly different from the onhand quantity. This is dealt with by the code creating a Residual Qty issue or receipt transaction in addition to the WIP Issue transaction so that the secondary onhand qty ends up as zero just as the primary onhand quantity ends up as zero.

ERROR
-----------------------
For a Fixed Conversion the secondary quantity cannot deviate

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create onhand quantity of a Fixed Dual UOM item in a single lot
2. Create a series of transactions to consume most of that lot, using a qty that causes the secondary qty to be slightly out of sync because of rounding to five decimals
3. In an OPM batch, use Autodetail Line to reserve the remaining qty of that lot plus some of another lot on an Automatic Consumption ingredient
4. Try to release the batch to convert the reservations into WIP Issue transactions

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot release batches when this occurs, and consume the remaining onhand.

Cause

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