Below are 3C's :-
Concern :- On benefit type name change after invoice generation, results into server error
Cause :- Invoice table is created with fix column, named with benefit name. On benefit name change , during insertion in the table there was a mismatch of column name.
Correction :- Instead of creating column with benefit name, we are using benefit ID to create column as benefit ID will never change.

Affected File :-
Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GetBenefitInvoiceMappingFields.sql
Database Objects/MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_Display_BenefitWiseBilling.sql

Affected Area :-
Invoice Generation
Invoice View
Download Excel File
Invoice table structure

Tested Scenario :-
1) On invoice generation, columns in invoice table for benefits should form with benefit ID
2) Change any benefit name and check if next invoice is generated successfully
3) Checked if new name is displayed in invoice,excel and summary
3) Change demographic fields name and then checked
4) Change additional fields and checked
4) Checked excel download
5) Checked invoice summary

Hi Jyoti Agrawal,

Tested this issue on Codemap on For QA KinderCare company. Working fine as expected. Verified the below listed scenarios :-

1) On invoice generation, columns in invoice table for benefits should form with benefit ID
2) Change any benefit name and check if next invoice is generated successfully
3) Checked if new name is displayed in invoice,excel and summary
4) Change demographic fields name and then checked
5) Change additional fields and checked
6) Checked excel download
7) Checked invoice summary

This is ready for Stage

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Tested this issue on Preprod on TotalWorks For Hspl company. Working fine as expected. Verified the below listed scenarios :-
1) On invoice generation, columns in invoice table for benefits should form with benefit ID
2) Change any benefit name and check if next invoice is generated successfully
3) Checked if new name is displayed in invoice,excel and summary
4) Change demographic fields name and then checked
5) Change additional fields and checked
6) Checked excel download
7) Checked invoice summary

This is ready for Production

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Tested this issue on Prod on City Of Bellevue For Hspl company. Working fine as expected. Verified the below listed scenarios :-
1) On invoice generation, columns in invoice table for benefits should form with benefit ID
2) Change any benefit name and check if next invoice is generated successfully
3) Checked if new name is displayed in invoice,excel and summary
4) Change demographic fields name and then checked
5) Change additional fields and checked
6) Checked excel download
7) Checked invoice summary

Thanks,
Venkatesh