-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:
-
Environment:Production
-
Bug Type:Functional
-
Bug Severity:Critical
-
Module:BenAdmin - Report
-
Reported by:Client
-
Company:All Clients/Multiple Clients
-
Item State:Stage QA - Production Deployment on Hold
-
Sprint:WT Sprint 41
Please review the Billing Summary Report in Production - Client Name - Superheat FGH. This needs to be corrected as soon as possible, this is affecting the client and they as many other clients use this report to submit their volume and counts to their Life carriers to pay their premiums.
The following plan premiums are not calculating correctly:
Plan 1:
Basic Life - Basic Life - Lincoln Financial Group
Rate Name: 2016 - 2018 Basic Life-Basic Life
Report shows $3,134.56, but when you manually calculate it the premium comes out to be $3,134.05 (volume*rate/coverage divisor) (16072050.00*0.1950/1000). There is a difference of $0.51.
Plan 2:
Plan: Basic AD&D-Basic AD&D-Lincoln Financial Group
Rate Name: 2016 - 2018 Basic AD&D-Basic AD&D
Report shows $401.33, but when you manually calculate it the premium comes out to be $400.83 (volume*rate/coverage divisor) (16033050.00*0.0250/1000). There is a difference of $0.50.
Plan 3:
Plan: Voluntary Child Life-Voluntary Child Life-Lincoln Financial Group
Rate Name: 2016 - 2018 Vol Child life-Child Life
Report shows $75.62, but when you manually calculate it the premium comes out to be $75.73 (volume*rate/coverage divisor) (380000.00*0.1993/1000). There is a difference of $0.11.
This is also similar to WT 9738.
- causes
-
-
- Production Complete
-
- clones
-
-
- Closed
-
- is caused by
-
-
- Closed
-
Environment: Codemap
Company: For QA Town of Carry, For QA Kindercare ASML
Reports: Billing Details report and Billing Summary report
The bug is tested for attached scenarios. Screen capture for the same is attached with jira.
During testing last test case for Billing report is failed. As Billing report when run is giving server error.
Error log for the same is attached with jira.
Unable to embed resource: BillingReportServerError.txt of type text/plain
So, re-opening the jira for the same.
Hi Priya Dhamande,
The report throwing an exception due to NF-5395 check is pending for localization files.
Parmeshwar Jumbad (Inactive)
added a comment - - edited Hi Priya Dhamande ,
The report throwing an exception due to NF-5395 check is pending for localization files.
CC: Prasanna Karlekar Gaurav Sodani The jira testing is kept on Hold till related NF-5395 is deployed on Codemap.
[~parmeshwar.jumbade]
Why is this JIRA with you? What work is pending here?
Nidhi.
Nidhi Kaul (Inactive)
added a comment - [~parmeshwar.jumbade]
Why is this JIRA with you? What work is pending here?
Nidhi. Parmeshwar Jumbad (Inactive)
added a comment - Hi Nidhi Kaul ,
No work pending on this. Updated with proper status now.
CC: Prasanna Karlekar Environment: Codemap
Company: For QA CHMC and For QA Kindercare
Login: Partner
Issue: Billing Summary report appearing blank
As per discussion with Parmeshwar, the server is not matching. Si, reopening the jira for the same.
Hi Priya Dhamande,
Report working properly on this company now.
As per discussion with you, i will check availability of separate report server with Prasanna/Ashwin.
For now we are using same server for development and code-map environment.
Parmeshwar Jumbad (Inactive)
added a comment - Hi Priya Dhamande ,
Report working properly on this company now.
As per discussion with you, i will check availability of separate report server with Prasanna/Ashwin.
For now we are using same server for development and code-map environment.
CC: Prasanna Karlekar Gaurav Sodani Hi [~parmeshwar.jumbade],
Checked this issue on Codemap.
Company: For QA CHMC
Login: sa
Billing Summary Report
The Total Premium is calculated correctly for some plans. However, there are discrepancies in Total Premium few plans.
(Please refer the screenshot below)
As discussed, request you to please look into this.
Thank you,
-------------------------------------------------
CC: Mandar Kulkarni, Satya, Prasanna Karlekar, Sachin Hingole
Prasad Patil (Inactive)
added a comment - Hi [~parmeshwar.jumbade] ,
Checked this issue on Codemap.
Company: For QA CHMC
Login: sa
Billing Summary Report
The Total Premium is calculated correctly for some plans. However, there are discrepancies in Total Premium few plans.
(Please refer the screenshot below)
As discussed, request you to please look into this.
Thank you,
-------------------------------------------------
CC: Mandar Kulkarni , Satya , Prasanna Karlekar , Sachin Hingole Hi Prasad Patil,
Have checked above discrepancies in Total premium and below are the reasons for reported issues:
1. Cost not calculated after value/customization changes of mapped rate/plans.
As you mentioned for "Plan: Basic Life/ AD&D (Full Coverage - $500000)-Basic Life-Sun Life Financial" rates showing 1.5000 but actual cost calculated with the value "0.0730000000". So, current Total premium amount (i.e. $1.29) value is correct with the rate amount "0.0730000000". Need to recalculate rates using SA utility. Same needs to be done for "Optional Child Life (CHMC) (Exec)-Optional Life - Child-Sun Life Financial" plan.
Regarding, premium showing incorrect for "Optional Child Life (CHMC) (All Others)-Optional Life - Child-Sun Life Financial" plan because there are elections with zero coverage but premium for elections having some value.
Jyoti Mayne/Umesh Kadam, I tried to recalculate rates through SA Utility but still updated cost not getting to the elections. Please look into this.
Parmeshwar Jumbad (Inactive)
added a comment - - edited Hi Prasad Patil ,
Have checked above discrepancies in Total premium and below are the reasons for reported issues:
1. Cost not calculated after value/customization changes of mapped rate/plans.
As you mentioned for "Plan: Basic Life/ AD&D (Full Coverage - $500000)-Basic Life-Sun Life Financial" rates showing 1.5000 but actual cost calculated with the value "0.0730000000". So, current Total premium amount (i.e. $1.29) value is correct with the rate amount "0.0730000000". Need to recalculate rates using SA utility. Same needs to be done for "Optional Child Life (CHMC) (Exec)-Optional Life - Child-Sun Life Financial" plan.
Regarding, premium showing incorrect for "Optional Child Life (CHMC) (All Others)-Optional Life - Child-Sun Life Financial" plan because there are elections with zero coverage but premium for elections having some value.
Jyoti Mayne / Umesh Kadam , I tried to recalculate rates through SA Utility but still updated cost not getting to the elections. Please look into this.
CC: Prasanna Karlekar Gaurav Sodani [~parmeshwar.jumbade]
What should be the status of t JIRA in that case?
Prasanna Karlekar
Nidhi.
Nidhi Kaul (Inactive)
added a comment - [~parmeshwar.jumbade]
What should be the status of t JIRA in that case?
Prasanna Karlekar
Nidhi. Hi [~parmeshwar.jumbade],
As discussed, we verify the cost and billing data for given EE and it is looking fine.
Thanks,
Snehal Shabade
CC: Umesh Kadam
Snehal Shabade (Inactive)
added a comment - Hi [~parmeshwar.jumbade] ,
As discussed, we verify the cost and billing data for given EE and it is looking fine.
Thanks,
Snehal Shabade
CC: Umesh Kadam
Hi Prasad Patil,
Verified data after recalculates rates through SA utility for month Jan 2018 and it is showing as per configurations. Please do verify and let us know.
Snehal Shabade, Please verify coverage and premium for Optional Child Life (CHMC) (Exec) plan and if it is proper then update same here.
Note: If there is any changes in rates and plan customization's it needs to recalculates through SA utility to reflect changes on this report.
Parmeshwar Jumbad (Inactive)
added a comment - - edited Hi Prasad Patil ,
Verified data after recalculates rates through SA utility for month Jan 2018 and it is showing as per configurations. Please do verify and let us know.
Snehal Shabade , Please verify coverage and premium for Optional Child Life (CHMC) (Exec) plan and if it is proper then update same here.
Note: If there is any changes in rates and plan customization's it needs to recalculates through SA utility to reflect changes on this report.
CC: Umesh Kadam Prasanna Karlekar Gaurav Sodani Hi [~parmeshwar.jumbade],
As discussed ,we verified coverage and premium for Optional Child Life (CHMC) (Exec) plan for given EE and it is looking fine.
Thanks,
Snehal Shabade
CC: Umesh Kadam
Snehal Shabade (Inactive)
added a comment - Hi [~parmeshwar.jumbade] ,
As discussed ,we verified coverage and premium for Optional Child Life (CHMC) (Exec) plan for given EE and it is looking fine.
Thanks,
Snehal Shabade
CC: Umesh Kadam Hi [~parmeshwar.jumbade],
Verified the Billing summary report on Pre-Prod Environment. Working fine as expected.
Thank you,
----------------------------------
CC: Mandar Kulkarni, Satya, Gaurav Sodani
Prasad Patil (Inactive)
added a comment - Hi [~parmeshwar.jumbade] ,
Verified the Billing summary report on Pre-Prod Environment. Working fine as expected.
Thank you,
----------------------------------
CC: Mandar Kulkarni , Satya , Gaurav Sodani Verified on production.
Verified all test cases.Working as expected.
PFA,
Thanks,
Sanjana Jadhav
For all details please refer
WT-11470.