[WT-7027] WT -> BCC Invoice Enhancement -> Invoice is not showing all the employee records completely - Workterra Jira

Details

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

Environment:

Production
Module:
BenAdmin - Report
Reported by:
Harbinger
Item State:
Production Complete - Closed

Description

TIBCO for HSPL
Production

created a template for all employees - FSA Admin plan - this is a health plan
fetched out invoice for Jan 2017
on the other hand- fetch out standard enrollment report for FSA Admin plan - all employees from 01/01/2016 to 12/31/2017 [no dead enrollments]

Enrollment report showed me 514 employee records whereas Invoice showed me only 77 employee records ! Remaining records are missing from Invoice 2017 Jan

CC - Rakesh Roy shyam sharma Hrishikesh Deshpande Venkatesh Pujari

Attachments

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

Attachments

Enrollment - FSAEnrollment.xls
96 kB
09/Dec/16 09:26 AM
Invoice FSA Admin.xlsx
6 kB
09/Dec/16 09:26 AM

Issue Links

relates to

WT-6331 BCC Invoice Management - Adjustments in future Invoice

Closed

Activity

Ascending order - Click to sort in descending order

9 older comments

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 07/Feb/17 10:17 AM

This needs to be verified.

cc: Venkatesh Pujari, Jyoti Agrawal

Show

Prasanna Karlekar (Inactive) added a comment - 07/Feb/17 10:17 AM This needs to be verified. cc: Venkatesh Pujari , Jyoti Agrawal

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 24/Feb/17 02:20 PM

Hi Venkatesh Pujari,

We have tried fixing code for most issues.
There are few scenarios for which discrepancy can still be seen :-
1. Discrepancy due to Show Enrolled flag in enrollment report. When flag is set to Enrolled , this will give only active enrollments in report. While Invoice will show all records that are active as well as records that have been Terminated in that span.
Flag Enrolled and Terminated in enrollment report will give all record which are active as well terminated in provided span.

2. When there is enrollment change in mid of month (due to Tier change, Plan change etc), enrollment report picks both enrollments. Where as Invoice picks either single record or both depending on the Billing Policy set.

There can be more such scenarios which can create discrepancy. After analysis and testing we have found two. We request you check these from your end and let us know if you find any discrepancy. We will verify those records.

We will be giving code fix in LB on Monday (2/27/17).

Thanks,
Jyoti Agrawal

CC : Prasanna Karlekar

Show

Jyoti Agrawal (Inactive) added a comment - 24/Feb/17 02:20 PM Hi Venkatesh Pujari , We have tried fixing code for most issues. There are few scenarios for which discrepancy can still be seen :- 1. Discrepancy due to Show Enrolled flag in enrollment report. When flag is set to Enrolled , this will give only active enrollments in report. While Invoice will show all records that are active as well as records that have been Terminated in that span. Flag Enrolled and Terminated in enrollment report will give all record which are active as well terminated in provided span. 2. When there is enrollment change in mid of month (due to Tier change, Plan change etc), enrollment report picks both enrollments. Where as Invoice picks either single record or both depending on the Billing Policy set. There can be more such scenarios which can create discrepancy. After analysis and testing we have found two. We request you check these from your end and let us know if you find any discrepancy. We will verify those records. We will be giving code fix in LB on Monday (2/27/17). Thanks, Jyoti Agrawal CC : Prasanna Karlekar

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 07/Mar/17 07:46 AM

Hi Jyoti Agrawal,

Verified the above points on LB on ASML company and observed the records are being displayed correctly.

Prasanna Karlekar

This is ready for Stage.

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 07/Mar/17 07:46 AM Hi Jyoti Agrawal , Verified the above points on LB on ASML company and observed the records are being displayed correctly. Prasanna Karlekar This is ready for Stage. Thanks, Venkatesh

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 23/Mar/17 07:39 AM

Hi Jyoti Agrawal,

Verified the above points on Stage on AFI For Hspl company and observed the records are being displayed correctly.

Prasanna Karlekar

This is ready for Production.

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 23/Mar/17 07:39 AM Hi Jyoti Agrawal , Verified the above points on Stage on AFI For Hspl company and observed the records are being displayed correctly. Prasanna Karlekar This is ready for Production. Thanks, Venkatesh

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 29/Mar/17 09:36 AM

Hi Jyoti Agrawal,

Verified the above points on Production on City Of Redding For Hspl company and observed the records are being displayed correctly.

Prasanna Karlekar

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 29/Mar/17 09:36 AM Hi Jyoti Agrawal , Verified the above points on Production on City Of Redding For Hspl company and observed the records are being displayed correctly. Prasanna Karlekar Thanks, Venkatesh

People

Assignee:: Alankar Chavan (Inactive)

Reporter:: Alankar Chavan (Inactive)

Developer:: Jyoti Agrawal (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 09/Dec/16 09:31 AM

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

Resolved:: 29/Mar/17 09:36 AM

Dev Due Date:: 24/Feb/2017

Code Review Date:: 27/Feb/2017

Time Tracking

Estimated:

Remaining:

Logged:

32h