[WT-10316] Sea Tac - Invoice Adjustment Issue - Workterra Jira

Details

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

Environment:

Production
Bug Type:
Functional
Bug Severity:
Medium
Module:
BenAdmin - Report
Reported by:
Client
Company:
All Clients/Multiple Clients
Item State:
Production Complete - Closed

Description

Background: BCC has an incorrect update rule at the rate level that was causing the new elections to get a rate/age band as of January 1st. I had BCC correct the rule and manually go in an correct the impacted employees. That fixed the invoice amounts but there are some strange adjustments coming out on the August bill. My guess is after researching that some bad date/costs are in the billing table due to all the changes. This impacts two employees

Tim Ramsaur’s billing - he experienced a birthday in June and is being billed for entire month of June. His date of birth was June 25th? He should not be billed the increase rate until July's bill?

Gus Garcia DOB:4/22/72 (age 45)
Please note: Gus also had a volume change as the group first told us he should have 150k, then the group advised 100K, and finally it was decided that 150K was approved by Sun Life after all.

Invoice costs/adjustments before rate was corrected
April- $17.10 (age 44), volume 150K
May- we billed 11.40, volume 100K
June – we billed 25.65, volume 150K( adjustment for May, credit 11.40 and re-bill for 25.65)
July- we billed 25.65, volume 150K

After rate correction below are the adjustments on the current August invoice.
August – is billing correctly
July adj is a wash. – this is fine.
June is billing 42.75 and crediting 25.65?
May is billing 42.75 and crediting 25.65?
April is billing 5.13 and crediting 7.70? – Not sure why this adjustment is appearing for Garcia?

Attachments

Issue Links

is cloned by

NF-5133 Sea Tac - Invoice Adjustment Issue

Closed

Activity

Ascending order - Click to sort in descending order

Debbie Kulling created issue - 26/Jul/17 08:34 PM

Rakesh Roy (Inactive) made changes - 27/Jul/17 03:57 AM

Field	Original Value	New Value
Module	Parent values: BenAdmin(10100)	Parent values: BenAdmin(10100)Level 1 values: Report(10109)

Prasanna Karlekar (Inactive) made changes - 27/Jul/17 04:24 AM

Assignee

Prasanna Karlekar [ prasanna ]

Jyoti Agrawal [ jyoti.agrawal ]

Permalink

Jyoti Agrawal (Inactive) logged work - 27/Jul/17 12:52 PM

Time Spent:

6.5h

Analysis, Code fix, unit testing, Discussion with Prasanna

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 27/Jul/17 01:17 PM

Hi Debbie Kulling,

We have found the root cause and working on the fix.

Show

Jyoti Agrawal (Inactive) added a comment - 27/Jul/17 01:17 PM Hi Debbie Kulling , We have found the root cause and working on the fix.

Permalink

Prasanna Karlekar (Inactive) logged work - 27/Jul/17 11:30 PM

Time Spent:

0.75h

Discussion on fix to be made

Jyoti Agrawal (Inactive) made changes - 28/Jul/17 09:07 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Jyoti Agrawal (Inactive) made changes - 28/Jul/17 09:07 AM

Code Review Date		28/Jul/2017
Code Reviewed By		Prasanna Karlekar [ 11907 ]

Jyoti Agrawal (Inactive) made changes - 28/Jul/17 09:07 AM

Item State

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

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 28/Jul/17 09:22 AM

Hi Debbie Kulling,
We have done the code fix and deployed it on our QA environment. It will move on production as per build process.
We have also executed the fix on Production Sea tac. The adjustment of mentioned employees are proper now. Please verify.

Below are 3C's
Concern :- Invoice Adjustment Issue
Cause :- Term as never effective records were getting as retro add for non health plans
Correction :- We added condition to handle this.

Show

Jyoti Agrawal (Inactive) added a comment - 28/Jul/17 09:22 AM Hi Debbie Kulling , We have done the code fix and deployed it on our QA environment. It will move on production as per build process. We have also executed the fix on Production Sea tac. The adjustment of mentioned employees are proper now. Please verify. Below are 3C's Concern :- Invoice Adjustment Issue Cause :- Term as never effective records were getting as retro add for non health plans Correction :- We added condition to handle this.

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 28/Jul/17 09:23 AM

Affected files : OES_SP_GetRetroBillingDetails_InvoiceBenefitWise

Affected areas : Adjustment of billing for non helath

Tested scenarios :
Tested adjustment for termed as never active elections for non health plans

Show

Jyoti Agrawal (Inactive) added a comment - 28/Jul/17 09:23 AM Affected files : OES_SP_GetRetroBillingDetails_InvoiceBenefitWise Affected areas : Adjustment of billing for non helath Tested scenarios : Tested adjustment for termed as never active elections for non health plans

Khandu Kshirsagar (Inactive) made changes - 28/Jul/17 10:55 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 - 28/Jul/17 11:03 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 28/Jul/17 12:45 PM

Assignee

Sachin Hingole [ sachin.hingole ]

Venkatesh Pujari [ venkatesh.pujari ]

Sachin Hingole (Inactive) made changes - 28/Jul/17 12:45 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jyoti Agrawal (Inactive) made changes - 28/Jul/17 12:53 PM

Remaining Estimate		0h [ 0 ]
Time Spent		6.5h [ 23400 ]
Worklog Id		67712 [ 67712 ]

Permalink

Jyoti Agrawal (Inactive) logged work - 28/Jul/17 12:56 PM

Time Spent:

2h

unit testing, data verification on production, Code check-in

Jyoti Agrawal (Inactive) made changes - 28/Jul/17 12:57 PM

Time Spent	6.5h [ 23400 ]	8.5h [ 30600 ]
Worklog Id		67722 [ 67722 ]

Prasanna Karlekar (Inactive) made changes - 31/Jul/17 09:11 AM

Time Spent	8.5h [ 30600 ]	9.25h [ 33300 ]
Worklog Id		68184 [ 68184 ]

Venkatesh Pujari (Inactive) made changes - 01/Aug/17 11:20 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)

Permalink

Venkatesh Pujari (Inactive) logged work - 01/Aug/17 12:51 PM

Time Spent:

2h

Testing on LB

Venkatesh Pujari (Inactive) made changes - 01/Aug/17 12:51 PM

Time Spent	9.25h [ 33300 ]	11.25h [ 40500 ]
Worklog Id		68671 [ 68671 ]

Venkatesh Pujari (Inactive) made changes - 02/Aug/17 06:28 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)

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 02/Aug/17 06:30 AM

Hi Jyoti Agrawal,

Could not reproduce the scenario which had caused the issue but verified invoice details for non health plans. Billing and adjustments displayed correctly. Please note that this scenario cannot be reproduced on Stage also. So I have tested the invoice on Production Hspl copy.

Prasanna Karlekar,Sachin Hingole

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 02/Aug/17 06:30 AM Hi Jyoti Agrawal , Could not reproduce the scenario which had caused the issue but verified invoice details for non health plans. Billing and adjustments displayed correctly. Please note that this scenario cannot be reproduced on Stage also. So I have tested the invoice on Production Hspl copy. Prasanna Karlekar , Sachin Hingole Thanks, Venkatesh

Venkatesh Pujari (Inactive) made changes - 02/Aug/17 06:31 AM

Time Spent	11.25h [ 40500 ]	13.25h [ 47700 ]
Worklog Id		68775 [ 68775 ]

Permalink

Venkatesh Pujari (Inactive) logged work - 02/Aug/17 06:30 PM

Time Spent:

2h

Testing on LB

Prasanna Karlekar (Inactive) made changes - 07/Aug/17 08:32 AM

Developer		Jyoti Agrawal [ jyoti.agrawal ]
Original Estimate		0h [ 0 ]

Khandu Kshirsagar (Inactive) made changes - 09/Aug/17 07: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)

Venkatesh Pujari (Inactive) made changes - 09/Aug/17 11:49 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)

Venkatesh Pujari (Inactive) made changes - 09/Aug/17 11:49 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

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

Venkatesh Pujari (Inactive) made changes - 10/Aug/17 08:29 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 10/Aug/17 08:29 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)

Permalink

Venkatesh Pujari (Inactive) logged work - 10/Aug/17 10:01 AM

Time Spent:

1h

Testing on Production copy

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 10/Aug/17 10:01 AM

Hi Debbie Kulling,

Verified invoice details for non health plans. Billing and adjustments displayed correctly. I have tested the invoice on Production main copy. Please could you verify and close this ticket

Prasanna Karlekar,Sachin Hingole

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 10/Aug/17 10:01 AM Hi Debbie Kulling , Verified invoice details for non health plans. Billing and adjustments displayed correctly. I have tested the invoice on Production main copy. Please could you verify and close this ticket Prasanna Karlekar , Sachin Hingole Thanks, Venkatesh

Venkatesh Pujari (Inactive) made changes - 10/Aug/17 10:01 AM

Assignee	Venkatesh Pujari [ venkatesh.pujari ]	Debbie Kulling [ dkulling ]
Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Venkatesh Pujari (Inactive) made changes - 10/Aug/17 10:01 AM

Item State

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

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

Venkatesh Pujari (Inactive) made changes - 10/Aug/17 10:02 AM

Time Spent	13.25h [ 47700 ]	14.25h [ 51300 ]
Worklog Id		70819 [ 70819 ]

Rakesh Roy (Inactive) made changes - 18/Aug/17 09:56 AM

Bug Type		Functional [ 15402 ]
Code Review Date	28/Jul/2017	28/Jul/2017

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

Environment_New

Production [ 18442 ]

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

Link

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

Debbie Kulling made changes - 27/Feb/18 03:50 PM

Resolution	Done [ 10000 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Rakesh Roy (Inactive) made changes - 03/Mar/18 04:52 AM

Company		All Clients/Multiple Clients [ 18434 ]
Root Cause		Bug [ 18430 ]

Transition	Time In Source Status	Execution Times

Jyoti Agrawal (Inactive) made transition - 28/Jul/17 09:07 AM

Open

In Development

1d 12h 32m

Sachin Hingole (Inactive) made transition - 28/Jul/17 12:45 PM

In Development

In LB Testing

3h 38m

Venkatesh Pujari (Inactive) made transition - 09/Aug/17 11:49 AM

In LB Testing

Stage Testing

11d 23h 3m

Venkatesh Pujari (Inactive) made transition - 10/Aug/17 08:29 AM

Stage Testing

In Production Testing

20h 40m

Venkatesh Pujari (Inactive) made transition - 10/Aug/17 10:01 AM

In Production Testing

Production Complete

1h 31m

Debbie Kulling made transition - 27/Feb/18 03:50 PM

Production Complete

Closed

201d 6h 48m

People

Assignee:: Debbie Kulling

Reporter:: Debbie Kulling

Account Executive:: Debbie Kulling

Developer:: Jyoti Agrawal (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 26/Jul/17 08:34 PM

Updated:: 03/Mar/18 04:52 AM

Code Review Date:: 28/Jul/2017

Time Tracking

Estimated:

Remaining:

Logged:

14.25h