Plan Transition Fixes on Oracle BRM 7.3.1

(Doc ID 880097.1)

Last updated on SEPTEMBER 02, 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]
Information in this document applies to any platform.
Checked for relevance on 06-Aug-2013.

Symptoms

Incorrect charge after plan transition.

-- Steps To Reproduce:

1. Created a plan with option Plan1 having a deal with two products: 
Having purchase fee, session event and Monthly CF.  Cycle set to 1 for usage and cycle at deal level.

2. Created a plan with option Plan2 having a deal with two products:  Having purchase fee, session event and QCF. Cycle set to 3 for usage and cycle at deal level.

3. Configured Plan transition for Plan2 such that P and C is set for waiving purchase and cancellation fees.
4. Created account on July 12th with Plan Plan1.

nap(29720)> robj - $DB /purchased_product 2168229
# number of field entries allocated 45, used 44
0 PIN_FLD_POID POID [0] 0.0.0.1 /purchased_product 2168229 1
0 PIN_FLD_CREATED_T TSTAMP [0] (1310481679) Tue Jul 12 20:11:19 2011
0 PIN_FLD_MOD_T TSTAMP [0] (1310481681) Tue Jul 12 20:11:21 2011
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 2170661 0
0 PIN_FLD_CYCLE_DISCOUNT DECIMAL [0] 0
0 PIN_FLD_CYCLE_DISC_AMT DECIMAL [0] 0
0 PIN_FLD_CYCLE_END_DETAILS INT [0] 6148
0 PIN_FLD_CYCLE_END_T TSTAMP [0] (1313087400) Fri Aug 12 00:00:00 2011
0 PIN_FLD_CYCLE_FEE_AMT DECIMAL [0] 0
0 PIN_FLD_CYCLE_FEE_FLAGS INT [0] 1
0 PIN_FLD_CYCLE_START_DETAILS INT [0] 1
0 PIN_FLD_CYCLE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
0 PIN_FLD_DEAL_OBJ POID [0] 0.0.0.1 /deal 2039828 0
0 PIN_FLD_DESCR STR [0] ""
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1310481675) Tue Jul 12 20:11:15 2011
0 PIN_FLD_FLAGS INT [0] 3
0 PIN_FLD_INSTANTIATED_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
0 PIN_FLD_MMC_TYPE INT [0] 0
0 PIN_FLD_NODE_LOCATION STR [0] ""
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_OVERRIDDEN_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_PACKAGE_ID INT [0] 116
0 PIN_FLD_PLAN_OBJ POID [0] 0.0.0.1 /plan 2040852 0
0 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 2043108 2
0 PIN_FLD_PURCHASE_DISCOUNT DECIMAL [0] 0
0 PIN_FLD_PURCHASE_DISC_AMT DECIMAL [0] 0
0 PIN_FLD_PURCHASE_END_DETAILS INT [0] 0
0 PIN_FLD_PURCHASE_END_T TSTAMP [0] (0) <null>
0 PIN_FLD_PURCHASE_FEE_AMT DECIMAL [0] 0
0 PIN_FLD_PURCHASE_START_DETAILS INT [0] 1
0 PIN_FLD_PURCHASE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
0 PIN_FLD_QUANTITY DECIMAL [0] 1
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip 2167205 0
0 PIN_FLD_SPONSOR_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_STATUS ENUM [0] 1
0 PIN_FLD_STATUS_FLAGS INT [0] 0
0 PIN_FLD_USAGE_DISCOUNT DECIMAL [0] 0
0 PIN_FLD_USAGE_END_DETAILS INT [0] 6148
0 PIN_FLD_USAGE_END_T TSTAMP [0] (1313087400) Fri Aug 12 00:00:00 2011
0 PIN_FLD_USAGE_START_DETAILS INT [0] 1
0 PIN_FLD_USAGE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
0 PIN_FLD_CYCLE_FEES ARRAY [1] allocated 20, used 6
1    PIN_FLD_CHARGED_FROM_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
1    PIN_FLD_CHARGED_TO_T TSTAMP [0] (1313087400) Fri Aug 12 00:00:00 2011
1    PIN_FLD_COUNT INT [0] 1
1    PIN_FLD_CYCLE_FEE_END_T TSTAMP [0] (1313087400) Fri Aug 12 00:00:00 2011
1    PIN_FLD_CYCLE_FEE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
1    PIN_FLD_UNIT ENUM [0] 0

5. Moved pvt to July 15th. Transitioned from Plan Plan1 to Plan2.

nap(29806)> robj - $DB /purchased_product 2176312
# number of field entries allocated 45, used 44

...
0 PIN_FLD_CYCLE_START_T TSTAMP [0] (1310668200) Fri Jul 15 00:00:00 2011
0 PIN_FLD_CYCLE_END_T TSTAMP [0] (0) <null>
0 PIN_FLD_USAGE_START_DETAILS INT [0] 1
0 PIN_FLD_USAGE_START_T TSTAMP [0] (1310668200) Fri Jul 15 00:00:00 2011
0 PIN_FLD_CYCLE_FEES ARRAY [1] allocated 20, used 6
1    PIN_FLD_CHARGED_FROM_T TSTAMP [0] (1310668200) Fri Jul 15 00:00:00 2011
1    PIN_FLD_CHARGED_TO_T TSTAMP [0] (1318357800) Wed Oct 12 00:00:00 2011
1    PIN_FLD_CYCLE_FEE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
1    PIN_FLD_CYCLE_FEE_END_T TSTAMP [0] (1318357800) Wed Oct 12 00:00:00 2011
...


PROBLEM 1 ====> As the PIN_FLD_CYCLE_FEE_END_T is updated as Oct 12 00:00:00 2011, the customer will get charged on Oct 12-2011 instead of 15th Oct 2011( 3 months cycle fee event) Moreover, customer is charged only for the days from 15 Jul 2011 to 12 Oct 2011.


Expected Result: As the customer is changing his plan (transition) , he should get new validity
(purchased Jul 15 2011) till Oct 15th 2011 .
To note this problem, see the following fields which are showing as : 12th instead of 15th.

1 PIN_FLD_CHARGED_TO_T TSTAMP [0] (1318357800) Wed Oct 12 00:00:00 2011
1 PIN_FLD_CYCLE_FEE_START_T TSTAMP [0] (1310409000) Tue Jul 12 00:00:00 2011
1 PIN_FLD_CYCLE_FEE_END_T TSTAMP [0] (1318357800) Wed Oct 12 00:00:00 2011


6. Moved pvt to July 16th 2011.

7. Run pin_bill_day. Observation:
PROBLEM 2 ========>
Account will not be billed but in the event browser, one can see that the purchase fees got applied again. ---This should not get applied because P is selected in Plan transition.
Expected Result: As we selected "P=waives purchase fees. and C=waives cancellation fees.", this charge should not apply.

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