Product Item Backorders Even With Available On-hand Inventory (Doc ID 2808516.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Symptoms

On : 12.2.9 version, Reservations

Product Item backorders even with available on-hand inventory

When trying to ship confirm orders, certain items will not pick release and only go into backordered status, even though there is enough on hand inventory. The Pick Selection List Generation (pick release) receives this error

INV_CONVERT.within_deviation: returning error for fixed item as both sec and pri converted qty are not matching
[11-MAR-21 14:51:39] INV_RESERVATION_PVT: After validate_input_parameters E
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Return Status after creating reservations E
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Raising expected errorE
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Error Obtained at180
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Return Status after creating reservations E
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Raising expected errorE
[11-MAR-21 14:51:39] INV_Reservation_PUB.Create_Reservation: Error Obtained at10
[11-MAR-21 14:51:39] Inv_Pick_Release_PVT.Process_Reservations: error in create reservation

There were 6 lots that needed to be shipped. The primary quantity of each lot was 3.99333. The secondary quantity needed to be 7986.6666, however when the system tried to create the reservation, it would always truncate the secondary quantity to 7986.66. I did an override of the secondary quantity and then I was able to create a Move Order.
 

ERROR
-----------------------
INV_CONVERT.within_deviation: returning error for fixed item as both sec and pri converted qty are not matching

Cause

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