My Oracle Support Banner

Brazilian Province Does Not Exist On TIME_ZONE_LOCALE Table (Doc ID 2553481.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Transportation Management Cloud Service - Version 19 to 19 [Release 19]
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
Brazilian Province does not exist on TIME_ZONE_LOCALE table
When selecting locations Para province is not available for Brazil time zone.


EXPECTED BEHAVIOR
-----------------------
When selecting locations Para province is not available for Brazil time zone.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Integration to create Locations on OTM
2. The Integration has a validation to determine correct Time Zone searching on the TIME_ZONE_LOCALE table what is the TIME_ZONE_GID for their Province.
3. Testing of Integration, realized that Locations from Pará/PA stayed with incorrect Time Zone.

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
Cause
Solution


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