WORKTERRAProject Type: software

WORKTERRA

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

RCF - • Employbridge-PROD- 2016 Dental PPO - High Option - 4KO Kohler Rate miscalculating--duplicate entry in Enrollment rate table

    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:
      LB QA - On Hold
    • Issue Importance:
      Must Have

      Description

      For Employee Eddie Heeder the 2016 Dental PPO - High Option - 4KO Kohler Rate is doubling for 2016. I checked SA utility and the rate is correct for 2015 but it is doubling for 2016. Please see below. I tried recalculating it but it still shows double. Can you take a look please?

      We have deleted duplicate rate entry. It is working fine now.

      There was duplicate entry in Enrollment rate table which I had deleted because of that rates were coming right after correction.
      Then after correction when you re-enrolled him again, duplicate entries for same rate and sub rate entered into table. We will have to debug this duplicate rates calculation. We will get back to you soon.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-2034 RCF - Duplicate entries in inserted in RateChanges_log table during rate recalculation using SA utility

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

          Bug - A problem which impairs or prevents the functions of the product. WT-2050 RCF - Rate issues for RDS 25--duplicate entries in DB

          • 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 -
            satyap Satya made changes -
            Field Original Value New Value
            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-2034 [ WT-2034 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Link This issue relates to WT-2050 [ WT-2050 ]
            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 ]
            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.
            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 -

            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 ]
            Hide
            Permalink
            amruta.lohiya Amruta Lohiya added a comment -

            We will start this script checking task with new resource.

            Show
            amruta.lohiya Amruta Lohiya added a comment - We will start this script checking task with new resource.
            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: Development(10200)Level 1 values: Ready for Local Testing(10209)
            amruta.lohiya Amruta Lohiya made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) 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 -

            Amruta Lohiya Venkatesh PujariIs there something pending on this?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Amruta Lohiya Venkatesh Pujari Is there something pending on this?
            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 -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Neelam Yangal [ neelam.yangal ]
            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 Any update.
            Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal Any update. 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 ]
            Hide
            Permalink
            amruta.lohiya Amruta Lohiya added a comment -

            WT-2034

            Show
            amruta.lohiya Amruta Lohiya added a comment - WT-2034
            amruta.lohiya Amruta Lohiya made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            admin01 admin 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 3m 1
            Amruta Lohiya made transition -
            In Development In LB Testing
            		8d 16h 50m 2
            Rakesh Roy (Inactive) made transition -
            In LB Testing Reopen in Local
            		64d 3h 12m 2
            Satya made transition -
            Reopen in Local In Development
            		12d 6h 58m 2
            Amruta Lohiya made transition -
            In Development Rejected
            		313d 21h 59m 1
            admin made transition -
            Rejected Closed
            		1h 11m 1

              People

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

                Dates

                Created:
                Updated:
                Resolved: