This error appears when benefit field is selected at the top. We have provided proper validation for that as to select Employee fields at the top.
But when all fields are selected using moveall button, benefit fields goes to the top and employee fields appears at the bottom. To resolve this issue we need more time for analysis.

CC:Jyoti Agrawal, Prasanna Karlekar

Hi Venkatesh Pujari,

The employee fields No. of Working hours per day and Last Login have some DB query issue. These are reported under tickets WT-7290 and WT-8852.

Please test this item without selecting above mentioned fields.

Regards,
Harshada

Hi Harshada Borole,

I have tested this issue on LB on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation. This is ready for stage.

Sachin Hingole

Thanks,
Venkatesh

Hi Harshada Borole,

I have tested this issue on Stage on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation. This is ready for Production.

Sachin Hingole

Thanks,
Venkatesh

Hi Harshada Borole,

Please could you verify this. I am still getting an error while generating a report for all fields except no. of working hours and login status as there is no last login field on production 3 companies.

Prasanna Karlekar

Thanks,
Venkatesh

Below are 3C's :-
Concern :- Error in generating invoice when we select all Employee fields for display fields in production
Cause :- There were discrepancies in fields ID in local and production database.
Correction :- We have remove few fields which were report specific but were not required in invoice. The IDs for these were causing issue.
Removed fields are :-

• Category Name
• Affordable Coverage
• Employee Monthly Average Working Hours
• Employee Stable Working Hours
• Document Name

Note :- We have also Changed the two 'Effective Date' fields that were appearing in Employee Fields. We have renamed them to 'Emergency Contact Effective Date', Employee Effective Date'. This was a new change in WT-7867 for Standard reports, which we have handled in invoice.

Affected Areas :-
1)Create Invoice Template page :-
Above mentioned removed fields will appear no more
Two Effective date fields Changed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'. Effective dates will appear with deployment of WT-7867.
2)Generation of invoice
3)Download of excel file

Affected DB Files :-
OES_UDF_GetBenefitInvoiceMappingFields
OES_SP_Get_EmployeeFieldsForReports
OES_SP_GetInvoiceMappingFields

Tested below scenarios :-
1) Fields 'Category Name,Affordable Coverage,Employee Monthly Average Working Hours,Employee Stable Working Hours,Document Name' do not appear for selection
2) Two Effective date fields renamed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'
3) Invoice generation by selecting all fields excluding 'No of working hours per day' and 'Last Login Date'.
4) If above change is affecting existing Invoice template in BCC companies
5) Download Excel file for Invoice

Hi Jyoti Agrawal,

Tested this on LB on Caiso company. Working fine as expected. Ready for stage

Thanks,
Venkatesh

Hi Jyoti Agrawal,

Tested this on Stage on Austin For Hspl company.I have tested this issue on Stage on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation.

Ready for Production

Thanks,
Venkatesh