[WT-10859] Column-Wise Billing Report - Displayed blank effective date - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
- Billing

Environment:

Production, Stage, QA
Bug Type:
Functional
Bug Severity:
Medium
Level:

Partner
Module:
BenAdmin - Report
Reported by:
Harbinger
Company:
All Clients/Multiple Clients
Item State:
LB QA - On Hold
Issue Importance:
Must Have
Sprint:
WT Sprint 37 - Bugs, WT Sprint 38 - Bugs

Dev Estimates:
16
Code Reviewed By:

Jyoti Agarwal

Description

Precondition :

Create one Column-wise billing report like as :

Replication Steps :
1) Partner Login
2) Navigate up to Billing Report
3) Ran Report

Issue : Displayed blank Enrollment Effective Date for particular plan. Extra column added at end of report to display effective date.

CC - Sachin Hingole

Attachments

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

Attachments

Fields.jpg
23 kB
29/Aug/17 07:24 AM
WT-10859_PROD_BillingReport.png
79 kB
14/Sep/17 06:43 AM
WT-10859.xls
17 kB
04/Oct/17 09:16 AM
WT-10859.xls
429 kB
22/Sep/17 11:19 AM
WT-10859.xls
1.59 MB
14/Sep/17 06:05 AM
WT-10859 (c97352a5-72a8-4a47-9a02-2d725b57c4db).xls
80 kB
23/Oct/17 12:46 PM
WT-10859-ETA.xls
7 kB
26/Sep/17 10:14 AM

Activity

Ascending order - Click to sort in descending order

Meghana Joshi (Inactive) created issue - 29/Aug/17 07:28 AM

Meghana Joshi (Inactive) made changes - 29/Aug/17 07:28 AM

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

Permalink

Jyoti Agrawal (Inactive) logged work - 06/Sep/17 12:14 PM

Time Spent:

0.5h

Analysis

Harshada Borole (Inactive) made changes - 08/Sep/17 12:14 PM

Assignee

Prasanna Karlekar [ prasanna ]

Harshada Borole [ harshada.borole ]

Jyoti Agrawal (Inactive) made changes - 08/Sep/17 12:15 PM

Remaining Estimate		0h [ 0 ]
Time Spent		0.5h [ 1800 ]
Worklog Id		77699 [ 77699 ]

Harshada Borole (Inactive) made changes - 08/Sep/17 12:15 PM

Developer		Harshada Borole [ harshada.borole ]
Remaining Estimate	0h [ 0 ]

Permalink

Harshada Borole (Inactive) logged work - 08/Sep/17 12:32 PM

Time Spent:

2.5h

Analysis

Gaurav Sodani (Inactive) made changes - 08/Sep/17 06:19 PM

Sprint

WT Sprint 37 - Bugs [ 87 ]

Harshada Borole (Inactive) made changes - 11/Sep/17 07:38 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Harshada Borole (Inactive) made changes - 11/Sep/17 07:38 AM

Item State

Parent values: Development(10200)

Permalink

Parmeshwar Jumbad (Inactive) logged work - 11/Sep/17 12:50 PM

Time Spent:

1h

Discussion and Check cause of issue

Parmeshwar Jumbad (Inactive) made changes - 11/Sep/17 12:51 PM

Remaining Estimate		0h [ 0 ]
Time Spent	0.5h [ 1800 ]	1.5h [ 5400 ]
Worklog Id		78002 [ 78002 ]

Permalink

Harshada Borole (Inactive) logged work - 11/Sep/17 04:48 PM

Time Spent:

8h

Analysis
Discussion
Development
Testing

Harshada Borole (Inactive) made changes - 12/Sep/17 04:49 AM

Time Spent	1.5h [ 5400 ]	9.5h [ 34200 ]
Worklog Id		78114 [ 78114 ]

Harshada Borole (Inactive) made changes - 12/Sep/17 07:29 AM

