Ganesh Sadawarte : Please check this

__________________
Satya Suraj Sokasane

Password shared with Ganesh Sadawarte.

Regards,
Satya Prakash

Hi Chris Ellenberger,

Here are the details:

Concern:
Election Import shows "Import Failed" on CVHP.

Cause:
There's and issue in election import for the date format selected on template (YYYYMMDD). System directly tries to covert this to Date and throws exception. We are looking into the code for possible cause.

Workaround
For now you can change the date format on file as well as template and load the file. This will work as the problem only exists for YYYYMMDD format.
We tried this on HSPL Copy and the record was thrown to bad, with Error Reason:
"Enrollment Effective Date can not be set prior to New Hire Effective Date."

The Employment date of employee is 02/26/2018 which makes him/her eligible from 04/01/2018(New Hire Effective Date) according to new hire rule. But the effective date for election given on file is 03/01/2018. You might need to change it.

We'll update you on our progress about code issue.

Hi Chris Ellenberger,

We were able to identify the root cause. There's missing conversion of date format for YYYYMMDD format. The Import fails if:

1. It's election Import
2. The date format on template is YYYYMDD
3. The employee is New Hire.

In above case, system tries to compare the new hire effective date with election effective date and fails as the date is not converted to MM/DD/YYYY.

This will need code change and can be planned in upcoming sprints. Please let us know the priority for this.

CC - Vinayak Kulkarni, Ganesh Sadawarte

Hi All,

Below are the details we found after researching :

• Import used to replace the Enrollment Effective date given on file with New Hire Effective date if New hire effective is greater.
• Under WT-9271, the request was to send such record to bad rather than replacing it.
• In comparison of Enrollment Effective date and New Hire Effective Date, there was a missed scenario which caused process failure if date format is YYYYMMDD.

CC- Satya, Vinayak Kulkarni, Ganesh Sadawarte

Hi,

Please refer attached test cases:
WT_Sprint-46_WB_626_Sanjanajadhav.xls

Thanks,
Sanjana Jadhav

CC: Prasad Pise Rakesh Roy Suraj Sokasane Ganesh Sadawarte

Hi All,

Changed Dev due date to 4/10/2018 due to WB-583 and code merging issue due to import refactoring.

Thanks,
Ganesh

Hi Sanjana Jadhav,

We have checked attached scenario. For below scenario record should sent to bad file not successfully import.
To Verify election import for date format YYYYMMDD for employees who are eligible for new hire mode when Enrollment effective date < New hire effective date

CC-Vinayak Kulkarni,Suraj Sokasane,Hrishikesh Deshpande

Thanks,
Ganesh

Verified on LB.
Company: For QA-CHMC-Azure
Updated test cases as per comment and Verified all attached test cases.
1.Enter wrong date format-Enrollment Effective Date: Date Format Mismatch With Template-Pass
2.when Enrollment effective date < New hire effective date -Enrollment Effective Date can not be set prior to New Hire Effective Date. -Pass
3.when Enrollment effective date < New hire effective date -Pass
4.Verified for all date format-Pass
Working as expected.Ready for pre production.

Thanks,
Sanjana Jadhav

CC: Prasad Pise Sachin Hingole Rakesh Roy

Verified on Pre production.
Company: Charleys For HSPL
Updated test cases as per comment and Verified all attached test cases.
1.Enter wrong date format-Enrollment Effective Date: Date Format Mismatch With Template-Pass
2.when Enrollment effective date < New hire effective date -Enrollment Effective Date can not be set prior to New Hire Effective Date. -Pass
3.when Enrollment effective date < New hire effective date -Pass
4.Verified for all date format-Pass
Working as expected.Ready for Production.

Thanks,
Sanjana Jadhav

CC: Sachin Hingole Prasad Pise Rakesh Roy

Hi Chris Ellenberger

The issue has been resolved and also tested on Production. Please could you verify at your end and close this ticket.

Thanks,
Sanjana Jadhav

CC: Prasad Pise Sachin Hingole Rakesh Roy