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

Duplicate election inserted by General mode while Core Plan allocation.(Import)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Data Audit
    • Item State:
      Development - In Analysis
    • Sprint:
      WT Sprint 35 - Bugs

      Description

      Duplicate election inserted by General mode while Core Plan allocation. This is issue caused by import.

      Please refer attached excel sheet for employee name,Client Name.

      CC-- Jaideep Vinchurkar,Amruta Lohiya,Satya,Vijay Siddha

        Attachments

          Activity

          avnish.yadav Avnish Yadav (Inactive) created issue -
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Attachment Duplicate_Election.xls [ 58043 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Bug Severity Critical [ 16701 ] Medium [ 16702 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 35 - Bugs [ 81 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Developer Suraj Sokasane [ suraj.sokasane ]
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Attachment Duplicate_Election_Updated.xls [ 59172 ]
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Avnish Yadav,

          We went through all enrollments, none of them seems to be caused due to Import except one. I've updated all reasons to corresponding records.Here's updated excel: Duplicate_Election_Updated.xls

          CC- Jaideep Vinchurkar

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Avnish Yadav , We went through all enrollments, none of them seems to be caused due to Import except one. I've updated all reasons to corresponding records.Here's updated excel: Duplicate_Election_Updated.xls CC- Jaideep Vinchurkar
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 18/Aug/17 12:52 PM
          • Time Spent:
            6.5h
             

            Analysis of all duplicate elections and their connection with Import.

          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Avnish Yadav [ avnish.yadav ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 6.5h [ 23400 ]
          Worklog Id 72688 [ 72688 ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited

          Hi Suraj Sokasane,

          Please verify Karma company, we found core plan enrollments are insert in General mode.

          Thanks,
          Avnish Y

          CC-- Jaideep Vinchurkar

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited Hi Suraj Sokasane , Please verify Karma company, we found core plan enrollments are insert in General mode. Thanks, Avnish Y CC-- Jaideep Vinchurkar
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Suraj Sokasane [ suraj.sokasane ]
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          HI Avnish Yadav,

          Though the enrollments are by General mode, it isn't from Import. There was no import on that day or no back end routine execution.
          When analyzed, we also found that there was no data change on this day. Import picks up any employee for backend routine only if there is change. Same goes to UI. Plan term date was changed even though there wasn't Employee data change. This is different scenario and needs to be analyzed in detail.
          Over to you.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - HI Avnish Yadav , Though the enrollments are by General mode, it isn't from Import. There was no import on that day or no back end routine execution. When analyzed, we also found that there was no data change on this day. Import picks up any employee for backend routine only if there is change. Same goes to UI. Plan term date was changed even though there wasn't Employee data change. This is different scenario and needs to be analyzed in detail. Over to you.
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Avnish Yadav [ avnish.yadav ]
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 24/Aug/17 01:47 PM
          • Time Spent:
            6.5h
             

            Analysis of duplicate enrollments on Karma as well as other companies having similar pattern.

          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Time Spent 6.5h [ 23400 ] 13h [ 46800 ]
          Worklog Id 74142 [ 74142 ]
          Hide
          gaurav.sodani Gaurav Sodani (Inactive) added a comment -

          Hi Avnish Yadav,

          Could you please look into the issue

          Thanks
          Gaurav

          CC: SatyaVijay SiddhaJaideep Vinchurkar

          Show
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Avnish Yadav , Could you please look into the issue Thanks Gaurav CC: Satya Vijay Siddha Jaideep Vinchurkar
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Hrishikesh Deshpande,

          We have tried all possible scenario to reproduce this issue. So could you please reproduce this issue at your end.

          Thanks,
          Avnish Y

          CC-- Amruta Lohiya,Satya,Vijay Siddha

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Hrishikesh Deshpande , We have tried all possible scenario to reproduce this issue. So could you please reproduce this issue at your end. Thanks, Avnish Y CC-- Amruta Lohiya , Satya , Vijay Siddha
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Priority Highest [ 1 ] Medium [ 3 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Jayshree Nagpure [ jayshree.nagpure ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Jayshree Nagpure Please take this point on Sep 19 and update for next action.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Jayshree Nagpure Please take this point on Sep 19 and update for next action.
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified on Stage

          City of bellevue for hspl

          Following are my observations :

          1)Add Emp in the system - Employee gets core plan if eligible ( Single enrollment found)
          2)Enrolled Emp in some benefit - Single enrollment is found
          3)For Any data change in import -> Emp gets plan as per eligibility (Single enrollment is found)

          Thanks,
          Jayshree

          cc : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage City of bellevue for hspl Following are my observations : 1)Add Emp in the system - Employee gets core plan if eligible ( Single enrollment found) 2)Enrolled Emp in some benefit - Single enrollment is found 3)For Any data change in import -> Emp gets plan as per eligibility (Single enrollment is found) Thanks, Jayshree cc : Rakesh Roy Prasad Pise
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Assignee Jayshree Nagpure [ jayshree.nagpure ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Avnish Yadav [ avnish.yadav ]
          Resolution Cannot Reproduce [ 5 ]
          Status In Development [ 10007 ] Rejected [ 10004 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Issue Category Harbinger [ 10700 ] Data Audit [ 18400 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Rejected [ 10004 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Suraj Sokasane (Inactive) made transition -
          Open In Development
          8d 23h 29m 1
          Hrishikesh Deshpande (Inactive) made transition -
          In Development Rejected
          32d 6h 10m 1
          Rakesh Roy (Inactive) made transition -
          Rejected Closed
          149d 21h 4m 1

            People

            Assignee:
            avnish.yadav Avnish Yadav (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Developer:
            Suraj Sokasane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 13h
                13h