My Oracle Support Banner

Unable to Allocate User-Defined Serial Numbers during Pick Release Even After Patch 9589015 (Doc ID 1389599.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to call the pick confirm API, INV_DETAIL_SERIAL_PUB get the following errors below. These are the same error described in <bug 9589015>. Applied the patch for that bug, but that did not resolve the issue. We are NOT a WMS enabled org

"Transaction processor error
Total serial numbers does not match the transaction quantity"
ORA-01403: no data found in Package INV_Trolin_Util Procedure Query_Rows

The issue can be reproduced at will with the following steps:
1. Create sales order 66813, Change Org parameter - Allocate serials - User
2. Release sales order 66813, Auto allocate = No, Auto Pick confirm = No
3. Modify INV_DETAIL_SERIAL_PUB.Get_User_Serial_Numbers to return the correct serial
4. Run INV_REPLENISH_DETAIL_PUB.line_details_pub, to allocate the move order

The pick release log showed that the call to allocate user-defined serials was missing eventhough Allocate Serial Numbers was set to "Yes - User Defined".

[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.Apply.start_alloc: Start allocation process
[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.Apply.allocate_serial_flag: allocate_serial_flag = C
[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.Apply.fetch_cursor: Getting rec from rule with FetchCursor
[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.Apply.fetch_cursor: inside Mat Stat check LOOP
[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.FetchCursor.start: Start FetchCursor
[22-JUN-11 09:45:52] wms.plsql.WMS_Rule_PVT.FetchCursor.end: End FetchCursor
[22-JUN-11 09:45:53] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.start: Start rollback_capacity_update
[22-JUN-11 09:45:53] wms.plsql.WMS_Rule_PVT.rollback_capacity_update.end: End rollback_capacity_update
[22-JUN-11 09:45:53] Inv_Pick_Release_PVT.Process_Line: l_return_status = U
pick release l_return_status = U
[22-JUN-11 09:45:53] Inv_Pick_Release_PVT.Process_Line: inv detailing failed
pick release inv detailing failed
[22-JUN-11 09:45:53] Inv_Pick_Release_PVT.Process_Line: Pick Release Online has completed successfully.
pick release Pick Release Online has completed successfully.
[22-JUN-11 09:45:53] PICKREL: l_return_status from process_line is U


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

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