Questions On Timezone (Doc ID 785998.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2013***
***Checked for relevance on 09-Feb-2015***

Goal

Customer has a server running on GMT time and they are trying to rate an event according to its local setting timezone. They defined rating according to the local time zone in the product. They uses the following simple input flist for load_session:

op_act_load_session input flist:

# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 108100 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip 110404 17
0 PIN_FLD_PROGRAM_NAME STR [0] "sample_act"
0 PIN_FLD_START_T TSTAMP [0] (1320795407) Tue Nov 8 23:36:47 2011
0 PIN_FLD_END_T TSTAMP [0] (1320795408) Tue Nov 8 23:36:48 2011
0 PIN_FLD_TIMEZONE_ID STR [0] "Europe/Madrid"


The flist is generated from sample_act. From the robj of the session event it is observed that
PIN_FLD_TIMEZONE_ADJ_END_T and PIN_FLD_TIMEZONE_ADJ_START_T are same with PIN_FLD_CREATED_T value.

The partial output of robj of the session event generated is shown  as below:

nap(5987)> robj - 0.0.0.1 /event/session 116811
# number of field entries allocated 55, used 54
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/session 116811 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1320795417) Tue Nov 8 23:36:57 2011
-
-
0 PIN_FLD_TIMEZONE_ADJ_END_T TSTAMP [0] (1320795417) Tue Nov 8 23:36:57 2011
0 PIN_FLD_TIMEZONE_ADJ_START_T TSTAMP [0] (1320795417) Tue Nov 8 23:36:57 2011
0 PIN_FLD_TIMEZONE_ID STR [0] "Europe/Madrid"
-
-


Here the questions are:

Q1: Why these values of PIN_FLD_TIMEZONE_ADJ_END_T and PIN_FLD_TIMEZONE_ADJ_START_T are same with PIN_FLD_CREATED_T ?

Q2: Is the field PIN_FLD_TIMEZONE_ID implemented in ACCOUNT_T table ?

Solution

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