Cycle Fees Incorrectly Applied When DOM Is Changed

Last updated on JUNE 05, 2018

Applies to:

Goal

Business Scenario :

We have accounts with quarterly, semi-annual and annual bill frequency with DOM as 7. We want to change the DOM to 1.

Steps to reproduce :

1. Change pin_virtual_time to 10 Oct 2011.
2. Create an account with quarterly bill cycle with DOM as 7 and purchase quarterly cycle forward product having some currency balance impacts.
3. System applies a quarterly cycle fee as below ( FROM , TO , SCALE is shown below). And current bill cycle is 10 Oct 2011 to 7 Jan 2012.
   10-OCT-11 12:30:00    07-JAN-12 13:30:00    0.967391304347826
4. Now using PCM_OP_CUST_SET_BILLINFO change the DOM to 1
5. The current bill cycle becomes 10 Oct 2011 to 1 Jan 2012
6. Change pin_virtual_time to 1 Jan 2012 and run billing
7. System generates bill , but no cycle fee is applied from 7th Jan to 1st March. This is as expected.
8. Change pvt to 1 Feb ( this is actg_next_t) and run billing. Cycle fees is applied , but the cycle dates seem incorrect , not aligned with bill cycle :
   07-JAN-12 13:30:00    01-MAY-12 12:30:00    1.271739130434782

Expectation :

1. In step 5 , the bill cycle should remain unchanged ( 10 Oct to 07 Jan ).
2. On 07 Jan when we run billing , the cycle fees should be applied from 07Jan to 01April and the bill cycle should now show : 07Jan to 01April

Solution