[WT-5530] Incorrect SSN order in comparison report - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Low
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Environment:

QA
Module:
ACA
Reported by:
Harbinger
Item State:
Production Complete - Closed
Issue Importance:
Can Wait

Description

Report Name- 1095C Class AC

Company - ACAAutomation

Run 1- 10/18/2016 1:57:27 PM
Run 2 - 10/18/2016 1:58:15 PM

Screen Shot - No_Continuous_12records_For_Single_SSN.jpg

Step:-
1.Import employee of same name with different SSN
2.Run 1095C without Eligibility Rule for Multi Employer
3.Run 1095C with Eligibility Rule for Multi Employer
4.Navigate to Benadmin > ACA >
ACA Customization > ACA 1095C Comparison
5.“Select 1095C report” drop down
6.Select Run 1 & 2 and click on Show Report

Expected - There should be continuous 12 row for same SSN

Actual - It display mixed SSN in comparison report

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

No_Continuous_12records_For_Single_SSN.jpg
458 kB
18/Oct/16 09:32 AM

Issue Links

is caused by

WT-2691 ACA-2017 : Comparision between two different runs of 1095C report.

Closed

Activity

Ascending order - Click to sort in descending order

Mahendra Mungase (Inactive) created issue - 18/Oct/16 08:49 AM

Mahendra Mungase (Inactive) made changes - 18/Oct/16 08:53 AM

Field	Original Value	New Value
Description	Report Name- 1095C AC Company - ACAAutomation Run 1- 10/18/2016 1:57:27 PM Run 2 - 10/18/2016 1:58:15 PM Step:- 1.Import employee of same name with different SSN 2.Run 1095C without Eligibility Rule for Multi Employer	Report Name- 1095C AC Company - ACAAutomation Run 1- 10/18/2016 1:57:27 PM Run 2 - 10/18/2016 1:58:15 PM Screen Shot - No_Continuous_12records_For_Single_SSN.jpg Step:- 1.Import employee of same name with different SSN 2.Run 1095C without Eligibility Rule for Multi Employer 3.Run 1095C with Eligibility Rule for Multi Employer 4.Navigate to Benadmin > ACA > ACA Customization > ACA 1095C Comparison 5.“Select 1095C report” drop down 6.Select Run 1 & 2 and click on Show Report Expected - There should be continuous 12 row for same SSN Actual - It display mixed SSN in comparison report

Mahendra Mungase (Inactive) made changes - 18/Oct/16 08:54 AM

Assignee	Vijay Siddha [ vijays ]	Abhijeet Khandagale [ abhijeet.khandagale ]
Component/s		ACA [ 10004 ]
Developer		Abhijeet Khandagale [ abhijeet.khandagale ]
Issue Category	EBS [ 10350 ]	Harbinger [ 10700 ]
Issue Importance		Can Wait [ 11801 ]
Module	Parent values: BenAdmin(10100)	Parent values: ACA(10104)
Priority	Medium [ 3 ]	Low [ 4 ]
QA		Mahendra Mungase [ mahendra.mungase ]

Mahendra Mungase (Inactive) made changes - 18/Oct/16 08:54 AM

Link

This issue is caused by ~~WT-2691~~ [ ~~WT-2691~~ ]

Mahendra Mungase (Inactive) made changes - 18/Oct/16 09:32 AM

Attachment

No_Continuous_12records_For_Single_SSN.jpg [ 29528 ]

Abhijeet Khandagale (Inactive) made changes - 27/Oct/16 09:07 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Mahendra Mungase (Inactive) made changes - 27/Oct/16 11:35 AM

Description

Report Name- 1095C AC

Company - ACAAutomation

Run 1- 10/18/2016 1:57:27 PM
Run 2 - 10/18/2016 1:58:15 PM

Screen Shot - No_Continuous_12records_For_Single_SSN.jpg

Step:-
1.Import employee of same name with different SSN
2.Run 1095C without Eligibility Rule for Multi Employer
3.Run 1095C with Eligibility Rule for Multi Employer
4.Navigate to Benadmin > ACA >
ACA Customization > ACA 1095C Comparison
5.“Select 1095C report” drop down
6.Select Run 1 & 2 and click on Show Report

Expected - There should be continuous 12 row for same SSN

Actual - It display mixed SSN in comparison report

Report Name- 1095C Class AC

Company - ACAAutomation

Run 1- 10/18/2016 1:57:27 PM
Run 2 - 10/18/2016 1:58:15 PM

Screen Shot - No_Continuous_12records_For_Single_SSN.jpg

Step:-
1.Import employee of same name with different SSN
2.Run 1095C without Eligibility Rule for Multi Employer
3.Run 1095C with Eligibility Rule for Multi Employer
4.Navigate to Benadmin > ACA >
ACA Customization > ACA 1095C Comparison
5.“Select 1095C report” drop down
6.Select Run 1 & 2 and click on Show Report

Expected - There should be continuous 12 row for same SSN

Actual - It display mixed SSN in comparison report

Mahendra Mungase (Inactive) made changes - 27/Oct/16 11:37 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Mahendra Mungase (Inactive) made changes - 27/Oct/16 11:37 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Khandu Kshirsagar (Inactive) made changes - 27/Oct/16 11:39 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Abhijeet Khandagale (Inactive) made changes - 27/Oct/16 11:44 AM

Assignee

