WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-2034

RCF - Duplicate entries in inserted in RateChanges_log table during rate recalculation using SA utility

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Development - In Analysis
    • Issue Importance:
      Must Have

      Description

      Eami Subject: UND - Supplemental Life in Production not Calculating Correctly

      The Supplemental Life is not calculating correctly in Production for UND.
      Please find the details about following issue -

      Concern: Cost not displayed properly for Supplemental Life enrollments

      Cause: We found that, there are duplicate entries in inserted in RateChanges_log table during rate recalculation using SA utility on 10/15/2015. Because of this incorrect cost displayed for this plan.

      Correction: We have removed unwanted(duplicate) entries related from RateChanges_log table, Now cost displayed properly for Supplemental Life elections.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-10148 RCF - Data Audit- Duplicate Rates patterns for clients.

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-2045 RCF - • Employbridge-PROD- 2016 Dental PPO - High Option - 4KO Kohler Rate miscalculating--duplicate entry in Enrollment rate table

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4762 DATA AUDIT : Main

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Priority Medium [ 3 ] High [ 2 ]
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Amnesh Goel [ amnesh.goel ]
            Issue Importance Must Have [ 11800 ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Assignee Amnesh Goel [ amnesh.goel ] Neelam Yangal [ neelam.yangal ]
            satyap Satya made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            satyap Satya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            satyap Satya made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Deepali Tidke [ deepalit ]
            satyap Satya made changes -
            Item State Parent values: Development(10200) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Link This issue relates to WT-2045 [ WT-2045 ]
            Hide
            Permalink
            deepalit Deepali Tidke (Inactive) added a comment -

            kindly discuss with Amruta first and then start with it

            Show
            deepalit Deepali Tidke (Inactive) added a comment - kindly discuss with Amruta first and then start with it
            deepalit Deepali Tidke (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            As discussion with Amruta and Neelam will be able to check this after they provide me the script through which this can be tested.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - As discussion with Amruta and Neelam will be able to check this after they provide me the script through which this can be tested.
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Please assign this ticket to me once you attach the script with this ticket through which I will be able to test this ticket

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Please assign this ticket to me once you attach the script with this ticket through which I will be able to test this ticket
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Neelam Yangal [ neelam.yangal ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)Level 1 values: On Hold(10207)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            amruta.lohiya Amruta Lohiya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            amruta.lohiya Amruta Lohiya made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: LB QA(10201)
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Venkatesh Pujari What's pending?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Venkatesh Pujari What's pending?
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Rakesh,

            The tickets are in queue. So when they will take this ticket I will be able to test this after they give a solution.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Rakesh, The tickets are in queue. So when they will take this ticket I will be able to test this after they give a solution. Thanks, Venkatesh
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Neelam Yangal [ neelam.yangal ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Neelam Yangal
            What's the plan?

            Amruta Lohiya Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal What's the plan? Amruta Lohiya Vijay Siddha
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Neelam Yangal Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal Vijay Siddha
            Hide
            Permalink
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Samir
            As per our discussion, need audit and correction team for this.

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Samir As per our discussion, need audit and correction team for this.
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Samir [ samir ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            satyap Satya made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-4762 [ WT-4762 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Severity Complex [ 13103 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Samir [ samir ] Avnish Yadav [ avnish.yadav ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 06/Jul/17 01:05 PM
            • Time Spent:
              4h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ]
            Original Estimate 40h [ 144000 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ] 36h [ 129600 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 61218 [ 61218 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 07/Jul/17 05:32 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 10/Jul/17 05:33 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 11/Jul/17 05:34 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 12/Jul/17 05:35 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 36h [ 129600 ] 28h [ 100800 ]
            Time Spent 4h [ 14400 ] 12h [ 43200 ]
            Worklog Id 62878 [ 62878 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 28h [ 100800 ] 20h [ 72000 ]
            Time Spent 12h [ 43200 ] 20h [ 72000 ]
            Worklog Id 62880 [ 62880 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 12h [ 43200 ]
            Time Spent 20h [ 72000 ] 28h [ 100800 ]
            Worklog Id 62882 [ 62882 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 4h [ 14400 ]
            Time Spent 28h [ 100800 ] 36h [ 129600 ]
            Worklog Id 62884 [ 62884 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 13/Jul/17 02:17 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 36h [ 129600 ] 44h [ 158400 ]
            Worklog Id 63184 [ 63184 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 14/Jul/17 05:46 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 44h [ 158400 ] 52h [ 187200 ]
            Worklog Id 63791 [ 63791 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 17/Jul/17 05:47 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 52h [ 187200 ] 60h [ 216000 ]
            Worklog Id 64123 [ 64123 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Link This issue relates to WT-10148 [ WT-10148 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            Permalink
            avnish.yadav Avnish Yadav (Inactive) added a comment -

            Same as WT-10148

            Show
            avnish.yadav Avnish Yadav (Inactive) added a comment - Same as WT-10148
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            satyap Satya made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Satya made transition -
            Open In Development
            		38d 32m 1
            Amruta Lohiya made transition -
            In Development In LB Testing
            		8d 16h 54m 2
            Rakesh Roy (Inactive) made transition -
            In LB Testing Reopen in Local
            		64d 3h 7m 2
            Satya made transition -
            Reopen in Local In Development
            		12d 6h 57m 2
            Avnish Yadav (Inactive) made transition -
            In Development Rejected
            		334d 14m 1
            Satya made transition -
            Rejected Closed
            		5d 22m 1

              People

              Assignee:
              avnish.yadav Avnish Yadav (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Account Executive:
              Satya
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 40h Original Estimate - 40h
                  40h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 60h
                  60h