Address Type {type=null} for Oracle Spatial is Unknown When Returning Street Level Distance (Doc ID 1175397.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.1.1 and later   [Release: 6.1 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to Ask OTM for Distance / Time the following error occurs.

ERROR
-----------------------
2010-08-04 13:45:33.71 561368 Error Exception Address Type {type=null} for Oracle Spatial is unknown. Address Type must be one of the following: {validTypes=null} (STREET_ADDRESS=LAT_LONG, CITY_PROVINCE, CITY_COUNTRY, POSTAL_CODE)
glog.externalapi.distanceengine.ExtEngineException: cause.OracleSpatialAddressTypeUnknown

glog.externalapi.distanceengine.ExtEngineException: cause.OracleSpatialAddressTypeUnknown
at glog.business.rate.ratedistance.external.OracleSpatialEngine.buildAddress(OracleSpatialEngine.java:440)
at glog.business.rate.ratedistance.external.OracleSpatialEngine.buildRouteRequestInputParms(OracleSpatialEngine.java:299)
at glog.business.rate.ratedistance.external.OracleSpatialEngine.lookupDistance(OracleSpatialEngine.java:70)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Log into OTM Support Instance running 6.1.1
1. Navigated to Shipment Management > Power Data > Geography > External Distance Engine
2. Created new External Distance Engine
3. Setup the Host and Port with OracleSpatial.port
4. Create new Rate Distance (Navigate to Contract and Rate Management > Power Data > Contracts > Rate Distance)
5. Applied External Distance Engine to Rate Distance
6. Clicked on Ask OTM Distance / Time to
7. Input TL-Sim for Rate Service
8. Input Rate Distance that was created
9. Input Ship From Location ID
10. Input Ship to Location ID
11. Click Find Distance/Time
12. Receive 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