Charge Is Applied For Inactive Period If Deal Is Cancelled During Inactive Status And Reactivated (Doc ID 1619717.1)

Last updated on FEBRUARY 13, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.

Symptoms

On :  7.4.0.16.0 version, Billing

If account is in inactive status and an existing deal/product configured for monthly cycle_forward_arrear charging is cancelled, and sometime later account is reactivated, the charges for inactive period is also applied.

ACTUAL BEHAVIOR  
---------------
Charge is applied for inactive period if deal is cancelled during inactive status and reactivated.

EXPECTED BEHAVIOR
-----------------------
No charge for inactive period should be applied if deal is cancelled during inactive status and reactivated.

STEPS
-----------------------
The issue can be reproduced with these two settings added to cm/pin.conf:

- fm_bill change_start_time_on_activation 0
- fm_bill deal_purchase_for_closed_account 1

Pricing configuration:

---------------------
1- create account level product "Abo MultiLine", Monthly Cycle Arear, proratable, discountable, scale amount US$17
2- create account level deal/plan "Abo MultiLine" to link with above product.

Steps:
======
1- 01.Jan.2013 - Create a subscription account DOM =1 with above plan.
2- 01.Mar.2013 - Do billing, 2 new Bills of  $17 each.
3- 01.Mar.2013 - Inactivate the account.

> testnap
===> database 0.0.0.1 from pin.conf "userid"
nap(11102)> r inactive.nap 1
nap(11102)> d 1
# number of field entries allocated 20, used 4
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 1
0 PIN_FLD_PROGRAM_NAME    STR [0] "testnap"
0 PIN_FLD_END_T        TSTAMP [0] (1362178800) Fri Mar  1 15:00:00 2013
0 PIN_FLD_STATUSES      ARRAY [0] allocated 20, used 2
1     PIN_FLD_STATUS         ENUM [0] 10102
1     PIN_FLD_STATUS_FLAGS    INT [0] 64
nap(11102)> xop PCM_OP_CUST_SET_STATUS 0 1
xop: opcode 62, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 1
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 2219975 1
1     PIN_FLD_POID           POID [0] 0.0.0.1 /event/customer/status277340812992441414 0
nap(11102)> q

4. 01.Jul.2013 - Do billing, 4 new Bills of $0 each.
5. 04.Jul.2013 - Cancel existing deal by setting end date for the account.

> testnap
===> database 0.0.0.1 from pin.conf "userid"
nap(11906)> r cancel.nap 1
nap(11906)> d 1
# number of field entries allocated 20, used 5
0 PIN_FLD_PRODUCTS      ARRAY [0] allocated 20, used 5
1     PIN_FLD_PRODUCT_OBJ    POID [0] 0.0.0.1 /product 2138734 9
1     PIN_FLD_OFFERING_OBJ   POID [0] 0.0.0.1 /purchased_product 2218791 8
1     PIN_FLD_PURCHASE_END_T TSTAMP [0] (1372888800) Wed Jul  3 15:00:00 2013
1     PIN_FLD_CYCLE_END_T  TSTAMP [0] (1372888800) Wed Jul  3 15:00:00 2013
1     PIN_FLD_USAGE_END_T  TSTAMP [0] (1372888800) Wed Jul  3 15:00:00 2013
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 2
0 PIN_FLD_SERVICE_OBJ    POID [0] 0.0.0.0  0 0
0 PIN_FLD_PROGRAM_NAME    STR [0] "testnap"
0 PIN_FLD_END_T        TSTAMP [0] (1372888800) Wed Jul  3 15:00:00 2013
nap(11906)> xop PCM_OP_SUBSCRIPTION_SET_PRODINFO 0 1
xop: opcode 132, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 2
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 3
1     PIN_FLD_SERVICE_OBJ    POID [0] 0.0.0.0  0 0
1     PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 2219975 2
1     PIN_FLD_POID           POID [0] 0.0.0.1 /event/billing/product/action/modify 17592188267909 0
nap(11906)>

6. 04.Jul.2013 - Reactivate the account

> testnap
===> database 0.0.0.1 from pin.conf "userid"
nap(12034)> r reactive.nap 1
nap(12034)> d 1
# number of field entries allocated 20, used 4
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 1
0 PIN_FLD_PROGRAM_NAME    STR [0] "testnap"
0 PIN_FLD_END_T        TSTAMP [0] (1372888800) Wed Jul  3 15:00:00 2013
0 PIN_FLD_STATUSES      ARRAY [0] allocated 20, used 2
1     PIN_FLD_STATUS         ENUM [0] 10100
1     PIN_FLD_STATUS_FLAGS    INT [0] 64
nap(12034)> xop PCM_OP_CUST_SET_STATUS 0 1
xop: opcode 62, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 1
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 2219975 1
1     PIN_FLD_POID           POID [0] 0.0.0.1 /event/customer/status 279539836247993339 0
nap(12034)>

7. 05.Jul.2013  - run pin_cycle_fees with cancel option. pin_cycle_fees -defer_cancel, $69.10 got charged and shown in Bill In Progress.

> pin_cycle_fees -defer_cancel
Default search level is Account.

cm.pinlog has:

        op_subscription_cancel_product return flist
# number of field entries allocated 20, used 3
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 2219975 16
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 10
1     PIN_FLD_CYCLE_INFO   SUBSTRUCT [0] allocated 20, used 5
2         PIN_FLD_CYCLE_START_T TSTAMP [0] (1362124800) Fri Mar  1 00:00:00 2013
2         PIN_FLD_CYCLE_END_T  TSTAMP [0] (1372834800) Wed Jul  3 00:00:00 2013
2         PIN_FLD_FLAGS           INT [0] 33554448
2         PIN_FLD_ORIGINAL_SCALE DECIMAL [0] 1
2         PIN_FLD_SCALE        DECIMAL [0] 4.064516129032258
1     PIN_FLD_BAL_IMPACTS   ARRAY [0] allocated 20, used 18
2         PIN_FLD_ACCOUNT_OBJ    POID [0] 0.0.0.1 /account 2219975 16
2         PIN_FLD_PRODUCT_OBJ    POID [0] 0.0.0.1 /product 2138734 0
2         PIN_FLD_TAX_CODE        STR [0] ""
2         PIN_FLD_RATE_OBJ       POID [0] 0.0.0.1 /rate 2140782 1
2         PIN_FLD_RATE_TAG        STR [0] "Rate 1"
2         PIN_FLD_IMPACT_CATEGORY    STR [0] "default"
2         PIN_FLD_OFFERING_OBJ   POID [0] 0.0.0.1 /purchased_product 2218791 14
2         PIN_FLD_LINEAGE         STR [0] NULL str ptr
2         PIN_FLD_GL_ID           INT [0] 0
2         PIN_FLD_QUANTITY     DECIMAL [0] 1.00000000
2         PIN_FLD_IMPACT_TYPE    ENUM [0] 1
2         PIN_FLD_DISCOUNT     DECIMAL [0] 0
2         PIN_FLD_PERCENT      DECIMAL [0] 4.064516129032258
2         PIN_FLD_AMOUNT       DECIMAL [0] 69.10              <-------------------------------
2         PIN_FLD_RESOURCE_ID     INT [0] 840
2         PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2         PIN_FLD_BAL_GRP_OBJ    POID [0] 0.0.0.1 /balance_group 2219559 9
2         PIN_FLD_ITEM_OBJ       POID [0] 0.0.0.1 /item/misc 2195951 0
...


BUSINESS IMPACT
----------------------
End customer is charged even for inactive period.

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