Picking with autocreate deliveries errors with WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES ORA-01426: numeric overflow (Doc ID 752084.1)

Last updated on JULY 16, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
*** Checked for relevance on 06-Oct-2014 ***
Form:WSHFRREL.FMB - Launch Pick Release Form


Symptoms

On 11.5.10.2 in Production:

Pick release is failing with the below error

Error occurred in WSH_DELIVERY_AUTOCREATE.Autocreate_Deliveries
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST

The "same error" is visible when trying to autocreate deliveries in Shipping Transactions form

WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES, Oracle Error - -1426
ORA-01426: numeric overflow

.

Changes

 

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