WORKTERRAProject Type: software

WORKTERRA

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

BCC Invoice Management - Rate Matrix Changes scenarios not working as expected.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Hi surender kumar,

      I have verified the SelfInsured and Billed Rate trigger scenarios. Please find the attached sheet of the status of the scenarios tested. Light green color is for the scenarios which worked as per expectation and red color is for the scenarios which are not working as expected.

      Alankar Chavan,Prasanna Karlekar,Jyoti Agrawal

      Thanks,
      Venkatesh

        Attachments

          Issue Links

          blocks

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5026 BCC Invoice Management - Rate Matrix Changes

          • Medium - Has the potential to affect progress.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. WT-11542 County of Sutter - Invoice Issue

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

          Enhancement - An improvement or enhancement to an existing feature or task. WT-6331 BCC Invoice Management - Adjustments in future Invoice

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

            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 blocks WT-5026 [ WT-5026 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 19/Dec/16 09:18 AM - edited
            • Time Spent:
              3h
               
              • Analysis
              • Discussion
            surender.kumar surender kumar (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 2h [ 7200 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 14290 [ 14290 ]
            surender.kumar surender kumar (Inactive) made changes -
            Worklog Id 14290 [ 14290 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 26/Dec/16 01:59 PM - edited
            • Time Spent:
              8h
               
              • Analysis
              • Discussion
              • Modified Rates related Trigger
            surender.kumar surender kumar (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 3h [ 10800 ] 11h [ 39600 ]
            Worklog Id 15593 [ 15593 ]
            surender.kumar surender kumar (Inactive) made changes -
            Worklog Id 15593 [ 15593 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 27/Dec/16 01:12 PM
            • Time Spent:
              8h
               

              Modified Triggers related to

              • Rates
              • RatesMatrics
              • SelfInsuredRates
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 11h [ 39600 ] 19h [ 68400 ]
            Worklog Id 15777 [ 15777 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 28/Dec/16 01:01 PM
            • Time Spent:
              4h
               

              Test Different Test Cases

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 19h [ 68400 ] 23h [ 82800 ]
            Worklog Id 15986 [ 15986 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue relates to WT-6331 [ WT-6331 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Surender Kumar [ surender.kumar ] Venkatesh Pujari [ venkatesh.pujari ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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: In Testing(10210)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            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: Re-open(10212)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment Latest_Testing_Updated.xls [ 38150 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            I have tested the Billed Rate Triggers and observed that the system is failing for two scenarios. Please find the attached updated excel sheet for the issues still present.

            Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , I have tested the Billed Rate Triggers and observed that the system is failing for two scenarios. Please find the attached updated excel sheet for the issues still present. Prasanna Karlekar Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Surender Kumar [ surender.kumar ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 23h [ 82800 ] 24h [ 86400 ]
            Worklog Id 20869 [ 20869 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 25/Jan/17 06:40 PM
            • Time Spent:
              1h
               
              <No comment>
            surender.kumar surender kumar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Surender Kumar [ surender.kumar ] Venkatesh Pujari [ venkatesh.pujari ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Surender Kumar [ surender.kumar ]
            surender.kumar surender kumar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            surender.kumar surender kumar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Surender Kumar [ surender.kumar ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            Permalink
            surender.kumar surender kumar (Inactive) added a comment -

            Hi Venkatesh Pujari,

            I have made the changes in Triggers.
            Please verify.

            Regards,
            Surender Kumar

            Show
            surender.kumar surender kumar (Inactive) added a comment - Hi Venkatesh Pujari , I have made the changes in Triggers. Please verify. Regards, Surender Kumar
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            Tested this on LB on JE Dunn For Hspl company. Working fine as expected. Triggers working correctly for all scenarios now.

            Ready for Stage.

            Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , Tested this on LB on JE Dunn For Hspl company. Working fine as expected. Triggers working correctly for all scenarios now. Ready for Stage. Prasanna Karlekar Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 24h [ 86400 ] 24.5h [ 88200 ]
            Worklog Id 21520 [ 21520 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 30/Jan/17 05:56 PM
            • Time Spent:
              0.5h
               
              <No comment>
            rakeshr Rakesh Roy (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: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            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 -
            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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited

            Hi surender kumar,

            I have tested the Billed Rate Triggers and observed that the system is Working fine as expected. Triggers working correctly for all scenarios.

            Ready for Production

            Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited Hi surender kumar , I have tested the Billed Rate Triggers and observed that the system is Working fine as expected. Triggers working correctly for all scenarios. Ready for Production Prasanna Karlekar Thanks, Venkatesh
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 01/Feb/17 10:24 AM
            • Time Spent:
              1.5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 24.5h [ 88200 ] 26h [ 93600 ]
            Worklog Id 22278 [ 22278 ]
            ashwin.wankhede Ashwin Wankhede (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: Production Deployed(10221)
            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: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 02/Feb/17 11:53 AM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            I have tested the Billed Rate Triggers and observed that the system is Working fine as expected. Triggers working correctly for all scenarios.

            Prasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , I have tested the Billed Rate Triggers and observed that the system is Working fine as expected. Triggers working correctly for all scenarios. Prasanna Karlekar Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 26h [ 93600 ] 27h [ 97200 ]
            Worklog Id 22627 [ 22627 ]
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Few code check-in are missing on Stage and Production

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Few code check-in are missing on Stage and Production
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Closed [ 6 ] Reopen in Production [ 10027 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Sep/17 11:13 AM
            • Time Spent:
              3h
               

              Testing on Stage

            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Verified the Billing Trigger scenarios and observed that proper entries are being inserted and updated in BilledRateChanges_log and SelfInsuredRateChanges_Log tables respectively. This is good to be deployed on Production

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Verified the Billing Trigger scenarios and observed that proper entries are being inserted and updated in BilledRateChanges_log and SelfInsuredRateChanges_Log tables respectively. This is good to be deployed on Production Thanks, Venkatesh
            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: 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 27h [ 97200 ] 30h [ 108000 ]
            Worklog Id 79227 [ 79227 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 18/Sep/17 10:30 PM
            • Time Spent:
              1h
               

              Code check in Stage branch
              Discussion and email communication to check in code for WT-11007

            khandu.kshirsagar Khandu Kshirsagar (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: Production Deployed(10221)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 19/Sep/17 10:23 AM
            • Time Spent:
              3h
               

              Testing on Production

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 30h [ 108000 ] 33h [ 118800 ]
            Worklog Id 79668 [ 79668 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Sep/17 04:45 PM
            • Time Spent:
              0.5h
               

              Code check in - Production branch

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 33h [ 118800 ] 34h [ 122400 ]
            Worklog Id 81308 [ 81308 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 34h [ 122400 ] 34.5h [ 124200 ]
            Worklog Id 81309 [ 81309 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is duplicated by WT-11542 [ WT-11542 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            		26d 33m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Reopen in Local
            		11h 25m 1
            surender kumar (Inactive) made transition -
            Reopen in Local In Development
            		4d 23h 5m 1
            Jyoti Agrawal (Inactive) made transition -
            Closed Reopen in Production
            		220d 18h 15m 1
            Prasanna Karlekar (Inactive) made transition -
            Reopen in Production In Development
            		6m 26s 1
            Prasanna Karlekar (Inactive) made transition -
            In Development In LB Testing
            		13d 9h 21m 3
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            		9d 8h 19m 2
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		1d 22h 37m 2
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		2h 12m 2
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		7s 2

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 34.5h
                  34.5h