My Oracle Support Banner

The Import Shipping Locations Program is Failing With Error in WSH_GEOCODING.Get_Lat_Long_and_TimeZone (Doc ID 391679.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
WSHLOCMB.pls 115.36.11510.5
WSHMLORB.pls 115.32.11510.5
WSHMLORS.pls 115.10.11510.2
WSHRESES.pls 115.14.11510.4
WSHRESEB.pls 115.42.11510.5
wshfnidx.sql 115.10.11510.2

Symptoms

On 11.5.10 in Production:

Applied patch 4616860 to resolve this error, but when attempting to run the Import shipping locations program for more than 1 instance, the following error still occurs:

 
ERROR
________

Get_Missing_Timezones : Error in WSH_GEOCODING.Get_Lat_Long_and_TimeZone


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

1.Using the OM Superuser Responsibility
2.Shipping> Interfaces>Import Shipping Locations
3.Enter the following parameters:
Map Regions: Yes
Location Type: Both
Number of Instances: 5
Start Date: {blank}
End Date: {blank}
4. Submit

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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