You want that customers will auto-renew to a fixed rollover product and the renewal rate will display in the Contract Expiration Notice (CEN).
There is no need for the Plan Type and Rate Type for given fixed rollover products for a utility to be revised to a 'Fixed' Plan Type and a 'Fixed Rate Calculation' for Rate Type. Updating the ActiveEnrollmentFlag to 1 for these rollover products is sufficient to enable the customers to auto-renew to them and the renewal rate to display in CEN.
Please raise a support ticket with us mentioning the ProductCode for the products that you want us to make the change to. We will update the ActiveEnrollmentFlag for these products and inform you.
Access to the Client database
1. Run the select query below to get the productid for the given products.
Replace the parameter productcode with the given list of product code.
where productcode in ('IL_COMMED_E_24MO_RO', 'IL_COMMED_E_12MO_RO')
2. Run the update query below.
Replace the parameter productid with the values fetched in the previous step.
set ActiveEnrollmentFlag = 1
where productid in (4045, 4046)