Pick Selection List Generation: ORA-01407: cannot update ("INV"."MTL_TXN_REQUEST_LINES"."QUANTITY") to NULL in Package INV_Pick_Release_PUB Procedure Pick_Release Unexpected error from INV_Pick_Relea (Doc ID 1390139.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Pick Release, Pick Selection List Generation, WSHPSRS
***Checked for relevance on 17-JUL-2014***


Symptoms

When attempting to pick release a line Pick Release errors as shown in the log file of the concurrent program:

WSHPSRS module: Pick Selection List Generation - SRS
+---------------------------------------------------------------------------+

Exception occurred in WSH_PICK_LIST

...
Pick_Confirm: error from inv_trx_mgr.process_trx_batchTotal serial numbers does not match the transaction quantityTotal serial numbers does not match the transaction quantityTotal serial numbers does not match the transaction quantity
Error occurred in INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
Unexpected error. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception

When you enable the inventory debug following Note 148651.1, the following additional details can be observed in the Pick release log:

ERROR
-----------------------
Error occurred in Inv_Pick_Release_Pub.Pick_Release
Failed to generate allocations. Cannot suggest a destination locator because there is no default destination locator for this item.
Error: The material sourcing process failed to create picking suggestions for line 1 of move order number .
ORA-01407: cannot update ("INV"."MTL_TXN_REQUEST_LINES"."QUANTITY") to NULL in Package INV_Pick_Release_PUB Procedure Pick_Release
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using the OM Super User Responsibility, navigate to Shipping> Release Sales Orders> Release Sales Orders
2. Using the order / release rule, run the process.
3. Lines fail to release

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