My Oracle Support Banner

Allocate Cost Action Failing with " java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column " Error Due To Allocation Base Sequence Is Exhausted And Cannot Hold Any New Values (Doc ID 2707649.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

Oracle Transportation Management - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

When selecting a shipment and act on it with Allocate Cost action the system shows it has allocated the cost fine but in reality, it is failing in the background with the following error showing in the log:



Investigation found that The ALLOC_SEQ_NO in ALLOCATION_BASE table has reached its max up to 8 digits in length and cannot hold any new values. The action Allocate Cost is failing on all the shipments. Due to Business needs re-setting not acceptable

Changes

 

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