Sales Order Pick Release Fails With 'error in create reservation' (Doc ID 870664.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 12.0.5 to 12.0.6 - Release: 12 to 12
Oracle Warehouse Management - Version: 12.0.5 to 12.0.6   [Release: 12 to 12]
Information in this document applies to any platform.
This document includes all versions of R12 and later

Symptoms

This issue has been seen in a number of different scenarios:

Scenario 1.

In R12 Internal Sales Order (ISO) cycle is failing as the lines get backordered after pick release with auto allocate and auto pick confirm set to Yes.  The organization and the item both are OPM enabled.

Steps:
Create an ISO and pick release with auto allocate and auto pick confirm set to yes.
Everything seems to be fine but the line gets back ordered

Scenario 2.

When attempting to run pick release, the following error occurs and the line is backordered. In addition when setting the auto allocate and auto pick confirm to no and trying to manually transact the move order the following error is raised:

""Error: The material sourcing process failed to create picking suggestions for line 1 of move order number 9999"

ERROR
16-OCT-09 17:10:02] INV_RESERVATION_PVT: After validate_input_parameters E
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Return Status after creating
reservations E
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Raising expected errorE
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Error Obtained at180
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Return Status after creating
reservations E
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Raising expected errorE
[16-OCT-09 17:10:02] INV_Reservation_PUB.Create_Reservation: Error Obtained at10
[16-OCT-09 17:10:02] Inv_Pick_Release_PVT.Process_Reservations: error in create reservation
pick release error in create reservation
sqlerrorUser-Defined Exception
[16-OCT-09 17:10:02] PICKREL: l_return_status from process_line is U

Exiting WSH_UTIL_CORE.GET_ITEM_NAME (10/16/2009 05:10:02 PM, ,01 seconds)
LOGGING EXCEPTIONS FOR NON SHIPSET/SMC LINES
Pick Release process could not allocate 1 of item 999 for order 999 as there was
insufficient quantity available Or Inventory allocations have failed, and the line has been back
ordered.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Enter, book order
3. Shipping
4. Release Sales Order

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