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 11.5.10.2 to 11.5.10.2 [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



Symptoms

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.

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

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