-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Type:Functional
-
Bug Severity:Medium
-
Module:BenAdmin - Export
-
Reported by:EDI
-
Company:JE Dunn
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
-
Sprint:WT Sprint 41
Template name: JE DUNN_Discovery Cobra QB_IN_Use_NEW 2017
11/3 file
1. Timothy Benbow is the EE; ISABELLA PIPARO - dependent Child removed during OE:
2. Jesus Plata is the EE, we sent Eryn Eberlein - Divorce QE VERY OLD 2016 Divorce, back in 2016:
11/10 file:
1. EE is Dirk Schafer, removed child Carolyn Schafer form Medical/RX this also went over as a Divorce QE
Can you look at the settings? We dont think this should pass this way
Thank you
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Rakesh Shahane [ rakesh.shahane ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 8h [ 28800 ] | |
| Original Estimate | 8h [ 28800 ] |
| Remaining Estimate | 8h [ 28800 ] | 1.9h [ 6840 ] |
| Time Spent | 6.1h [ 21960 ] | |
| Worklog Id | 94382 [ 94382 ] |
Hi Damion,
We have checked this and found that records for child should not have been populated on file.
However they are populated and that too with incorrect reason code. We are working on fix and will let you know once it is done. Please ask discovery benefits to ignore this event. Thanks.
Tracy Kot Do you have anymore to add fort this one?
Please advise
thanks 
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Support Task Type | Data Correction [ 11203 ] | |
| Workflow | WT_Support [ 58951 ] | WT_Defects [ 59550 ] |
Jennifer Reed (Inactive)
made changes -
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 41 - Bugs [ 95 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 41 - Bugs [ 95 ] |
| Remaining Estimate | 1.9h [ 6840 ] | 0h [ 0 ] |
| Time Spent | 6.1h [ 21960 ] | 9.2h [ 33120 ] |
| Worklog Id | 95280 [ 95280 ] |
| Time Spent | 9.2h [ 33120 ] | 12.2h [ 43920 ] |
| Worklog Id | 95283 [ 95283 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 41 [ 95 ] |
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Rajendra Pawar [ rajendra.pawar ] |
| Dev Due Date | 15/Dec/2017 | |
| Dev Estimates | 28 | |
| Developer | Rajendra Pawar [ rajendra.pawar ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | |
| Original Estimate | 8h [ 28800 ] | 28h [ 100800 ] |
| Dev Due Date | 15/Dec/2017 | 18/Dec/2017 |
| Dev Estimates | 28 | 36 |
| QA | Aniruddha Dev [ aniruddha.dev ] | |
| QA Estimates | 4 |
Hi All,
Attaching the development approval email for your reference
Regards
Gaurav
Gaurav Sodani (Inactive)
added a comment - Hi All,
Attaching the development approval email for your reference
Regards
Gaurav Gaurav Sodani (Inactive)
made changes -
| Approval status | Approved for development [ 18453 ] | |
| Development Approval | Yes [ 18474 ] |
Gaurav Sodani (Inactive)
made changes -
| Stage Due Date | 22/Dec/17 [ 2017-12-22 ] |
Gaurav Sodani (Inactive)
made changes -
| Attachment | FW 1211 Sprint - Development Approval.msg [ 69870 ] |
| Root Cause | Bug [ 18430 ] |
| Time Spent | 12.2h [ 43920 ] | 15.2h [ 54720 ] |
| Worklog Id | 95808 [ 95808 ] |
| Labels | Cobra_File |
| Root Cause | Bug [ 18430 ] | Scenario/Requirement Missed [ 18432 ] |
| Time Spent | 15.2h [ 54720 ] | 20.2h [ 72720 ] |
| Worklog Id | 95949 [ 95949 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Component/s | BenAdmin [ 10000 ] | |
| Issue Importance | Must Have [ 11800 ] |
| Time Spent | 20.2h [ 72720 ] | 26.2h [ 94320 ] |
| Worklog Id | 96167 [ 96167 ] |
| Attachment | WT-12445 Affected Files.txt [ 70147 ] |
| Attachment | Dev Tested Scenarios.xls [ 70160 ] |
Attached is the unit testing document - Dev Tested Scenarios.xls
Below cobra events has been tested in unit testing.
- Employee Termination
- Divorce- Spouse to Ex-Spouse
- Overage Dependent
- Retired
- Class Change
| Bug Type | Functional [ 15402 ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
-
- Time Spent:
- 8h
-
Unit testing done with all cobra events. working fine,
| Time Spent | 26.2h [ 94320 ] | 34.2h [ 123120 ] |
| Worklog Id | 96388 [ 96388 ] |
| Code Review Date | 15/Dec/2017 | |
| Code Reviewed By | Vinalyak Kulkarni [ 12100 ] | |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Rajendra Pawar [ rajendra.pawar ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Getting server error ,while verifying following scenarios
1)Employee termination
2)Retired
3)Class change
Hence,It is* blocked* to test this bug .
*Error Log- *
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeClass->Employee.GetEffectiveDateForEnrollmentMode
ErrorMessage: Conversion from type 'DBNull' to type 'Date' is not valid.
Hence assigning this to you,once it gets fixed , reassign back to me .
Thanks,
Swapnil Eksambekar.
CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeRajendra PawarVinayak Kulkarni
| Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Shailendra Honrao [ shailendra.honrao ] |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Time Spent | 34.2h [ 123120 ] | 36.7h [ 132120 ] |
| Worklog Id | 96858 [ 96858 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
Shailendra Honrao (Inactive)
made changes -
| Assignee | Shailendra Honrao [ shailendra.honrao ] | Umesh Kadam [ umesh.kadam ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: Development(10200) |
| Item State | Parent values: Development(10200) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Umesh Kadam A new issue that I am not sure relates to this or not Steven Golubski terminated COBRA Eligible Benefits 11/20 and should have rolled out in the file 11/24. This was done in the OE Window I think as an Employee Data Change. Can you tell us why his record didnt pass? This is is a VP that termed so it is a Highly Sensitive issue
Thank you
CC Andrea DennisKristi SmithKevin WalkerVinayak KulkarniRajendra PawarHrishikesh DeshpandeAniruddha Dev
| Attachment | Demographics_history.PNG [ 70392 ] |
| Attachment | RunDates.PNG [ 70393 ] |
| Attachment | Enrollment_History.PNG [ 70394 ] |
Hi Damion,
here are details for Steven Golubski not populated on cobra file.
Steven Golubski is terminated from WT on 11/15/2017 via scheduled import, see below
But employee's enrollment did not terminate due to import back-end routine failed and file exported on 11/17/2017, so for this export it found enrollments active and thus it did not roll out on file
and on 11/20/2017 SA terminated elections as part of data correction.
Note: We found one more employee "Brandon Stanley" terminated on same import and did not populate on cobra file.
let us know if you want these records to be forced on next cobra file. Thanks.
As discussed, We have forced these records from back-end, it will populate on next export. Thanks.
| Assignee | Umesh Kadam [ umesh.kadam ] | Snehal Shabade [ snehal.shabade ] |
Please find below 3Cs:
| Concern | Getting server error while changing EE status as terminated |
| Cause | In "JE Dunn" company, 'Terminated' employee status is not selected for any New Hire / Re-Hire Rule due to which terminated employee is not eligible for any rule. And hence system gets 'null' value for effective date which is causing server error |
| Correction | Select 'Terminated' status for respected new hire / re-hire rule.We have tested the same in local and it is working fine. Please check and confirm. |
Thanks,
Snehal Shabade
Cc:Umesh Kadam
Snehal Shabade (Inactive)
added a comment - - edited Hi Swapnil Eksambekar ,
Please find below 3Cs:
Concern
Getting server error while changing EE status as terminated
Cause
In "JE Dunn" company, 'Terminated' employee status is not selected for any New Hire / Re-Hire Rule due to which terminated employee is not eligible for any rule. And hence system gets 'null' value for effective date which is causing server error
Correction
Select 'Terminated' status for respected new hire / re-hire rule.We have tested the same in local and it is working fine. Please check and confirm.
Thanks,
Snehal Shabade
Cc: Umesh Kadam Snehal Shabade (Inactive)
made changes -
| Assignee | Snehal Shabade [ snehal.shabade ] | Swapnil Eksambekar [ swapnil.eksambekar ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Verified following COBRA EVENT scenarios -
- Employee Termination
- Overage Dependent
- Retired
- Class Change
Above mentioned scenarios are working as expected.
Testing is in progress for Ex-Spouse or Divorced Cobra event.
| Time Spent | 36.7h [ 132120 ] | 39.2h [ 141120 ] |
| Worklog Id | 97243 [ 97243 ] |
Snehal Shabade (Inactive)
logged work - 20/Dec/17 04:29 PM -
- Time Spent:
- 7h
-
-Discussion with umesh related to issue
-Company attach to local,script execution,
-Code debug fro EE status change,
-Analysis on generic eligibility rule of New/Re-Hire Rule And SP of calculating effective date,
-Share the details with umesh
-update the jira
-
- Time Spent:
- 0.5h
-
Discussion with Snehal, Swapnil P., Swapnil E. and Rajendra
Initial Analysis
Snehal Shabade (Inactive)
made changes -
| Time Spent | 39.2h [ 141120 ] | 46.2h [ 166320 ] |
| Worklog Id | 97260 [ 97260 ] |
Verified for Ex-spouse or Divorced Cobra event along with all mentioned scenarios in above comment,It is working as expected.
Ready for Stage deployment.
CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyVinayak Kulkarni
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Hi All,
This ticket has been approved for stage deployment on 12/21/17.
Regards
Gaurav
Gaurav Sodani (Inactive)
added a comment - Hi All,
This ticket has been approved for stage deployment on 12/21/17.
Regards
Gaurav Gaurav Sodani (Inactive)
made changes -
| Deployment Approval | Approved for stage deployment [ 18455 ] | |
| Production Due Date | 29/Dec/2017 |
This Issue is deployed on Stage. We will test it and update on Tuesday, 12/26.
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Time Spent | 46.2h [ 166320 ] | 46.7h [ 168120 ] |
| Worklog Id | 97842 [ 97842 ] |
Below cobra events has been verified on Stage :-
- Employee Termination
- Divorce- Spouse to Ex-Spouse
- Overage Dependent
- Retired
- Class Change
It is working as expected.Ready for Production deployment.
CC-Aniruddha DevRakesh ShahaneHrishikesh DeshpandeRakesh RoyGaurav Sodani
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 46.7h [ 168120 ] | 50.7h [ 182520 ] |
| Worklog Id | 98222 [ 98222 ] |
| Time Spent | 50.7h [ 182520 ] | 51h 2m [ 183720 ] |
| Worklog Id | 98284 [ 98284 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Gaurav Sodani (Inactive)
made changes -
| Comments |
Hi All, Following point has been approved for production deployment on 12/29 Regards Gaurav |
|
| Deployment Approval | Approved for stage deployment [ 18455 ] | Approved for production deployment [ 18457 ] |
| Time Spent | 51h 2m [ 183720 ] | 53h 2m [ 190920 ] |
| Worklog Id | 98521 [ 98521 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Unable to test below scenarios ,
- Employee Termination
- Divorce- Spouse to Ex-Spouse
- Overage Dependent
- Retired
- Class Change
It is blocked to test due to wt-12931 ,as It is getting server error.Once it gets resolved , reassign to me.
CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyVinayak Kulkarni
| Assignee | Swapnil Eksambekar [ swapnil.eksambekar ] | Rajendra Pawar [ rajendra.pawar ] |
| Assignee | Rajendra Pawar [ rajendra.pawar ] | Umesh Kadam [ umesh.kadam ] |
| Time Spent | 53h 2m [ 190920 ] | 54h 2m [ 194520 ] |
| Worklog Id | 99013 [ 99013 ] |
Hi All,
Attaching the production deployment approval email for reference
Regards
Gaurav
Gaurav Sodani (Inactive)
added a comment - Hi All,
Attaching the production deployment approval email for reference
Regards
Gaurav Hello Damion M Velasquez,
We have deployed and verified this fix on production today
Verified all below scenarios :-
Employee Termination -Pass
Divorce- Spouse to Ex-Spouse -Pass
Overage Dependent -Pass
Retired -Pass
Class Change -Pass
Can you please check this at your end and close this JIRA ?
Please let us know in case of any queries or issues.
CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyGaurav SodaniVinayak Kulkarni
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222) |
| Assignee | Umesh Kadam [ umesh.kadam ] | Damion Velasquez [ damion.velasquez ] |
| Time Spent | 54h 2m [ 194520 ] | 56h 32m [ 203520 ] |
| Worklog Id | 99152 [ 99152 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production Complete(10222) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
9h 48m | 1 |
|
5d 9h 5m | 1 |
|
7d 21h 38m | 1 |
|
7h 38m | 1 |
|
3h 6m | 1 |
|
6d 11h 53m | 2 |
|
2d 58m | 1 |
|
6d 20h 11m | 1 |
|
5d 2h 32m | 1 |
|
23d 20h 31m | 1 |
Hi Damion M Velasquez,
Concern: Cobra reason went as Divorce for removed child.
Cause: We have checked the details of mentioned employee, As per analysis we found that When EE Timothy Benbow Removed child, Enrollment got terminated but on the event builder, There is no such event present which can be captured due to termination, However after that EE Change the Spouse relationship from spouse to Ex-Spouse, So because of this Divorce event got satisfied and that reason went over the file.
Same scenario happened with other mentioned employees.
Correction: We need to discuss this with Amit Thorve.
CC-Prashant Samal, Ganesh Sadawarte, Rajendra Pawar, Vinayak Kulkarni