Error With Calculating Proration Amount For Suspense And Cancellation Scenarios (Doc ID 2974460.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Goal

There is a requirement in case of proration for suspense or termination, Billing and revenue management (BRM) should consider the date on which the request was raised.

For example:
1. An account has BDOM of 1st.
2. Suspense request raised on 10th of the month.
3. As per the current proration logic, BRM refunds the amount from the 10th to end of the month and the customer is charged for 1st to 9th.

However, the expectation is that the customer should be charged from the 1st to 10th, including the date of suspend or cancel requirement.
When trying to change the PIN_FLD_SCALE in PCM_OP_SUBSCRIPTION_POL_SPEC_CYCLE_FEE_INTERVAL, this value is multiplied to the factor from fm_subscription_cycle_utils.c.
Changing the start_date or end_date is not an option since the requirement is still to have the dates from the 10th.

How to resolve this issue?

Solution

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