WORKTERRAProject Type: software

WORKTERRA

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

WT:- Rate entries getting dead while importing an election with termination date

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Development - In Analysis
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Scenario:-

      1] Imported an election with effective date as 07/01/2016 without termination date. This plan election has a rate mapped effective from 07/01/2016 to 12/31/2017.

      2] Now import the same election with termination date as 09/30/2016 and observe the ratechanges_log table.

      Actual Result:-
      Ratechanges_log table is making the entries dead and then inserting the entries with correct terminationdate.

      Expected Result:-
      Ratechanges_log table should alter the existing entries with correct terminationdate and not make any entries dead.

      NOTE:- This works fine if we terminate the election through UI.

      Prasanna Karlekar,Jaideep Vinchurkar,Sachin Hingole,Suraj Sokasane,Jyoti Mayne

      Please let me know if you need any more information on this.

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WT-7614 Test data for Invoice and Billing Testing company

          • Critical - This problem will block progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-7614 [ WT-7614 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Severity Simple [ 13101 ] Medium [ 13102 ]
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 06/Jun/17 03:19 AM
            • Time Spent:
              1.5h
               
              <No comment>
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 07/Jun/17 03:25 AM
            • Time Spent:
              2.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Ankur Deshpande [ ankur.deshpande ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 12/Jun/2017
            Developer Suraj Sokasane [ suraj.sokasane ] Ankur Deshpande [ ankur.deshpande ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Remaining Estimate 30h [ 108000 ]
            Original Estimate 30h [ 108000 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 12/Jun/2017 13/Jun/2017
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 12/Jun/17 03:28 PM
            • Time Spent:
              7h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 30h [ 108000 ] 28.5h [ 102600 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 54230 [ 54230 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 28.5h [ 102600 ] 26h [ 93600 ]
            Time Spent 1.5h [ 5400 ] 4h [ 14400 ]
            Worklog Id 54232 [ 54232 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 26h [ 93600 ] 19h [ 68400 ]
            Time Spent 4h [ 14400 ] 11h [ 39600 ]
            Worklog Id 54242 [ 54242 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 13/Jun/17 09:29 AM
            • Time Spent:
              3h
               
              <No comment>
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 13/Jun/17 01:55 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 19h [ 68400 ] 18.5h [ 66600 ]
            Time Spent 11h [ 39600 ] 11.5h [ 41400 ]
            Worklog Id 54695 [ 54695 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 14/Jun/17 09:31 AM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 14/Jun/17 02:02 PM
            • Time Spent:
              3h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 18.5h [ 66600 ] 15.5h [ 55800 ]
            Time Spent 11.5h [ 41400 ] 14.5h [ 52200 ]
            Worklog Id 55100 [ 55100 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            This issues is because the way election import designed. Election import can set the termination date to enrollment as it is, but for setting termination date call is given to rate recalculation. Previously we used to delete entries from rate changes log in such cases. However, export team needs all such details for changes in rates, that's why instead of deleting the rate, we are making it dead.

            Another issues we found that while terminating enrollment through election import, enrollment also get dead and new enrollment with termination date gets inserted. This is because of WT-6041.
            we will consider this issue while working on WT-9056.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - This issues is because the way election import designed. Election import can set the termination date to enrollment as it is, but for setting termination date call is given to rate recalculation. Previously we used to delete entries from rate changes log in such cases. However, export team needs all such details for changes in rates, that's why instead of deleting the rate, we are making it dead. Another issues we found that while terminating enrollment through election import, enrollment also get dead and new enrollment with termination date gets inserted. This is because of WT-6041 . we will consider this issue while working on WT-9056 .
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 15/Jun/17 09:47 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Closing this ticket as we will need structural changes in election import. These changes are already in consideration in WT-9056

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Closing this ticket as we will need structural changes in election import. These changes are already in consideration in WT-9056
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Resolution System Behaviour [ 10100 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 15h [ 54000 ]
            Time Spent 14.5h [ 52200 ] 15h [ 54000 ]
            Worklog Id 55356 [ 55356 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 12h [ 43200 ]
            Time Spent 15h [ 54000 ] 18h [ 64800 ]
            Worklog Id 56239 [ 56239 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 4h [ 14400 ]
            Time Spent 18h [ 64800 ] 26h [ 93600 ]
            Worklog Id 56241 [ 56241 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Ankur Deshpande (Inactive) made transition -
            Open In Development
            		97d 16h 7m 1
            Jaideep Vinchurkar (Inactive) made transition -
            In Development Rejected
            		3d 2h 27m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Rejected Closed
            		22s 1

              People

              Assignee:
              ankur.deshpande Ankur Deshpande (Inactive)
              Reporter:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Developer:
              Ankur Deshpande (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 30h
                  30h
                  Remaining:
                  Time Spent - 26h Remaining Estimate - 4h
                  4h
                  Logged:
                  Time Spent - 26h Remaining Estimate - 4h
                  26h