My Oracle Support Banner

A Sales Order Pick Transaction Was Canceled But The Item's Onhand Quantity Still Does Show As Available EvenThough There Are No Reservations (Doc ID 2912696.1)

Last updated on JANUARY 29, 2024

Applies to:

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


It was noticed that the when reviewing on-hand quantity for an item, there are no reservations
but the on-quantity of 1980 does not show as available to transact.
The Supply/Demand form does not show any Supply/Demand for this quantity.
The Reservations form does not shown any reservations.

Expected Behavior

Should be able to use the on-hand quantity of 1980.


1. Navigate: Inventory > On-hand, Availability > Item Supply/Demand
    Query for the item and see no supply/demand.
2. Navigate: Inventory > On-hand, Availability > Reservations
    Query for the item and see no reservations.
3. Navigate: Inventory > On-hand, Availability > On-hand Quantity
    Query for  the item.
    Click the "Availability" button and see Total Quantity = 1980, Available to Transact = 0


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.