Issue In Cycle Arrear Discount Calculation Due To Incorrect Charged_from/Charged_to Dates (Doc ID 3076212.1)

Last updated on MARCH 20, 2025

Applies to:

Symptoms

The user is observing incorrect discount calculation in below scenario.

1. Create an account on 1st Feb 2024, purchase a cycle forward product and cycle arrear product and a discount on cycle arrear on 1st Feb 2024. BDOM 1.
2. Perform billing every month till 1st May 2024 (i.e run billing for Feb, March and April) and see charges are applied as per the configuration and very thing is as expected so far.
3. Move pvt to 17th May and inactivate the account with effective as 1st May 2024 by calling PCM_OP_CUST_SET_STATUS.
4. Move pvt to 1st June and perform billing.
5. Move pvt to 1st July and perform billing.
6. Move pvt to 5th July and activate the account with effective date as 1st July 2024 by calling the opcode PCM_OP_CUST_SET_STATUS.

At this step, it is oberved the cycle arrear's charged_from_t 1st May 2024 and charged_to_t 1st August 2024, which is not correct.
It should ideally be 1st July 2024 to 1st August 2024 as re-activation effective_t is from 1st July and this is causing incorrect calculation of discount to be given when run the billing for July month.

After this, when move pvt to Aug 1 to run billing, see that the charges for cycle forward are applied as expected, whereas charges for cycle arrear are not applied correctly.

The pricing configuration is set as below 

Cause

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