Prorate Product Refundation Based on Start and End Date (Doc ID 2339708.1)

Last updated on SEPTEMBER 27, 2022

Applies to:

Goal

This document will try to clarify the following question:

Is there a way to change the refund algorithm in Billing and Revenue Management (BRM), after end date modification inward period cycle of a prorated product?

Scenario could be like this:
(30_day_prorate flag enabled in CM)
Assuming there is an account with CYCLE DOM =1, some service and a prorated product (cycle_forward) is subscribed, on full cycle (let it be 20.05$) and having end_t not defined (value 0). A 20.05$ cycle_forward balance impact is then generated.
After modification of end_t of this product, for example to 3rd day after DOM, a negative amount of refund is generated, which is calculated as:
    (30-3)/30 = 0.9 (scale) , 20.05$ * 0.9 = 18.045$ ( round2, 18.05$ )

The goal of this request is to change the Out of the Box (OOB) functionality and make full refund of 20.05$ and then apply the charge calculated as:
    3/30 = 0.1 (scale), 20.05$ * 0.1 = 2.005 ( round2 2.01$ )

There is an obvious reason of that, because the final amount in 1st case is different then the 2nd one:
in 1) case we got 20.05$ - 18.05$ = 2$ fee
in 2) case we got 20.05$ - 20.05$ + 2.01$ = 2.01$ fee

Solution

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