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

Last updated on JULY 12, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 20-Oct-2014***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms