[WT-10739] Billing report - Throws Dataset error if Effective Date Fields exposed on Report - Workterra Jira

Details

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

Environment:

QA
Bug Type:
Functional
Bug Severity:
Medium
Level:

Partner
Module:
BenAdmin - Report
Reported by:
Harbinger
Item State:
Production Complete - Closed
Issue Importance:
Must Have
Browser:

Google Chrome
Sprint:
WT Sprint 36 - Bugs

Description

Customization :

Customize Billing Report with Field Like as
SSN , FName, LName, Plan Design Name, Effective Date, Termination Date, Employee Cost , Employer Cost and Total Amount

Replication Steps :
1) Partner Login
2) Navigate up to Report -> Billing Report
3) Run Report

Issue: It throws DataSet error. If we un-mapped Date fields then report ran properly.

CC - Sachin Hingole

Attachments

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

Attachments

billing Report.xls
5.33 MB
08/Sep/17 03:09 AM
Billing report2.xls
2.80 MB
08/Sep/17 03:09 AM
Billing Report3.xls
5.33 MB
08/Sep/17 03:09 AM
Billing Report 4.xls
4.31 MB
08/Sep/17 03:09 AM
Test.xls
125 kB
16/Oct/17 05:37 AM
Test one.xls
98 kB
16/Oct/17 05:37 AM
WT_10739.xls
737 kB
11/Oct/17 09:44 AM
WT-10739.xls
908 kB
11/Oct/17 09:44 AM

Issue Links

is cloned by

NF-5136 Billing report - Throws Dataset error if Effective Date Fields exposed on Report

Production Complete

relates to

WT-8642 Issue with coverages per family

Closed

Activity

Ascending order - Click to sort in descending order

Meghana Joshi (Inactive) created issue - 18/Aug/17 12:01 PM

Meghana Joshi (Inactive) made changes - 18/Aug/17 12:02 PM

Field	Original Value	New Value
Link		This issue relates to ~~WT-8642~~ [ ~~WT-8642~~ ]

Meghana Joshi (Inactive) made changes - 18/Aug/17 12:15 PM

Summary

Billing report - Throws Server error if Effective Date Fields exposed on Report

Billing report - Throws Dataset error if Effective Date Fields exposed on Report

Meghana Joshi (Inactive) made changes - 18/Aug/17 12:15 PM

Description

Customization :

Customize Billing Report with Field Like as
SSN , FName, LName, Plan Design Name, Effective Date, Termination Date, Employee Cost , Employer Cost and Total Amount

Replication Steps :
1) Partner Login
2) Navigate up to Report -> Billing Report
3) Run Report

Issue: It throws error. If we un-mapped Date fields then report ran properly.

CC - [~sachin.hingole]

Customization :

Customize Billing Report with Field Like as
SSN , FName, LName, Plan Design Name, Effective Date, Termination Date, Employee Cost , Employer Cost and Total Amount

Replication Steps :
1) Partner Login
2) Navigate up to Report -> Billing Report
3) Run Report

Issue: It throws DataSet error. If we un-mapped Date fields then report ran properly.

CC - [~sachin.hingole]

Gaurav Sodani (Inactive) made changes - 28/Aug/17 09:11 AM

Sprint

WT Sprint 36 - Bugs [ 84 ]

Jyoti Agrawal (Inactive) made changes - 28/Aug/17 01:57 PM

Dev Due Date

04/Sep/2017

Jyoti Agrawal (Inactive) made changes - 31/Aug/17 09:50 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Jyoti Agrawal (Inactive) made changes - 31/Aug/17 09:50 AM

Assignee

Prasanna Karlekar [ prasanna ]

Jyoti Agrawal [ jyoti.agrawal ]

Jyoti Agrawal (Inactive) made changes - 31/Aug/17 09:50 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Jyoti Agrawal (Inactive) made changes - 31/Aug/17 09:50 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Prasanna Karlekar [ prasanna ]

Jyoti Agrawal (Inactive) made changes - 31/Aug/17 12:27 PM

Remaining Estimate	5h [ 18000 ]	0.5h [ 1800 ]
Time Spent		4.5h [ 16200 ]
Worklog Id		76188 [ 76188 ]

Jyoti Agrawal (Inactive) made changes - 04/Sep/17 08:45 AM

Assignee	Prasanna Karlekar [ prasanna ]	Jyoti Agrawal [ jyoti.agrawal ]
Code Review Date		04/Sep/2017
Code Reviewed By		Prasanna Karlekar [ 11907 ]
Developer		Jyoti Agrawal [ jyoti.agrawal ]

Jyoti Agrawal (Inactive) made changes - 04/Sep/17 08:45 AM

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)

Jyoti Agrawal (Inactive) made changes - 04/Sep/17 09:17 AM

Remaining Estimate	0.5h [ 1800 ]	0.25h [ 900 ]
Time Spent	4.5h [ 16200 ]	4.75h [ 17100 ]
Worklog Id		76600 [ 76600 ]

Khandu Kshirsagar (Inactive) made changes - 04/Sep/17 11:44 AM

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)

Jyoti Agrawal (Inactive) made changes - 04/Sep/17 12:39 PM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 06/Sep/17 06:02 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 06/Sep/17 06:02 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Priya Handepatil [ priya.handepatil ]

Prasanna Karlekar (Inactive) made changes - 06/Sep/17 08:31 AM

Remaining Estimate	0.25h [ 900 ]	0h [ 0 ]
Time Spent	4.75h [ 17100 ]	5h [ 18000 ]
Worklog Id		77003 [ 77003 ]

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:05 PM

Item State

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

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

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:17 PM

Attachment		Billing Report 4.xls [ 60940 ]
Attachment		billing Report.xls [ 60941 ]
Attachment		Billing report2.xls [ 60942 ]
Attachment		Billing Report3.xls [ 60943 ]

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:20 PM

Attachment

Billing Report3.xls [ 60943 ]

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:20 PM

Attachment

Billing report2.xls [ 60942 ]

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:20 PM

Attachment

billing Report.xls [ 60941 ]

Priya Handepatil (Inactive) made changes - 07/Sep/17 01:20 PM

Attachment

Billing Report 4.xls [ 60940 ]

Priya Handepatil (Inactive) made changes - 08/Sep/17 03:09 AM

Attachment		Billing Report 4.xls [ 60960 ]
Attachment		billing Report.xls [ 60961 ]
Attachment		Billing report2.xls [ 60962 ]
Attachment		Billing Report3.xls [ 60963 ]

Priya Handepatil (Inactive) made changes - 08/Sep/17 03:10 AM

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)

Priya Handepatil (Inactive) made changes - 08/Sep/17 06:35 AM

Time Spent	5h [ 18000 ]	6h [ 21600 ]
Worklog Id		77520 [ 77520 ]

Priya Handepatil (Inactive) made changes - 08/Sep/17 06:37 AM

Worklog Id

77520 [ 77520 ]

Meghana Joshi (Inactive) made changes - 11/Sep/17 05:46 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Priya Handepatil (Inactive) made changes - 11/Sep/17 07:43 AM

Time Spent	6h [ 21600 ]	6.5h [ 23400 ]
Worklog Id		77895 [ 77895 ]

Rakesh Roy (Inactive) made changes - 25/Sep/17 05:05 PM

Priya Handepatil [ priya.handepatil ]

Meghana Joshi (Inactive) made changes - 04/Oct/17 12:44 PM

Production Due Date		12/Oct/2017
Stage Due Date		6/Oct/17 [ 2017-10-06 ]

Meghana Joshi (Inactive) made changes - 05/Oct/17 07:15 AM

Item State

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

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

Meghana Joshi (Inactive) made changes - 05/Oct/17 07:15 AM

Production Due Date	12/Oct/2017	11/Oct/2017
Stage Due Date	6/Oct/17 [ 2017-10-06 ]	9/Oct/17 [ 2017-10-09 ]

Khandu Kshirsagar (Inactive) made changes - 10/Oct/17 06:23 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)

Meghana Joshi (Inactive) made changes - 11/Oct/17 09:28 AM

Production Due Date	11/Oct/2017	18/Oct/2017
Stage Due Date	9/Oct/17 [ 2017-10-09 ]	10/Oct/17 [ 2017-10-10 ]

Meghana Joshi (Inactive) made changes - 11/Oct/17 09:29 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Priya Handepatil (Inactive) made changes - 11/Oct/17 09:44 AM

Attachment

WT-10739.xls [ 64060 ]

Priya Handepatil (Inactive) made changes - 11/Oct/17 09:44 AM

Attachment

WT_10739.xls [ 64061 ]

Priya Handepatil (Inactive) made changes - 11/Oct/17 09:45 AM

Item State

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

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Priya Handepatil (Inactive) made changes - 11/Oct/17 09:45 AM

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)

Priya Handepatil (Inactive) made changes - 11/Oct/17 09:45 AM

Time Spent	6.5h [ 23400 ]	7.5h [ 27000 ]
Worklog Id		84261 [ 84261 ]

Ashwin Wankhede (Inactive) made changes - 14/Oct/17 12:31 PM

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)

Priya Handepatil (Inactive) made changes - 16/Oct/17 04:53 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)

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:37 AM

Attachment

Test.xls [ 64558 ]

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:37 AM

Attachment

Test one.xls [ 64559 ]

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:38 AM

Item State

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

Parent values: Production Complete(10222)

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:38 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:39 AM

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

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:40 AM

Time Spent	7.5h [ 27000 ]	8.5h [ 30600 ]
Worklog Id		85170 [ 85170 ]

Priya Handepatil (Inactive) made changes - 16/Oct/17 05:40 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Hrishikesh Deshpande (Inactive) made changes - 16/Oct/17 06:02 AM

Item State

Parent values: Production Complete(10222)

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

Priya Handepatil (Inactive) made changes - 16/Oct/17 07:05 AM

Worklog Id

85170 [ 85170 ]

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

Environment_New

LB [ 18444 ]

Jyoti Agrawal (Inactive) made changes - 23/Nov/17 06:39 AM

Link

This issue is cloned by ~~NF-5136~~ [ ~~NF-5136~~ ]

People

Assignee:: Priya Handepatil (Inactive)

Reporter:: Meghana Joshi (Inactive)

Developer:: Jyoti Agrawal (Inactive)

QA:: Priya Handepatil (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 18/Aug/17 12:01 PM

Updated:: 23/Nov/17 06:39 AM

Resolved:: 16/Oct/17 05:39 AM

Dev Due Date:: 04/Sep/2017

Pre-Prod Due Date:: 10/Oct/2017

Production Due Date:: 18/Oct/2017

Code Review Date:: 04/Sep/2017

Time Tracking

Estimated:

Remaining:

Logged:

8.5h