Generate Time Zone for Locations concurrent Request is not updating the Last_update_date column in HZ_Locations Table
(Doc ID 2226355.1)
Last updated on JUNE 05, 2024
Applies to:
Oracle Trading Community - Version 12.1.3 and later Information in this document applies to any platform.
Symptoms
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.
STEPS ----------------------- The issue can be reproduced at will with the following steps: -Navigate to Trading community manager Responsibility -Concurrent request -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.
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!