Postal Code Not Synchronizing Automatically
(Doc ID 753349.1)
Last updated on MARCH 08, 2017
Applies to:Oracle Transportation Management - Version 5.5.03.06 to 6.0 [Release 5.5 to 6]
Information in this document applies to any platform.
***Checked for relevance on 15-Jun-2010***
-- Problem Statement:
On 5.5.03.06, When attempting to add a Low Range and High Range Value of Canadian Postal Codes in
the Region Screen, the following error occurs:
java.sql.SqlException:ORA-20001:No postal code found between <low Range value> and <High
Range Value> ORA-06512:at "GLOGOWNER.RRL", line
597 ORA-06512:at "GLOGOWNER.RRL", line 675 ORA-06512:at line 1
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create canadian postal codes via Postal Code Latitude/Longitude
2. Add the lowest and highest canadian postal codes in the Low Range and High Range value on the
3. Click finished and the error message appears
-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot add Canadian Postal Code Ranges
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|