Available To Transact Is More Than Primary Quantity After Patch 34126092:R12.INV.C (Doc ID 2902886.1)

Last updated on OCTOBER 14, 2022

Applies to:

Symptoms

After patch 34126092:R12.INV.C was applied notice that pick release is creating reservations for more than what onhand is available for the item in the sales order creating a situation where Available to transact is more than available quantity.

For example: If you have 0 available for an item, you still will get a reservation for 1 even though you don't allow negative balance. 

Steps
1. Navigate to Inventory > Onhand > Onhand Quanity form
2. Query item
3. Confirm the available onhand for the item is 0
4. Navigate to Order Managment > Shipping > Release form
5. Query a Sales Order for the item
6. Select the Release action for the shipping line for quantity 1
7. See that pick release ended without error and a new reservation is created for the item resulting in incorrect available onhand.

Changes

Patch 34126092:R12.INV.C was applied which was causing the incorrect reservation to be created.

Cause

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