Dev Due Date		12/Sep/2017
Original Estimate		0h [ 0 ]

Permalink

Harshada Borole (Inactive) logged work - 13/Sep/17 04:02 AM

Time Spent:

6h

Development
Testing
Discussion
Sent code for review.

Harshada Borole (Inactive) made changes - 13/Sep/17 07:17 AM

Code Review Date		13/Sep/2017
Code Reviewed By		Jyoti Agarwal [ 16704 ]

Hide

Permalink

Harshada Borole (Inactive) added a comment - 13/Sep/17 09:25 AM

Below are the 3C's:
Concern:- Reports - Displayed blank Effective Date.
Cause:- Flag for Enrollment Effective date was getting set to False because of mismatch of query for Enrollment Effective Date.
Correction:- Corrected the query with Enrollment Effective Date.

Apart from this we also found an issue related to Effective Date which we have fixed with this ticket.
Below are the details:-
Issue:- 'Enrollment Effective Date' in Benefit Field section appeared as 'Effective Date' at the time of selection. On saving the report and re-opening the template the 'Effective Date' now appeared as 'Enrollment Effective Date'.

Excepted:- 'Effective Date' in Benefit field should always appear as 'Enrollment Effective Date' before or after saving the template.

Affected Files:-
RDLGenerator.vb

Area's Affected:-
While pulling Billing Details Reports.

Testing Scenario's:-
Pulled Billing Details Report by selecting 'Enrollment Effective Date' from Benefit Fields section in the template.

Show

Harshada Borole (Inactive) added a comment - 13/Sep/17 09:25 AM Below are the 3C's: Concern:- Reports - Displayed blank Effective Date. Cause:- Flag for Enrollment Effective date was getting set to False because of mismatch of query for Enrollment Effective Date. Correction:- Corrected the query with Enrollment Effective Date. Apart from this we also found an issue related to Effective Date which we have fixed with this ticket. Below are the details:- Issue:- 'Enrollment Effective Date' in Benefit Field section appeared as 'Effective Date' at the time of selection. On saving the report and re-opening the template the 'Effective Date' now appeared as 'Enrollment Effective Date'. Excepted:- 'Effective Date' in Benefit field should always appear as 'Enrollment Effective Date' before or after saving the template. Affected Files:- RDLGenerator.vb Area's Affected:- While pulling Billing Details Reports. Testing Scenario's:- Pulled Billing Details Report by selecting 'Enrollment Effective Date' from Benefit Fields section in the template.

Khandu Kshirsagar (Inactive) made changes - 13/Sep/17 10:30 AM

Item State

Parent values: Development(10200)

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

Harshada Borole (Inactive) made changes - 13/Sep/17 11:12 AM

Assignee