Abhijeet Khandagale [ abhijeet.khandagale ]

Mahendra Mungase [ mahendra.mungase ]

Hide

Permalink

Mahendra Mungase (Inactive) added a comment - 28/Oct/16 04:53 AM

We have regressed this issue and observed that it's working as expected.Hence marking ready for stage.

Abhijeet Khandagale - Can you please add 3C?

Show

Mahendra Mungase (Inactive) added a comment - 28/Oct/16 04:53 AM We have regressed this issue and observed that it's working as expected.Hence marking ready for stage. Abhijeet Khandagale - Can you please add 3C?

Mahendra Mungase (Inactive) made changes - 28/Oct/16 04:53 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Hide

Permalink

Abhijeet Khandagale (Inactive) added a comment - 28/Oct/16 05:25 AM

Please find 3 C's for mentioned issue below,

Concern: Incorrect SSN order in comparison report

Cause: We used to sort records as per EmployeeName, EmployeeType, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in in creasing order as given below,
Davim Davim- 300000041
Davim Davim- 300000041
Davim Davim- 300000041

Show

Abhijeet Khandagale (Inactive) added a comment - 28/Oct/16 05:25 AM Please find 3 C's for mentioned issue below, Concern: Incorrect SSN order in comparison report Cause: We used to sort records as per EmployeeName, EmployeeType, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in in creasing order as given below, Davim Davim- 300000041 Davim Davim- 300000041 Davim Davim- 300000041

Hide

Permalink

Abhijeet Khandagale (Inactive) added a comment - 28/Oct/16 05:25 AM - edited

Please find 3 C's for mentioned issue below,

Concern: Incorrect SSN order in comparison report

Cause: We used to sort records as per EmployeeName, Member Type, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in increasing order as given below,

Davim Davim- 300000041
Davim Davim- 300000042
Davim Davim- 300000043
Davim Davim- 300000044
Which is rarest scenario, No company will have employee with same name and sequential SSN. Although we have changed ordering condition in SP.

Correction: We have changed ordering condition in SP. Now, employees are sorted in order of Name, SSN and Month.

Show

Abhijeet Khandagale (Inactive) added a comment - 28/Oct/16 05:25 AM - edited Please find 3 C's for mentioned issue below, Concern: Incorrect SSN order in comparison report Cause: We used to sort records as per EmployeeName, Member Type, Month. But data provided on this company is one of a kind. If you observe employees from Screen-shot, all employees have same name "Davis Davim" with SSN in increasing order as given below, Davim Davim- 300000041 Davim Davim- 300000042 Davim Davim- 300000043 Davim Davim- 300000044 Which is rarest scenario, No company will have employee with same name and sequential SSN. Although we have changed ordering condition in SP. Correction: We have changed ordering condition in SP. Now, employees are sorted in order of Name, SSN and Month.

Khandu Kshirsagar (Inactive) made changes - 07/Nov/16 10:11 AM

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)

Sachin Hingole (Inactive) made changes - 11/Nov/16 10:30 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Hide

Permalink

Mahendra Mungase (Inactive) added a comment - 11/Nov/16 11:38 AM

We have regressed this issue and observed that it's working as expected.Hence marking ready for Production.

Show

Mahendra Mungase (Inactive) added a comment - 11/Nov/16 11:38 AM We have regressed this issue and observed that it's working as expected.Hence marking ready for Production.

Mahendra Mungase (Inactive) made changes - 11/Nov/16 11:38 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Ashwin Wankhede (Inactive) made changes - 13/Nov/16 06:56 AM

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)

Sachin Hingole (Inactive) made changes - 15/Nov/16 10:37 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 16/Nov/16 07:31 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Sachin Hingole (Inactive) made changes - 16/Nov/16 07:35 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 16/Nov/16 07:36 AM

Verified on production, working fine.

Now employee are ordered correctly on SSN.

Show

Sachin Hingole (Inactive) added a comment - 16/Nov/16 07:36 AM Verified on production, working fine. Now employee are ordered correctly on SSN.

Sachin Hingole (Inactive) made changes - 16/Nov/16 07:36 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Sachin Hingole (Inactive) made changes - 16/Nov/16 07:36 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Satya made changes - 04/Nov/17 06:20 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Abhijeet Khandagale (Inactive) made transition - 27/Oct/16 09:07 AM

Open

In Development

9d 18m

Mahendra Mungase (Inactive) made transition - 27/Oct/16 11:37 AM

In Development

In LB Testing

2h 29m

Sachin Hingole (Inactive) made transition - 11/Nov/16 10:30 AM

In LB Testing

Stage Testing

14d 23h 53m

Sachin Hingole (Inactive) made transition - 15/Nov/16 10:37 AM

Stage Testing

In Production Testing

4d 7m

Sachin Hingole (Inactive) made transition - 16/Nov/16 07:36 AM

In Production Testing

Production Complete

20h 59m

Sachin Hingole (Inactive) made transition - 16/Nov/16 07:36 AM

Production Complete

Closed

People

Assignee:: Mahendra Mungase (Inactive)

Reporter:: Mahendra Mungase (Inactive)

Developer:: Abhijeet Khandagale (Inactive)

QA:: Mahendra Mungase (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 18/Oct/16 08:49 AM

Updated:: 04/Nov/17 06:20 AM

Resolved:: 16/Nov/16 07:36 AM