Generate Time Zone For Locations Concurrent Program Does Not Update Canadian Locations
(Doc ID 2323183.1)
Last updated on FEBRUARY 18, 2019
Oracle Trading Community - Version 12.2.6 and later Information in this document applies to any platform.
On : 12.2.6 version, Geography Hierarchy
ACTUAL BEHAVIOR --------------- “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
EXPECTED BEHAVIOR ----------------------- 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!