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 FEBRUARY 05, 2019
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Pick Release, Pick Selection List Generation, WSHPSRS
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |