Can Not Control the Number of Characters Used for the Postal Code when Performing PcMiler Distance Lookups
Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 5.5.03 to 5.5.05.04
This problem can occur on any platform.
An External Distance Engine is configured to use a specific GEO_HIERARCHY where the POSTAL_CODE is truncated. The desired effect is to have OTM only send a partial POSTAL_CODE to PcMiler for the distance lookup. It is found by researching the logs, that the configured GEO_HIERARCHY is being ignored and the entire POSTAL_CODE is being sent to PcMiler.
For example, a GEO_HIERARCHY is configured to have: ZIP2_COUNTRY (with elements of POSTAL_CODE, with 1->2 offset, and COUNTRY). This is assigned to the Geo Hierarchy ID of the External Distance Engine. Even with this configuration, the logs show a call similar to the following:
Note the entire POSTAL_CODE is sent in this call.
In testing PcMiler directly, it is confirmed that a lookup as follows is acceptable to PcMiler and this is the expected result with the above configuration in OTM:
The reason that this configuration is being attempted, is due to the fact that the actual POSTAL_CODE for the location is not found in PcMiler. Providing a shortened POSTAL_CODE provides a reasonable estimate to the distance.
-- Steps To Reproduce:
1. Create an External Distance Engine where the Geo Hierarchy ID includes a truncated POSTAL_CODE.
2. Create a Rate Distance object using the above External Distance Engine.
3. Run an Ask-OTM -> Distance/Time query using this Rate Distance where the POSTAL_CODE information is assigned to the locations being queried.
In reviewing the logs, the entire POSTAL_CODE is sent to PcMiler, as seen in the following call:
Example: pcmscalcdistance2("88190,FR","SE1 7NJ,UK",0)
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