-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin
-
Reported by:White Label
-
Company:ATC
-
Item State:Production Complete - Closed
Can you please tell why Juan Forero has a negative total payroll deduction amount. It appear that the system is applying more credits than the employee has in deductions.
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Satya [ ID10004 ] | Abhilash Warkari [ abhilash.warkari ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
-
- Time Spent:
- 0.5h
-
discussion, script verification, comment review
| Attachment | AffectedEmployeesAtc.xls [ 71190 ] |
| Assignee | Abhilash Warkari [ abhilash.warkari ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
Please verify corrections on HSPL.
Thanks and Regards,
Abhilash Warkari
CC : Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 4h [ 14400 ] | |
| Worklog Id | 99215 [ 99215 ] |
-
- Time Spent:
- 4h
-
Analysis.
Data Analysis.
Correction on hspl
Recall credit pool
Verification
Discussion with Amruta.
Hi Abhilash Warkari,
CC:Hrishikesh Deshpande,Amruta Lohiya,Satya,Jyoti Mayne,Umesh Kadam
I have verified credit pool on confirmation statement for employees attached in the sheet.
It is showing the correct amount on HSPL copy. You can proceed to do the correction on the main company.
Thanks,
Rashmita
| Time Spent | 4h [ 14400 ] | 5.5h [ 19800 ] |
| Worklog Id | 99259 [ 99259 ] |
We have done corrections on main company and also recalculated credit pool.
Please verify and confirm.
Hi Jaideep Vinchurkar
Can you please check this and find the root cause of this?
Thanks and Regards,
Abhilash Warkari
CC : Amruta Lohiya, Jyoti Mayne, Umesh Kadam
-
- Time Spent:
- 1h
-
Data correction verification
Hi Debbie Kulling,
We have corrected Affected employees records in attached sheet.
Jaideep Vinchurkar will update you related the root cause of the issue.
Thanks,
Rashmita
| Time Spent | 5.5h [ 19800 ] | 6.5h [ 23400 ] |
| Worklog Id | 99293 [ 99293 ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
-
- Time Spent:
- 4h
-
Correction on main .
Recalculated credit pools.
Verification
| Time Spent | 6.5h [ 23400 ] | 10.5h [ 37800 ] |
| Worklog Id | 99416 [ 99416 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Ankur Deshpande [ ankur.deshpande ] |
Please send the root cause
Hi Debbie Kulling,
During the data load, while uploading the life file, the import failed due to some reason. The issue occurred due to the import failure which did not update/terminated the previous rate. Hence the calculation was showing value in negative.
Regards,
Ankur
Ankur Deshpande (Inactive)
added a comment - Hi Debbie Kulling ,
During the data load, while uploading the life file, the import failed due to some reason. The issue occurred due to the import failure which did not update/terminated the previous rate. Hence the calculation was showing value in negative.
Regards,
Ankur Ankur Deshpande (Inactive)
made changes -
| Assignee | Ankur Deshpande [ ankur.deshpande ] | Debbie Kulling [ dkulling ] |
Is there some kind of error that happens when the import fails? How do we prevent this from happening in the future?
Ankur Deshpande Do we have any more information for Debbie? Are we able to see why the import failed?
Jennifer Reed (Inactive)
added a comment - Ankur Deshpande Do we have any more information for Debbie? Are we able to see why the import failed? | Attachment | 1027201761350AM_5182_13122.txt [ 71665 ] |
Hi Debbie Kulling,
Here is log for import failure 1027201761350AM_5182_13122.txt
. This error was related to inconsistent data and that was because a yet to finish back end routine. Developer mistakenly loaded another file before finishing processing of last file.
Data was corrected and the file was loaded again. But since, enrollment was already terminated, import did not touched the rates related to that enrollment.
To overcome such issues, we have started adding our email address in templates. We do receive emails of import completion and then only we start to load new files.
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Time Spent | 10.5h [ 37800 ] | 11.5h [ 41400 ] |
| Worklog Id | 100123 [ 100123 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
We have corrected the records. There is not code fix is Identified hence marking this as completed
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 11.5h [ 41400 ] | 12h [ 43200 ] |
| Worklog Id | 101570 [ 101570 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Original Estimate | 0h [ 0 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
9h 53m | 1 |
|
8d 6h 33m | 1 |
|
12s | 1 |
|
5s | 1 |
|
1m 20s | 1 |
|
47d 56m | 1 |
Hi Debbie Kulling
Please Find Below 3Cs :
Affected EEs List :
AffectedEmployeesAtc.xls
We will share password in separate mail.
Please Let us know in case of any query.
Thanks And Regards,
Abhilash Warkari
CC :Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam