Hi Jyoti Agrawal,

Tested this issue on Production on Community Development Commission 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

Hi Jyoti Agrawal,

Tested this issue on Stage on AFI for hspl. 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 All,
Keeping the ticket on hold, as it has not been approved for stage deployment
Regards
Gaurav

Hi Jyoti Agrawal,

Tested this issue on LB on City of Durham for hspl. 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

As discussed with Rakesh Roy, assigning this jira to you

CC : Sachin Hingole Prasad Pise

Please check this.

Prasad Pise Venkatesh Pujari

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 All,

Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg

Regards
Gaurav