Inv_quantity_tree_pub.Query_quantities Returns Wrong "Available To Reserve" (Doc ID 745403.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

API "inv_quantity_tree_pub.query_quantities" returning wrong values.

Steps
1. Create a Move Order for a given item and update the allocation so that an "allocated quantity"
appears on the Move Order.

Example: Item A has an on-hand quantity of 50.

2. Navigate to Inventory > On Hand Availability > On Hand Quantity
3. Inquire on the "Availability" of Item A after the Move Order quantity of 2 has been allocated.
4. The standard Oracle form will display:
- "On Hand" = 50,
- "Available to Reserve" = 48,
- and "Available to Transact" = 50.
5. Calling the API with the following list of parameters will produce:
- "On Hand" = 50,
- "Available to Reserve" = 50,
- and "Available to Transact" = 50.

Parameters
The following shows example parameters to the API:

Solution

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