Cannot Create Lane Using Too Long Location ID, Error ORA-06502: PL/SQL: numeric or value error (Doc ID 556043.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.03.04 to 5.5.03.05 - Release: 5.5 to 5.5
Information in this document applies to any platform.
Checked for relevance on 27-May-2010

Symptoms


On 5.5.03.04:
When trying to create lane with long location ID in Russian (actually it is still in the normal character size which is 101 character) the lane definition is not saving and the following error is shown:
ERROR
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too
small ORA-06512: at "GLOGOWNER.RRL", line 266 ORA-06512: at "GLOGOWNER.RRL", line 290 ORA-06512: at "GLOGOWNER.X_LANE_AIU", line 30 ORA-04088: error during execution of trigger
'GLOGOWNER.X_LANE_AIU'

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1- Go to Transportation Planning and Execution > Power Data > Geography > Lane Definition
> New > Give it an ID and select "Location" for both source and destination > Click on "Lane Definitions"

Use:
Source: ÏÎÐÒ ÑÀÍÊÒ-ÏÅÒÅÐÁÓÐÃ
Destination: ÑÂÕ ÎÀÎ ÏÅÒÐÎËÅÑÏÎÐÒ

Then click Finish > Here you will get the error


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