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

Billing - Need to avoid double insertion in Billing when record is moved by effective date service

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Stage Deployed
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Due to Invoice Management we are tracking future rate changes in Billing Table.
      After the election is moved from Intermediate to main table, currently the Enrollment and RateChanges_LogID are not getting updated.

        Attachments

          Issue Links

            Activity

            surender.kumar surender kumar (Inactive) created issue -
            surender.kumar surender kumar (Inactive) made changes -
            Field Original Value New Value
            Remaining Estimate 0h [ 0 ]
            Time Spent 7h [ 25200 ]
            Worklog Id 22413 [ 22413 ]
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 7h [ 25200 ] 10.5h [ 37800 ]
            Worklog Id 22736 [ 22736 ]
            surender.kumar surender kumar (Inactive) made changes -
            Environment Production [ 10005 ]
            Issue Type Change Request [ 10002 ] Bug [ 1 ]
            Status New Request [ 10029 ] Open [ 1 ]
            Workflow WT_Features [ 31722 ] WT_Defects [ 32310 ]
            surender.kumar surender kumar (Inactive) made changes -
            Summary Changes in effective date service for billing table Rate and Enrollment ID not getting updated when record is moved by Effective date service
            surender.kumar surender kumar (Inactive) made changes -
            Description Due to Invoice Management we are tracking future rate changes in Billing Table.
            After the election is moved from Intermediate to main table, currently the Enrollment and RateChanges_LogID are not getting updated.
            surender.kumar surender kumar (Inactive) made changes -
            Summary Rate and Enrollment ID not getting updated when record is moved by Effective date service Billing - Rate and Enrollment ID not getting updated when record is moved by Effective date service
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] surender kumar [ surender.kumar ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Summary Billing - Rate and Enrollment ID not getting updated when record is moved by Effective date service Billing - Need to avoid double insertion in Billing when record is moved by effective date service
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 12h [ 43200 ]
            Worklog Id 24277 [ 24277 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Time Spent 12h [ 43200 ] 12.5h [ 45000 ]
            Worklog Id 24317 [ 24317 ]
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 14h [ 50400 ]
            Worklog Id 24392 [ 24392 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 14h [ 50400 ] 14.5h [ 52200 ]
            Worklog Id 24461 [ 24461 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 15h [ 54000 ]
            Worklog Id 25116 [ 25116 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 15h [ 54000 ] 17h [ 61200 ]
            Worklog Id 26273 [ 26273 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Severity Complex [ 13103 ]
            Original Estimate 0h [ 0 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 31/May/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 17h [ 61200 ] 19.25h [ 69300 ]
            Worklog Id 50467 [ 50467 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19.25h [ 69300 ] 19.75h [ 71100 ]
            Worklog Id 51138 [ 51138 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Due Date 06/Jun/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 31/May/2017 07/Jun/2017
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 07/Jun/2017 09/Jun/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 09/Jun/2017 14/Jun/2017
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 19.75h [ 71100 ] 27.75h [ 99900 ]
            Worklog Id 54176 [ 54176 ]
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 27.75h [ 99900 ] 31.75h [ 114300 ]
            Worklog Id 54692 [ 54692 ]
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 31.75h [ 114300 ] 34.75h [ 125100 ]
            Worklog Id 55088 [ 55088 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-8417 [ WT-8417 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 34.75h [ 125100 ] 35.25h [ 126900 ]
            Worklog Id 55310 [ 55310 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 35.25h [ 126900 ] 36.75h [ 132300 ]
            Worklog Id 55322 [ 55322 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 36.75h [ 132300 ] 37.25h [ 134100 ]
            Worklog Id 55341 [ 55341 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Sachin Hingole [ sachin.hingole ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 37.25h [ 134100 ] 39.25h [ 141300 ]
            Worklog Id 55558 [ 55558 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 39.25h [ 141300 ] 43.25h [ 155700 ]
            Worklog Id 56533 [ 56533 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 43.25h [ 155700 ] 44.5h [ 160200 ]
            Worklog Id 56606 [ 56606 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 44.5h [ 160200 ] 46h [ 165600 ]
            Worklog Id 56628 [ 56628 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 46h [ 165600 ] 50h [ 180000 ]
            Worklog Id 56771 [ 56771 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 50h [ 180000 ] 50.25h [ 180900 ]
            Worklog Id 56836 [ 56836 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 50.25h [ 180900 ] 52.25h [ 188100 ]
            Worklog Id 56919 [ 56919 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer surender kumar [ surender.kumar ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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: Ready for Stage(10213)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 52.25h [ 188100 ] 54.25h [ 195300 ]
            Worklog Id 62328 [ 62328 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 54.25h [ 195300 ] 58.25h [ 209700 ]
            Worklog Id 62626 [ 62626 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 58.25h [ 209700 ] 59.25h [ 213300 ]
            Worklog Id 64145 [ 64145 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 59.25h [ 213300 ] 60.75h [ 218700 ]
            Worklog Id 64297 [ 64297 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 60.75h [ 218700 ] 63.25h [ 227700 ]
            Worklog Id 65898 [ 65898 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Link This issue relates to EDI-2229 [ EDI-2229 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue causes WT-12048 [ WT-12048 ]

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              surender.kumar surender kumar (Inactive)
              Developer:
              surender kumar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 63.25h
                  63.25h