PCM_OP_SUBSCRIPTION_CALCULATE_VALIDITY was Calculating Invalid Start_t (Doc ID 1178534.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Linux x86-64
***Checked for relevance on 07-Nov-2013***
Checked for relevance on 20-Jul-2016.

Symptoms

PCM_OP_SUBSCRIPTION_CALCULATE_VALIDITY was calculating a relative START_T incorrectly when the input START_T falled within Apr. 1, 2010 and Apr. 4, 2010.

After that day the calculation was correct. It seemed like a DST issue from the older DST rules.

See the Output FLists START_T field in the examples below the time showed 23:00 instead of 00:00 as the last example.

Steps to Reproduce:
Run this in testnap:

nap(28611)> d 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /service -1 0
0 PIN_FLD_START_T TSTAMP [0] (1270105200) Thu Apr 1 00:00:00 2010
0 PIN_FLD_VALID_FROM_DETAILS INT [0] 13572
0 PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_END_T TSTAMP [0] (0) <null>
nap(28611)> xop PCM_OP_SUBSCRIPTION_CALCULATE_VALIDITY 0 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /service -1 0
0 PIN_FLD_START_T TSTAMP [0] (1277964000) Wed Jun 30 23:00:00 2010
0 PIN_FLD_END_T TSTAMP [0] (0) <null>

nap(28611)> d 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /service -1 0
0 PIN_FLD_START_T TSTAMP [0] (1270364400) Sun Apr 4 00:00:00 2010
0 PIN_FLD_VALID_FROM_DETAILS INT [0] 13572
0 PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_END_T TSTAMP [0] (0) <null>
nap(28611)> xop PCM_OP_SUBSCRIPTION_CALCULATE_VALIDITY 0 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /service -1 0
0 PIN_FLD_START_T TSTAMP [0] (1278223200) Sat Jul 3 23:00:00 2010
0 PIN_FLD_END_T TSTAMP [0] (0) <null>

nap(28611)> d 5
0 PIN_FLD_POID POID [0] 0.0.0.1 /service -1
0 PIN_FLD_START_T TSTAMP [0] (1270450800) Mon Apr 5 00:00:00 2010
0 PIN_FLD_VALID_FROM_DETAILS INT [0] 13572
0 PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_END_T TSTAMP [0] (0) <null>
nap(28611)> xop PCM_OP_SUBSCRIPTION_CALCULATE_VALIDITY 0 5
0 PIN_FLD_POID POID [0] 0.0.0.1 /service/webex/ctp 99778 8
0 PIN_FLD_START_T TSTAMP [0] (1278313200) Mon Jul 5 00:00:00 2010
0 PIN_FLD_END_T TSTAMP [0] (0) <null>


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