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 AUGUST 15, 2021

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
WMSVPPRB.pls, WMSVPPRS.pls, INVSRSTB.pls


Symptoms

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.

ERROR
-----------------------
"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

STEPS
-----------------------
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".

Changes

 

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
Changes
Cause
Solution
References


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