INV_RESERVATION_PUB.UPDATE_RESERVATION API Allowing To Update Sub-Inventory Of The Reservation Even If There Is No Sufficient On-hand Available To Reserve In That Sub-inventory (Doc ID 3032199.1)

Last updated on JULY 01, 2024

Applies to:

Symptoms

While updating sub-inventory in existing reservation with API inv_reservation_pub.update_reservation, the API is allowing to update the sub-Inventory even if there is no sufficient on-hand available to reserve in that sub-Inventory. The API should throw error when the Sub-Inventory is not having sufficient on-hand.

The issue can be reproduced at will with the following steps:

1. Navigate to Order Management Responsibility -> Orders, Returns -> Sales Orders
2. Create a sales order and Book the Sales order
3. Create reservation for the order with out sub-inventory
4. Update the reservation using API inv_reservation_pub.update_reservation with sub-inventory which don't have on-hand
5. API is not throwing the error

Cause

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