Generate Time Zone For Locations Concurrent Program Does Not Update Canadian Locations
(Doc ID 2323183.1)
Last updated on OCTOBER 31, 2017
Applies to:Oracle Trading Community - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Geography Hierarchy
“Generate Time Zone for Locations" concurrent program does not update hz_locations.timezone_id due to there is no value at the HZ_TIMEZONE_MAPPING.province, all Canadian province information is stored in HZ_TIMEZONE_MAPPING.state
Canadian province value should be in HZ_TIMEZONE_MAPPING.province
Running “Generate Time Zone for Locations" concurrent program should populate a value in hz_locations.timezone_id for Canadian Addresses
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!