My Oracle Support Banner

Date Issue While Loading Event Logfile Using UEL After DST Change (Doc ID 1376438.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

Facing an issue while loading data using UEL.Observed the UEL is adding 1 hour to the input date while constructing the input flist for rating the event. JDK version - 1.5.0_06.

Below is the scenario.

Executed the UEL for below input data:

822923499221110,3539560000000011,61429017611,
10.6.20.114,50501,3,225F,4EE9,112831858,10.32.37.18,
svpn,mnc001.mcc505.gprs,33,10.60.92.3,0,1,0,0,0,500,
500,20111005121010,1808,16,,PGGM,800,,,,,,
23383200020111005121010,20111005121010,Mobile Data,0,,


Below is the input flist constructed by UEL for loading the data via custom opcode:

# number of field entries allocated 23, used 22
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/activity/content/tcon/usage -1 0
0 PIN_FLD_QUANTITY DECIMAL [0] -1
0 PIN_FLD_AMOUNT DECIMAL [0] 1
0 TDB_FLD_EXT_VALUE STR [0] "-1"
0 PIN_FLD_AUTHORIZATION_ID STR [0] "TSDP014117823112"
0 PIN_FLD_END_T TSTAMP [0] (1317789684) Wed Oct 05 15:41:24 2011
0 PIN_FLD_START_T TSTAMP [0] (1317789680) Wed Oct 05 15:41:20 2011



The input CDR file contains the input date as '20111005121010'. The input flist constructed by UEL has the START_T as '20111005131010', which is not correct. Here there is a difference of 1 hour between CDR input date and input flist's start date. It looks like this issues are happening after the Day light saving time change.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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