My Oracle Support Banner

API Inv_detail_serial_pub Errors with "Total serial numbers does not match the transaction quantity" For Pick Release (Doc ID 1153254.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

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


You set "Allocate Serial Number" to "Yes - User Defined" in Organization Parameters form.
You are trying to pass serial number data to the API INV_DETAIL_SERIAL_PUB.Get_User_Serial_Number.
But when you run Pick Release, the serial numbers do not get allocated.
You end up with Pending Transactions.

The INV Transaction Worker (INVMBTRX) log shows error message "Total serial numbers does not match the transaction quantity". The Pick Slip prints with No Data in From and To Serial Numbers columns.

Total serial numbers does not match the transaction quantity.

1. Navigate to Inventory > Setup > Organizations > Parameters.
2. Choose the Shipping Organization.
3. Set Allocate Serial Numbers to "Yes - User Defined".
4. Create an Internal Requisition
5. Approve the Internal Req
6. Run Create Internal Orders in the Purchasing responsibility
7. Navigate to Order Management > Orders > Order Import
8. Run Order Import to create the Internal Sales Order.
9. Optionally, set a debug message in the API INV_DETAIL_SERIAL_PUB.Get_User_Serial_Numbers, to indicate that the API was called by the Pick Release program.
10. Release the Internal Sales Order with Auto Allocate = Yes and Auto Pick Confirm = Yes.
11. Review the log file. (If the additional debug message was added, you would see the message in the INV Transaction Worker log.)
12. Navigate to Inventory > Transactions > Pending Transactions
13. Query for pending transactions
14. See the stuck transaction.




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.