Daylight Saving Time is Controlled Differently on UI for Report Date Fields (Doc ID 2172129.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On the 'Report Details' window opened by clicking report icon on Case Form >> Regulatory Reports, Daylight Saving Time adjustment for displayed value is controlled differently for Date fields.

Daylight Saving Time adjustment is controlled by;
-- CONTROL_TABLE for 'Date Generated' and 'Data Submitted' fields
-- Client PC OS setting for 'Date Transmitted' field.

As the results, sometimes Date Transmitted is shown as before Date Generated, and sometimes Data Submitted is shown as before Date Transmitted.

SAMPLE SCENARIO:
--------------------------

[A] On Argus Safety environment where CONTROL_TABLE.DST_USED = Null:

1) Create a new case and schedule a report.

2) Set a sample date time value '02-JUN-2016 12:00:00' at DATE_GENERATED, DATE_SUBMITTED and DATE_XMIT columns of CMN_REG_REPORTS table for the report
by SQL.

3) Open Report Details for the report on Client PC with OS timezone of GMT+09:00:

Report Details:

Date Generated   --- 02-JUN-2016 21:00
Data Submitted    --- 02-JUN-2016 21:00
Date Transmitted --- 02-JUN-2016 21:00

4) Open Report Details for the report on Client PC with OS timezone of GMT-08:00 with 'Automatically adjust adjust clock for Daylight Saving Time' = Yes:

Report Details:

Date Generated   --- 02-JUN-2016 05:00
Data Submitted    --- 02-JUN-2016 05:00
Date Transmitted --- 02-JUN-2016 05:00

5) Open Report Details for the report on Client PC with OS timezone of GMT-08:00 with 'Automatically adjust adjust clock for Daylight Saving Time' = No:

Date Generated   --- 02-JUN-2016 05:00
Data Submitted    --- 02-JUN-2016 05:00
Date Transmitted --- 02-JUN-2016 04:00 <--- Xmit date is before Generated.

[B] On Argus Safety environment where = CONTROL_TABLE.DST_USED = 1:

1) Create a new case and schedule a report.

2) Set a sample date time value '02-JUN-2016 12:00:00' at DATE_GENERATED, DATE_SUBMITTED and DATE_XMIT columns of CMN_REG_REPORTS table for the report by SQL.

3) Open Report Details for the report on Client PC with OS timezone of GMT+09:00:

Report Details:
Date Generated   --- 02-JUN-2016 21:00
Data Submitted    --- 02-JUN-2016 21:00
Date Transmitted --- 02-JUN-2016 21:00

4) Open Report Details for the report on Client PC with OS timezone of GMT-08:00 with 'Automatically adjust adjust clock for Daylight Saving Time' = Yes

Report Details:
Date Generated   --- 02-JUN-2016 04:00
Data Submitted    --- 02-JUN-2016 04:00 <--- Submitted date is before Xmitted
Date Transmitted --- 02-JUN-2016 05:00

5) Open Report Details for the report on Client PC with OS timezone of GMT-08:00 with 'Automatically adjust adjust clock for Daylight Saving Time' = No

Date Generated   --- 02-JUN-2016 04:00
Data Submitted    --- 02-JUN-2016 04:00
Date Transmitted --- 02-JUN-2016 04:00

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.