"ORA-12899: value too large for column "GLOGOWNER"."X_LANE"."DEST_CITY"" Exception During Planning Using Location with City Name Larger than 30 Characters (Doc ID 1504323.1)

Last updated on MAY 20, 2016

Applies to:

Oracle Transportation Management - Version 6.1.0 to 6.4.2 [Release 6.1 to 6.4]
Information in this document applies to any platform.

Symptoms

When planning orders that have (dest) locations with a city with length >30, the following error is thrown during (bulk)planning:

Error Exception insert into x_lane
(x_lane_gid,x_lane_xid,source_location_gid,source_city,source_province_code,source_postal_code,source_country_code3_gid,source_zone4,source_zone1,source_zone2,source_zone3,source_geo_hierarchy_gid,dest_location_gid,dest_city,dest_province_code,dest_postal_code,dest_country_code3_gid,dest_zone4,dest_zone1,dest_zone2,dest_zone3,dest_geo_hierarchy_gid,source_region_gid,dest_region_gid,constraint_set_gid,planning_parameter_set_gid,source_rail_splc_gid,dest_rail_splc_gid,source_rail_station_code_gid,dest_rail_station_code_gid,p_rule_set_gid,domain_name) values
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);

java.sql.SQLException: ORA-12899: value too large for column "GLOGOWNER"."X_LANE"."DEST_CITY" (actual: 33, maximum: 30)

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