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 FEBRUARY 06, 2017

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms