My Oracle Support Banner

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


On 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

ORA-01426: numeric overflow





To view full details, 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 a vibrant support community of peers and Oracle experts.