My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

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


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

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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.