My Oracle Support Banner

Pick Release Error: Error in Routine WSH_USA_INV_PVT.Update_inventory_info, Oracle Error 100 (Doc ID 377059.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Shipping Execution - Version to [Release 11.5.10]
Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
FORM:WSHFRREL.FMB - Launch Pick Release Form


You are trying to use ship sets on your sales orders but when picking, the pick release ends in error because of the ship sets being used.


The error in the pick release log file is as follows:
Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info, Oracle Error - 100

If you remove the flag for enforcing ship sets (in the Shipping parameters form),
pick release works fine, but of course ignores the ship sets.

Create order containing multiple ship sets, where one of the ship sets should not ship due to insufficient quantities available. Pick release specific order using concurrent process. Error appears.


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.