Cycle Discount Charges Are Refunded When Service Status Is Changed To Inactive (Doc ID 2642980.1)

Last updated on JULY 09, 2021

Applies to:

Symptoms

On patch set version 7.5.0.6.0, it was observed that cycle discount charges [PIN_FLD_CYCLE_DISC_AMT] are refunded when service status is changed to inactive in the below scenario.

Scenario:

1. On 1st Feb: Create a customer account with a monthly cycle forward (mcf) product and during purchase, provide "Discount recurring fees" = 100. So CYCLE_DISC_AMT field is populated in purchased_product_t table for this account, and the customer is charged with the Discounted amount.
   
   For example: The cycle forward charge is 500 and CYCLE_DISC_AMT is 100. So /item/cycle_forward will have a due of 400 on ‘01-Feb-20’.
   
   The mcf product has proration rule:
            On purchase in mid of cycle: prorate
            On Cancellation in mid of cycle: Full charge
2. On 28th Feb: Service got suspended using op_cust_set_status with below flist:   
3. When the suspension happened, another /item/cycle_forward of 100 got applied on ‘28-Feb-2020’. See below for example, some details of the events:
   
   ACCOUNT_OBJ_ID0----SERVICE_OBJ_ID0----POID_TYPE----POID_ID0----SYS_DESCR----AMOUNT----PROGRAM_NAME----UTC(E.EARNED_START_T)----UTC(E.EARNED_END_T)
   
   279583192 279736693 /event/billing/product/fee/cycle/cycle_forward_monthly 322288848613207665 Cycle Forward Fees (srvc):MCF 100 TEST 28-Feb-20 1-Mar-20
   279583192 279736693 /event/billing/product/fee/cycle/cycle_forward_monthly 321831451776210041 Cycle Forward Fees (srvc):MCF 400 pin_bill_accts 1-Feb-20 1-Mar-20

Cause

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