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

Last updated on JULY 19, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
When performing a pick release Internal Order line, the deliveries get backordered and the following error can be seen at the pick release log
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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms