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 28, 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. The organization is NOT WMS enabled.

"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 xxxx, Change Org parameter - Allocate serials - User defined
2. Release sales order xxxx, 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 line.

The pick release log showed that the call to allocate user-defined serials was missing even though 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.