My Oracle Support Banner

AutoDetail Batch is Incorrectly Calculating Secondary Reservation Quantity, Later Leads to Error, "For A Fixed Conversion The Secondary Quantity Cannot Deviate" or "APP-FND-01048: Use of this combination restricted by WHERE clause" (Doc ID 2846517.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.9 and later
Information in this document applies to any platform.


On : 12.2.9 version, Batches

Since applying patch 32835997:R12.INV.C, Autodetail is creating reservations with secondary reservation qty out of sync with reservation qty.

Ingredients are used in batches in their secondary UOM. After running Autodetail, the reservation qty and secondary reservation qty are different by a small decimal quantity. They should be exactly equal since they are both in the same UOM.

Also, after editing the secondary reservation qty to match the reservation qty for all lines and then trying to save the fixed quantities, the following error sometimes appears:

APP-FND-01048: Use of this combination restricted by WHERE
clause'( RESERVABLE_TYPE = 1 and inventory_item_id = 96417
) '

If you later try to transact the reservation without fixing the secondary quantity, the following error displays:

For A Fixed Conversion The Secondary Quantity Cannot Deviate

The issue can be reproduced at will with the following steps:
1. Create a batch with Fixed dual UOM ingredients used in their secondary UOM (Production Supervisor > Batch Details)
2. Run Autodetail (from Batch Details > Inventory > Autodetail Batch)
3. Check secondary reservation quantity (click Maintain Reservations button on Batch Details).


A recent Inventory patch, 32835997:R12.INV.C, was applied. It is not known if this patch introduced the bug or if it brought in some other code that introduced the bug.


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.