ApplyProrationRules Business Param issue (Doc ID 2258436.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Symptoms

On : 7.5.0.14.0 version, Subscription Management

ACTUAL BEHAVIOR
---------------
Found 2 issues when the ApplyProrationRules business parameter is set to "disabled".


STEPS
-----------------------
Issue 1
-------
When suspending and activating again an offer, the offer is not refunded for the inactivated period.

Steps to reproduce (issue on step 2 and 3):
1) Create an account on 2018/01/30 with the <DEAL1> deal and run MAKE_BILL_NOW.
Expected : Offer charged for 24.991666 for 2018/01/30 - 2018/03/01 period.
Actual : Offer charged for 24.991666 for 2018/01/30 - 2018/03/01 period.

2) Go to 2018/02/05 and suspended the offer while purchasing <DEAL2> within the same transaction
Expected : Offer refunded for 19.993333 for 2018/02/05 - 2018/03/01 period
Actual : No refunded

3) Go to 2018/02/15 and reactivate the offer
Expected : Offer charged for 11.662777 for 2018/02/15 - 2018/03/01 period
Actual : No charge

4) After reactivation, cancel the <DEAL2> offer
Expected : Offer canceled
Actual : Offer canceled

5) Go to 2018/03/01 and run billing.
Expected : Offer charged for 24.991666 for 2018/03/01 - 2018/03/30 period. Total bill = 24.991666 - 19.993333 + 11.662777 = 16.66111. VAT at 20% = 3.332222
Actual : Offer charged for 24.991666 for 2018/03/01 - 2018/03/30 period. Total bill = 24.991666. VAT at 20% = 4.998333

-------
Issue 2
-------
When backdating an account closure while purchasing a "purchase fee" product, some refund is missing

Steps to reproduce (issue on step 2):
1) Create an account on 2018/01/30 with the <DEAL1> deal, CHP_FDP at -192eur and CHP_FACTNORM at 200eur, and run MAKE_BILL_NOW.
Expected : Offer charged for 24.991666, CHP_FDP at -192 and CHP_FACTNORM at 200 for 2018/01/30 - 2018/03/01 period. Total bill : 32.991666. VAT at 20% = 44.998333
Actual : Offer charged for 24.991666, CHP_FDP at -192 and CHP_FACTNORM at 200 for 2018/01/30 - 2018/03/01 period. Total bill : 32.991666. VAT at 20% = 44.998333

2) Go to 2018/03/01. Within the same transaction, purchase CHP_FDP at 192, CHP_FACTNORM at -200 and close the account, all these actions backdated to 2018/01/30.
Expected : Offer <DEAL1> charged for 24.991666 for 2018/03/01 - 2018/03/30 period. <DEAL1> refunded for -24.991666 for 2018/01/30 - 2018/01/03 period and -24.991666 for 2018/03/01 - 2018/03/30. CHP_FDP charged at 192 and CHP_FACTNORM at -200. Total bill : -32.991666. VAT at 20% = -44.998333
Actual : Offer <DEAL1> charged for 24.991666 for 2018/03/01 - 2018/03/30 period. <DEAL1> refunded for -24.991666. Total bill : -8. VAT at 20% = -40

Changes

Cause

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