Cannot Save Service Request If Any Date Is The Hour Of Dst Changes - Illegal Local Time Error Occurs Or The Labor Debrief Times Are Not Saved Correctly.

(Doc ID 1585216.1)

Last updated on APRIL 26, 2018

Applies to:

Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Create Service Request

When attempting to enter a time between the hour where the DST changes began,
the following error occurs.

Error

java.sql.SQLException: Illegal local time

Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Change the time zone to (GMT +03:00 Athens) in Preferences
DST began on 31-Mar-2013 at 3:00:00 am, and will end on 27-Oct-2013 at 4:00:00 am.

2. Input ‘31/03/2013 03:45:11’ in Incident Date.

3. Save, the below error would occur:
java.sql.SQLException: Illegal local time


Note: At times, when the Labor debrief is saved with the Scheduled Start and Scheduled End dates... These date times are not getting converted in the Client Timezone... They are saved as is. This is incorrect, the Times should be converted and saved in Server Timezone in the DB and when again re-queried the same should be converted based upon the client timezone and displayed back to the UI.

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