Harshada Borole [ harshada.borole ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 13/Sep/17 11:21 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 13/Sep/17 11:22 AM

Item State

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

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

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 13/Sep/17 11:24 AM

Please plan this for testing, also provide stage and production due dates.
Let us know if you need any other details on this.

[~meghana joshi] Rakesh Roy Hrishikesh Deshpande Prasad Patil Prasanna Karlekar

Show

Sachin Hingole (Inactive) added a comment - 13/Sep/17 11:24 AM Please plan this for testing, also provide stage and production due dates. Let us know if you need any other details on this. [~meghana joshi] Rakesh Roy Hrishikesh Deshpande Prasad Patil Prasanna Karlekar

Sachin Hingole (Inactive) made changes - 13/Sep/17 11:24 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Priya Handepatil [ priya.handepatil ]

Harshada Borole (Inactive) made changes - 13/Sep/17 12:33 PM

Time Spent	9.5h [ 34200 ]	12h [ 43200 ]
Worklog Id		78505 [ 78505 ]

Permalink

Harshada Borole (Inactive) logged work - 13/Sep/17 12:34 PM

Time Spent:

2h

Corrected the script after review.
Testing

Permalink

Jyoti Agrawal (Inactive) logged work - 13/Sep/17 12:49 PM

Time Spent:

0.5h

Code and functionality review

Harshada Borole (Inactive) made changes - 13/Sep/17 12:50 PM

Time Spent	12h [ 43200 ]	14h [ 50400 ]
Worklog Id		78528 [ 78528 ]

Harshada Borole (Inactive) made changes - 14/Sep/17 04:02 AM

Time Spent	14h [ 50400 ]	20h [ 72000 ]
Worklog Id		78596 [ 78596 ]

Harshada Borole (Inactive) made changes - 14/Sep/17 04:02 AM

Remaining Estimate	0h [ 0 ]	6h [ 21600 ]
Time Spent	20h [ 72000 ]	14h [ 50400 ]
Worklog Id	78596 [ 78596 ]
Worklog Time Spent	6h [ 21600 ]

Harshada Borole (Inactive) made changes - 14/Sep/17 04:03 AM

Remaining Estimate	6h [ 21600 ]	0h [ 0 ]
Time Spent	14h [ 50400 ]	20h [ 72000 ]
Worklog Id		78597 [ 78597 ]

Priya Handepatil (Inactive) made changes - 14/Sep/17 06:05 AM

Attachment

WT-10859.xls [ 61447 ]

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 14/Sep/17 06:06 AM

Hi Harshada Borole

I have verified this issue on LB

Verified with Partner login

Verified on Company "For QA Fdu for Hspl"

Its getting Re-Open
WT-10859.xls

cc:Rakesh Roy Sachin Hingole Prasad Pise [~meghana joshi]

Thank you !

Show

Priya Handepatil (Inactive) added a comment - 14/Sep/17 06:06 AM Hi Harshada Borole I have verified this issue on LB Verified with Partner login Verified on Company "For QA Fdu for Hspl" Its getting Re-Open WT-10859.xls cc: Rakesh Roy Sachin Hingole Prasad Pise [~meghana joshi] Thank you !

Priya Handepatil (Inactive) made changes - 14/Sep/17 06:07 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Priya Handepatil (Inactive) made changes - 14/Sep/17 06:07 AM

Assignee

Priya Handepatil [ priya.handepatil ]

Harshada Borole [ harshada.borole ]

Prasanna Karlekar (Inactive) made changes - 14/Sep/17 06:43 AM

Attachment

WT-10859_PROD_BillingReport.png [ 61461 ]

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 14/Sep/17 06:44 AM

Have verified this issue in Production environment. Effective date issue is present in Production environment too. Please refer below screen shot from Production site:

Unlinking ~~WT-8642~~ from this JIRA as this is not caused by fix done in it.

Thank you!

cc: Gaurav Sodani

Show

Prasanna Karlekar (Inactive) added a comment - 14/Sep/17 06:44 AM Have verified this issue in Production environment. Effective date issue is present in Production environment too. Please refer below screen shot from Production site: Unlinking WT-8642 from this JIRA as this is not caused by fix done in it. Thank you! cc: Gaurav Sodani

Prasanna Karlekar (Inactive) made changes - 14/Sep/17 06:44 AM

Link

This issue relates to ~~WT-8642~~ [ ~~WT-8642~~ ]

Permalink

Priya Handepatil (Inactive) logged work - 14/Sep/17 10:22 AM

Time Spent:

1.3h

Analysis
Testing with different Scenario
Internal Discussion with Harshada and Meghana
JIRA updates

Priya Handepatil (Inactive) made changes - 14/Sep/17 10:23 AM

Time Spent	20h [ 72000 ]	21.3h [ 76680 ]
Worklog Id		78727 [ 78727 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 15/Sep/17 12:00 AM

Time Spent:

0.25h

JIRA update

Jyoti Agrawal (Inactive) made changes - 15/Sep/17 12:49 PM

Time Spent	21.3h [ 76680 ]	21.8h [ 78480 ]
Worklog Id		79037 [ 79037 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 15/Sep/17 01:00 PM

Time Spent:

1h

Issue analysis, discussion

Jyoti Agrawal (Inactive) made changes - 15/Sep/17 01:01 PM

Time Spent	21.8h [ 78480 ]	22.8h [ 82080 ]
Worklog Id		79062 [ 79062 ]

Permalink

Harshada Borole (Inactive) logged work - 16/Sep/17 04:06 AM - edited

Time Spent:

5h

Analysis
Discussion with Jyoti A
Development.

Prasanna Karlekar (Inactive) made changes - 18/Sep/17 08:48 AM

Time Spent	22.8h [ 82080 ]	23.05h [ 82980 ]
Worklog Id		79201 [ 79201 ]

Khandu Kshirsagar (Inactive) made changes - 18/Sep/17 10:54 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

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

Permalink

Jyoti Agrawal (Inactive) logged work - 18/Sep/17 01:22 PM

Time Spent:

0.25h

Code review

Jyoti Agrawal (Inactive) made changes - 18/Sep/17 01:23 PM

Time Spent	23.05h [ 82980 ]	23.3h [ 83880 ]
Worklog Id		79314 [ 79314 ]

Permalink

Harshada Borole (Inactive) logged work - 19/Sep/17 04:08 AM

Time Spent:

1h

Testing
Code Deployment.

Harshada Borole (Inactive) made changes - 20/Sep/17 04:07 AM

Time Spent	23.3h [ 83880 ]	28.3h [ 101880 ]
Worklog Id		79853 [ 79853 ]

Harshada Borole (Inactive) made changes - 20/Sep/17 04:07 AM

Worklog Id

79853 [ 79853 ]

Harshada Borole (Inactive) made changes - 20/Sep/17 04:08 AM

Time Spent	28.3h [ 101880 ]	29.3h [ 105480 ]
Worklog Id		79854 [ 79854 ]

Hide

Permalink

Harshada Borole (Inactive) added a comment - 21/Sep/17 04:32 AM

Below are the 3C's:
Concern:- Reports - Displayed blank Effective Date.
Cause:- Query was not handled in SP for Enrollment Effective Date.
Correction:- Corrected the query for Enrollment Effective Date.

Affected Files:-
RDLGenerator.vb
ReportDetails.vb
OES_SP_GetBillingDetailsMonthlyColumnWise

Show

Harshada Borole (Inactive) added a comment - 21/Sep/17 04:32 AM Below are the 3C's: Concern:- Reports - Displayed blank Effective Date. Cause:- Query was not handled in SP for Enrollment Effective Date. Correction:- Corrected the query for Enrollment Effective Date. Affected Files:- RDLGenerator.vb ReportDetails.vb OES_SP_GetBillingDetailsMonthlyColumnWise

Harshada Borole (Inactive) made changes - 21/Sep/17 04:33 AM

Assignee

Harshada Borole [ harshada.borole ]

Priya Handepatil [ priya.handepatil ]

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:07 AM

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 - 22/Sep/17 11:19 AM

Attachment

WT-10859.xls [ 62424 ]

Permalink

Priya Handepatil (Inactive) logged work - 22/Sep/17 11:20 AM

Time Spent:

1.5h

Testing for Different Reports
Internal Discussions for Re-pro With Developer
JIRA Updates

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 22/Sep/17 11:20 AM

Hello, Harshada Borole

I have verified this issue on LB

Verified with Partner login

Verified on Company "For QA Fdu for Hspl"

Its Getting Re-Open
WT-10859.xls

cc: Rakesh Roy Prasad Pise Sachin Hingole [~meghana joshi]

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 22/Sep/17 11:20 AM Hello, Harshada Borole I have verified this issue on LB Verified with Partner login Verified on Company "For QA Fdu for Hspl" Its Getting Re-Open WT-10859.xls cc: Rakesh Roy Prasad Pise Sachin Hingole [~meghana joshi] Thank You !

Priya Handepatil (Inactive) made changes - 22/Sep/17 11:21 AM

Time Spent	29.3h [ 105480 ]	30.8h [ 110880 ]
Worklog Id		80565 [ 80565 ]

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

Item State

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

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

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

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

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

Assignee

Priya Handepatil [ priya.handepatil ]

Harshada Borole [ harshada.borole ]

Permalink

Harshada Borole (Inactive) logged work - 22/Sep/17 11:43 AM

Time Spent:

1h

Discussion with Prasanna,Jyoti A
Issue analysis.

Harshada Borole (Inactive) made changes - 22/Sep/17 11:44 AM

Time Spent	30.8h [ 110880 ]	31.8h [ 114480 ]
Worklog Id		80574 [ 80574 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 22/Sep/17 01:11 PM

Time Spent:

1h

Ticket re-opening cause analysis, discussion with Parmeshwar and Harshada

Jyoti Agrawal (Inactive) made changes - 22/Sep/17 01:12 PM

Time Spent	31.8h [ 114480 ]	32.8h [ 118080 ]
Worklog Id		80669 [ 80669 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 22/Sep/17 11:00 PM

Time Spent:

0.25h

Issue discussion

Prasanna Karlekar (Inactive) made changes - 25/Sep/17 06:29 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Gaurav Sodani (Inactive) made changes - 25/Sep/17 08:00 AM

Sprint

WT Sprint 37 - Bugs [ 87 ]

WT Sprint 37 - Bugs, WT Sprint 38 - Bugs [ 87, 89 ]

Harshada Borole (Inactive) made changes - 26/Sep/17 10:14 AM

Attachment

WT-10859-ETA.xls [ 62711 ]

Harshada Borole (Inactive) made changes - 26/Sep/17 10:14 AM

Dev Due Date

12/Sep/2017

29/Sep/2017

Prasanna Karlekar (Inactive) made changes - 26/Sep/17 11:19 AM

Time Spent	32.8h [ 118080 ]	33.05h [ 118980 ]
Worklog Id		81415 [ 81415 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 26/Sep/17 12:16 PM

Time Spent:

1h

Discussion with Team related to existing implementation & changes required
Internal email communication

Parmeshwar Jumbad (Inactive) made changes - 26/Sep/17 12:18 PM

Time Spent	33.05h [ 118980 ]	34.05h [ 122580 ]
Worklog Id		81558 [ 81558 ]

Permalink

Harshada Borole (Inactive) logged work - 26/Sep/17 12:34 PM

Time Spent:

1h

Discussion on code fix.

Harshada Borole (Inactive) made changes - 26/Sep/17 12:34 PM

Time Spent	34.05h [ 122580 ]	35.05h [ 126180 ]
Worklog Id		81592 [ 81592 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 26/Sep/17 01:10 PM

Time Spent:

0.5h

Discussion on issue fix

Jyoti Agrawal (Inactive) made changes - 26/Sep/17 01:11 PM

Time Spent	35.05h [ 126180 ]	35.55h [ 127980 ]
Worklog Id		81687 [ 81687 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 26/Sep/17 07:00 PM

Time Spent:

0.5h

Discussion on column wise report issue and fix to be done

Harshada Borole (Inactive) made changes - 27/Sep/17 06:18 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: Development(10200)

Prasanna Karlekar (Inactive) made changes - 27/Sep/17 06:44 AM

Code Review Date

13/Sep/2017

Prasanna Karlekar (Inactive) made changes - 27/Sep/17 06:45 AM

Dev Estimates

Permalink

Harshada Borole (Inactive) logged work - 27/Sep/17 04:01 PM - edited

Time Spent:

3h

Analysis
Coding
RnD.

Harshada Borole (Inactive) made changes - 28/Sep/17 04:02 AM

Time Spent	35.55h [ 127980 ]	39.55h [ 142380 ]
Worklog Id		82027 [ 82027 ]

Harshada Borole (Inactive) made changes - 28/Sep/17 04:03 AM

Remaining Estimate	0h [ 0 ]	1h [ 3600 ]
Time Spent	39.55h [ 142380 ]	38.55h [ 138780 ]
Worklog Id		82027 [ 82027 ]

Permalink

Harshada Borole (Inactive) logged work - 28/Sep/17 03:56 PM

Time Spent:

7.5h

Coding
created UDF to check speck character and replace it with '_'.
Testing
Discussion.

Harshada Borole (Inactive) made changes - 29/Sep/17 03:57 AM

Remaining Estimate	1h [ 3600 ]	0h [ 0 ]
Time Spent	38.55h [ 138780 ]	46.05h [ 165780 ]
Worklog Id		82427 [ 82427 ]

Harshada Borole (Inactive) made changes - 29/Sep/17 11:20 AM

Code Review Date

29/Sep/2017

Jyoti Agrawal (Inactive) made changes - 29/Sep/17 11:21 AM

Item State

Parent values: Development(10200)

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Prasanna Karlekar (Inactive) made changes - 29/Sep/17 11:39 AM

Time Spent	46.05h [ 165780 ]	46.55h [ 167580 ]
Worklog Id		82730 [ 82730 ]

Prasanna Karlekar (Inactive) made changes - 29/Sep/17 11:57 AM

Time Spent	46.55h [ 167580 ]	47.05h [ 169380 ]
Worklog Id		82767 [ 82767 ]

Permalink

Harshada Borole (Inactive) logged work - 29/Sep/17 12:22 PM

Time Spent:

5h

Testing
Sent code for review.
Code commit.

Harshada Borole (Inactive) made changes - 29/Sep/17 12:23 PM

Time Spent	47.05h [ 169380 ]	52.05h [ 187380 ]
Worklog Id		82783 [ 82783 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 29/Sep/17 12:39 PM

Time Spent:

1h

Discussion, code review, functionality review

Jyoti Agrawal (Inactive) made changes - 29/Sep/17 12:42 PM

Time Spent	52.05h [ 187380 ]	53.05h [ 190980 ]
Worklog Id		82809 [ 82809 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 29/Sep/17 06:30 PM

Time Spent:

0.5h

Report server issue resolution related to localization

Hide

Permalink

Harshada Borole (Inactive) added a comment - 03/Oct/17 09:25 AM

Below are the 3C's:
Concern:-
Every benefit plan field had blank data in columnwise report.

Cause:-
In a fix for WT-10466, to form RDL field set special character were replaced by Underscore ('_').This change was missing in column-wise billing report.Due to this there were mismatch in Data Source fields and RDL fields which resulted into blank data in respective fields.

Correction:-
Replaced special characters with Underscore ('_') in Column-wise report.

Files Affected:-
OES_SP_GetBillingDetailsMonthlyColumnWise

Show

Harshada Borole (Inactive) added a comment - 03/Oct/17 09:25 AM Below are the 3C's: Concern:- Every benefit plan field had blank data in columnwise report. Cause:- In a fix for WT-10466 , to form RDL field set special character were replaced by Underscore ('_').This change was missing in column-wise billing report.Due to this there were mismatch in Data Source fields and RDL fields which resulted into blank data in respective fields. Correction:- Replaced special characters with Underscore ('_') in Column-wise report. Files Affected:- OES_SP_GetBillingDetailsMonthlyColumnWise

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

Priya Handepatil (Inactive) made changes - 04/Oct/17 06:10 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Harshada Borole (Inactive) made changes - 04/Oct/17 06:25 AM

Assignee

Harshada Borole [ harshada.borole ]

Priya Handepatil [ priya.handepatil ]

Priya Handepatil (Inactive) made changes - 04/Oct/17 08:35 AM

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 - 04/Oct/17 09:16 AM

Attachment

WT-10859.xls [ 63414 ]

Permalink

Priya Handepatil (Inactive) logged work - 04/Oct/17 09:20 AM

Time Spent:

0.75h

Testing for different Reports
JIra updates

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 04/Oct/17 09:20 AM

Hi Harshada Borole

I have verified this issue on LB

Verified with Partner Login

Verified with Company " For Qa Asml"

Its working fine
WT-10859.xls

Hence, Marking is as Ready for stage

cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande @rakesh

Thank you !

Show

Priya Handepatil (Inactive) added a comment - 04/Oct/17 09:20 AM Hi Harshada Borole I have verified this issue on LB Verified with Partner Login Verified with Company " For Qa Asml" Its working fine WT-10859.xls Hence, Marking is as Ready for stage cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande @rakesh Thank you !

Priya Handepatil (Inactive) made changes - 04/Oct/17 09:20 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 - 04/Oct/17 09:21 AM

Time Spent	53.05h [ 190980 ]	53.8h [ 193680 ]
Worklog Id		83158 [ 83158 ]

Priya Handepatil (Inactive) made changes - 04/Oct/17 09:21 AM

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

Permalink

Harshada Borole (Inactive) logged work - 05/Oct/17 08:00 AM - edited

Time Spent:

0.5h

code commit in UiRefresh branch

Hide

Permalink

Harshada Borole (Inactive) added a comment - 05/Oct/17 09:10 AM

Code check-in done for UI Refresh.

Show

Harshada Borole (Inactive) added a comment - 05/Oct/17 09:10 AM Code check-in done for UI Refresh.

Harshada Borole (Inactive) made changes - 05/Oct/17 12:08 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Harshada Borole (Inactive) made changes - 06/Oct/17 03:56 AM

Time Spent	53.8h [ 193680 ]	58.8h [ 211680 ]
Worklog Id		83467 [ 83467 ]

Harshada Borole (Inactive) made changes - 06/Oct/17 03:56 AM

Worklog Id

83467 [ 83467 ]

Harshada Borole (Inactive) made changes - 06/Oct/17 03:56 AM

Remaining Estimate	0h [ 0 ]	4.5h [ 16200 ]
Time Spent	58.8h [ 211680 ]	54.3h [ 195480 ]
Worklog Id		83467 [ 83467 ]

Rakesh Roy (Inactive) made changes - 09/Oct/17 01:55 PM

Resolution		Unresolved [ 10200 ]
Status	Stage Testing [ 10201 ]	Reopen in Stage [ 10023 ]

Rakesh Roy (Inactive) made changes - 09/Oct/17 01:55 PM

Status

Reopen in Stage [ 10023 ]

In Development [ 10007 ]

Rakesh Roy (Inactive) made changes - 09/Oct/17 01:55 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Rakesh Roy (Inactive) made changes - 12/Oct/17 03:55 PM

Priya Handepatil [ priya.handepatil ]

Priya Handepatil (Inactive) made changes - 18/Oct/17 06:52 AM

Stage Due Date

9/Oct/17 [ 2017-10-09 ]

23/Oct/17 [ 2017-10-23 ]

Priya Handepatil (Inactive) made changes - 18/Oct/17 06:52 AM

Production Due Date

12/Oct/2017

25/Oct/2017

Priya Handepatil (Inactive) made changes - 23/Oct/17 12:46 PM

Attachment

WT-10859 (c97352a5-72a8-4a47-9a02-2d725b57c4db).xls [ 65312 ]

Permalink

Priya Handepatil (Inactive) logged work - 23/Oct/17 12:47 PM

Time Spent:

0.5h

<No comment>

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 23/Oct/17 12:47 PM

Hi Harshada Borole

I have verified this issue on Azure

Verified with Partner Login

Verified with Company " City Of Denton For Hspl"

Its working fine

WT-10859.xls

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 23/Oct/17 12:47 PM Hi Harshada Borole I have verified this issue on Azure Verified with Partner Login Verified with Company " City Of Denton For Hspl" Its working fine WT-10859.xls cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank You !

Priya Handepatil (Inactive) made changes - 23/Oct/17 12:47 PM

Remaining Estimate	4.5h [ 16200 ]	4h [ 14400 ]
Time Spent	54.3h [ 195480 ]	54.8h [ 197280 ]
Worklog Id		85851 [ 85851 ]

Permalink

Harshada Borole (Inactive) logged work - 24/Oct/17 04:22 AM

Time Spent:

1h

Discussion with Priya and analysis

Harshada Borole (Inactive) made changes - 01/Nov/17 04:23 AM

Remaining Estimate	4h [ 14400 ]	3h [ 10800 ]
Time Spent	54.8h [ 197280 ]	55.8h [ 200880 ]
Worklog Id		88465 [ 88465 ]

Satya made changes - 02/Nov/17 12:15 AM

Labels

Billing

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

Environment_New

LB [ 18444 ]

Gaurav Sodani (Inactive) made changes - 20/Nov/17 11:34 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)

Gaurav Sodani (Inactive) made changes - 05/Dec/17 09:49 AM

Company

All Clients/Multiple Clients [ 18434 ]

Gaurav Sodani (Inactive) made changes - 05/Dec/17 10:13 AM

Environment

LB [ 18444 ]

Production,Stage,LB [ 18442, 18443, 18444 ]

Rakesh Roy (Inactive) made changes - 22/Jan/18 07:12 AM

Assignee

Priya Handepatil [ priya.handepatil ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 29/Mar/18 12:34 AM

Status

In LB Testing [ 10200 ]

Stage Testing [ 10201 ]

Venkatesh Pujari (Inactive) made changes - 29/Mar/18 12:34 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 29/Mar/18 12:34 AM

Resolution	Unresolved [ 10200 ]	Bug Fixed [ 10402 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Venkatesh Pujari (Inactive) made changes - 29/Mar/18 12:34 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Transition	Time In Source Status	Execution Times

Harshada Borole (Inactive) made transition - 11/Sep/17 07:38 AM

Open

In Development

13d 9m

Priya Handepatil (Inactive) made transition - 22/Sep/17 11:22 AM

In LB Testing

Reopen in Local

Prasanna Karlekar (Inactive) made transition - 25/Sep/17 06:29 AM

Reopen in Local

In Development

2d 19h 6m

Rakesh Roy (Inactive) made transition - 09/Oct/17 01:55 PM

Stage Testing

Reopened in Stage

4d 1h 46m

Rakesh Roy (Inactive) made transition - 09/Oct/17 01:55 PM

Reopened in Stage

In Development

Rakesh Roy (Inactive) made transition - 09/Oct/17 01:55 PM

In Development

In LB Testing

11d 3h 25m

Venkatesh Pujari (Inactive) made transition - 29/Mar/18 12:34 AM

In LB Testing

Stage Testing

171d 16h 36m

Venkatesh Pujari (Inactive) made transition - 29/Mar/18 12:34 AM

Stage Testing

In Production Testing

Venkatesh Pujari (Inactive) made transition - 29/Mar/18 12:34 AM

In Production Testing

Production Complete

Venkatesh Pujari (Inactive) made transition - 29/Mar/18 12:34 AM

Production Complete

Closed

16s

People

Assignee:: Venkatesh Pujari (Inactive)

Reporter:: Meghana Joshi (Inactive)

Developer:: Harshada Borole (Inactive)

QA:: Priya Handepatil (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 29/Aug/17 07:28 AM

Updated:: 29/Mar/18 12:34 AM

Resolved:: 29/Mar/18 12:34 AM

Dev Due Date:: 29/Sep/2017

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

Production Due Date:: 25/Oct/2017

Code Review Date:: 29/Sep/2017

Time Tracking

Estimated:

Remaining:

Logged:

55.8h