Generate Time Zone for Locations concurrent Request is not updating the Last_update_date column in HZ_Locations Table
Last updated on FEBRUARY 06, 2017
Applies to:Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Oracle Trading Community
Generate Time Zone for Locations Concurrent request, Last update date is not updated for HZ_LOCATIONS when a timezone is updated.
The program "Generate Time Zone" for Locations populates in HZ_LOCATIONS Table, TIMEZONE_ID by referring the ID for a given geography from HZ_TIMEZONE_MAPPING table.
The code updates only TIMEZONE_ID ID in Hz_LOCATIONS Table. Last update date is not updated for HZ_LOCATIONS when a timezone is updated.
The issue can be reproduced at will with the following steps:
-Navigate to Trading community manager Responsibility
-Submit Generate Time Zone for Locations
-Overwrite existing Time zone Y
-Verify the last_update_date is not updating in Hz_locations table after the submission of the concurrent request.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms