Cancellation on Tier Based Subscription Product Failed on Pro-rating the Charges (Doc ID 2224142.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

On :  7.5.0.14.0 version, Subscription Management

Pro-ration on Cancellation with regard to " Subscription based product with Tiers and resource dependent option" did not work as expected for charges applied back.

PRICING CONFIGURATION
---------------------------------
- created a Subscription product with Monthly Cycle forward fees.
- added three tiers  [0-25]       price $0.40
                               [25-5000]  price $0.10
                               [5000+ ]    price $0.05
- made it as "resource based" on a non currency.
The product in rate tiers has both currency and non currency impact for each tier, the non currency impact is for tracking the quantity of subscriptions during purchase.

STEPS
---------------------
1. purchase the product with Quantity = 40,
    => the first two tiers are applied and the charge is (25 * $0.40) + (15 * $0.10) = $11.5
2. purchase the product with Quantity = 1000
    => the charge is (1000 * $0.10) = $100 based on tier 2.
3. purchase the product with Quantity = 10000
    => the charge is (3960 * $0.10 ) + (6040 * $0.05) = $698 based on tier 2 and tier 3.
    => the non currency resource has a counter of 11040
4, cancel the deal corresponding to 10000 after few days
    => the counter is correctly reduced for cancellation
    => the pro-ration charge of $338.71 is reversed for the last tier only as (10000 * $0.05) = $500,  $500 * 21/31 = $338.71

ACTUAL BEHAVIOR  
----------------------
The cancellation quantity has all been reversed base on the last tier.

EXPECTED BEHAVIOR
-----------------------
It should be reversed base on their corresponding tiers.
So, in net, it must give the 6040 * $0.05 and 3960 * $0.10, i.e. $302 + $396 = $698 back to the end user on cancellation.

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.