utc_time_offset Initialization Issue when Daylight Saving Is Revoked (Doc ID 1275380.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Symptoms

The UTC_TIME_OFFSET is configured as -0400 which works fine in the timings when daylight saving is present. But when the daylight saving was revoked on 7th Nov, the rating engine is rating the EDRs with a time difference of 1 hour than the actual event time. Events are getting rated with 1 hour less time of what it is there in EDR file.

For example:

The account 1000497 was created on 12-NOV-2010 11:08:49 but while rating this EDR, the rating engine considered EDR time as 1 hour less of what was there in EDR file

Input EDR example:

In the case of above EDR, the time is 11:47:33, but while rating, it has been considered as 10:47:33. Hence EDR is getting rejected with error as "Customer login (001000497) not valid for time (1289576853)". This error is because it checks for account creation time which is currently in the future i.e. 12-NOV-2010 11:08:49

In above case, while rating expected EDR time should be considered as it is mentioned in EDR file i.e. 11:47:33 instead of 10:47:33.

In this example, SIMPLESAMPLE_v1_InMap.dsc input grammar has been used. The pipeline rating engine is rating the EDRs as per UTC offset time -> -0400 currently configured in pipeline but after the daylight saving was revoked the offset time shall be -0500.

The current workaround to this issue is to modify the UTC offset configuration to “-0500” but once the daylight saving is introduced next year this setting needs to be changed again.

Changes

Cause

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