External Engine Geo-Hierarchy Component Offsets not Truncating the Postal Codes (Doc ID 793867.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.05 to 5.5.05.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.05:OTM is not trimming the country postal code based on the address component off sets that is
defined on external distance engine's Geo hierarchy.

EXPECTED BEHAVIOR
OTM should use the start and end address component off sets to trim how many character to be sent to PcMiler. For example, if the start off set=1 and end off set=5 the OTM should send only the first 5 characters form the country postal code and not the complete string.

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

1- Navigate to Transportation Planning and Execution > Power Data > Geography > External
Distance Engine > Define a New External Distance Engine.
2- Use a Geo Hierarchy for USA with postal code component with start offset = 1 and end offset = 5.
3- Use location with postal code = 81657 ND.
4- OTM should send out 81657 in the query to PcMiler and not 81657 ND.

From the logs you can see: pcmscalcdistance2("94903,US","81657 ND,US",0)

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