Internal Order Line Gets Back Ordered Even Though On Hand Quantity Exists (Doc ID 2036473.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to pick release Internal Order line, the deliveries get backordered and the following error can be seen at the pick release log:
Pick Release process could not allocate 3 of item XXXX for order XXXX as there was insufficient quantity available or Inventory allocations have failed, and the line has been back ordered.

When setting Auto Allocate to NO and Auto Pick Confirm to NO and pick released line, line status changed to Released to Warehouse.

When attempting to transact the qty in the Transact Move Order form, the following error occurred:
 
Error: The requested quantity could not be fulfilled by the location detailing process.
Action: Make sure there is onhand quantity for item before attempting to detail these items.

Query the sales order in the Shipping Transaction form.
Verify that the line status had progressed to 'Released to Warehouse'.
Please also scroll over to the right and note the Move Order Number that's generated.

Switch responsibility to Inventory and navigate to Move Orders->Transact Move Orders and then select the correct organization.

Query the Move Order number that was noted from the Shipping Transaction form.
Select the move order line that appears and then click on the Allocate button.
 

Changes

 Made changes in WMSVPPEB.pls(WMS_ENGINE_PVT), procedure - create_suggestions,                                            
1) Added a cursor - CURSOR c_so_reservations IS                        

To fetch the detailed reservations if any based on the demand source line id.                                                
2) Added a NVL -  IF (inv_cache.set_fromsub_rec(l_request_line_rec.organization_id, nvl(l_request_line_rec.from_subinventory_code,l_so_rsv_sub)))  
to consider the subinventory fetch from reservations for fetching the from locator control.

Cause

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