WORKTERRAProject Type: software

WORKTERRA

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

ACA 2017 Need to remove hardcoded software id's from code and SP.

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Good To Have
    • Severity:
      Simple

      Description

      Need to remove hardcoded software id's from code and SP.
      Add History Table for ACA Parameters

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-10896 Salary type did not get updated in ACASalary_History table as per change on UI.

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

            Activity

            Ascending order - Click to sort in descending order
            kumar.chhajed Kumar Chhajed (Inactive) created issue -
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Field Original Value New Value
            Description Need to remove hardcoded software id's from code and SP.
            		 Need to remove hardcoded software id's from code and SP.
            Add History Table for ACA Parameters
            Dump Software ID and TCC into ACA_IRSSubmissionHistory Table
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Umesh Kolhe [ umesh.kolhe ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ]
            Original Estimate 12h [ 43200 ]
            Permalink
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 06/Jul/17 01:25 PM
            • Time Spent:
              8h
               
              • Create table ACASalary_History
              • CREATE TRIGGER trgInsACASalary_History
              • CREATE TRIGGER trgUpdACASalary_History
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 4h [ 14400 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 61233 [ 61233 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 06/Jul/17 02:10 PM
            • Time Spent:
              1h
               

              Discussion with Umesh

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3h [ 10800 ]
            Time Spent 8h [ 28800 ] 9h [ 32400 ]
            Worklog Id 61340 [ 61340 ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            ashwin.wankhede Ashwin Wankhede (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)
            Hide
            Permalink
            umesh.kolhe Umesh Kolhe (Inactive) added a comment -

            Hi Smita Pawar,

            Created ACASalary_History table for the dump the data while performing Insert and update operation.

            Thanks & regards,
            Umesh Kolhe

            CC Kumar Chhajed,Nandkumar Prabhakar Karlekar

            Show
            umesh.kolhe Umesh Kolhe (Inactive) added a comment - Hi Smita Pawar , Created ACASalary_History table for the dump the data while performing Insert and update operation. Thanks & regards, Umesh Kolhe CC Kumar Chhajed , Nandkumar Prabhakar Karlekar
            umesh.kolhe Umesh Kolhe (Inactive) made changes -
            Assignee Umesh Kolhe [ umesh.kolhe ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (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)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Description Need to remove hardcoded software id's from code and SP.
            Add History Table for ACA Parameters
            Dump Software ID and TCC into ACA_IRSSubmissionHistory Table
            		 Need to remove hardcoded software id's from code and SP.
            Add History Table for ACA Parameters
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            As discussed with Dev Team, we havn't removed Softeware Ids from code & SP.
            We are keeping them as it is. We will just save ACA Parameters details on master company on Stage & Production

            This patch is only deployed on Azure environment. Current Azure data base is not getting connecting.
            We are testing same on Code map

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - As discussed with Dev Team, we havn't removed Softeware Ids from code & SP. We are keeping them as it is. We will just save ACA Parameters details on master company on Stage & Production This patch is only deployed on Azure environment. Current Azure data base is not getting connecting. We are testing same on Code map
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 18/Jul/17 02:16 PM
            • Time Spent:
              2h
               

              LB testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 1h [ 3600 ]
            Time Spent 9h [ 32400 ] 11h [ 39600 ]
            Worklog Id 64380 [ 64380 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Azure [Caiso for Hspl].
            Its working fine.
            Tested scenarios are as follows.
            1.Save
            2.Update data
            3.Checked whether it is getting inserted in ACASalary_History table.

            We will move this next level with UI refresh build.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Azure [Caiso for Hspl] . Its working fine. Tested scenarios are as follows. 1.Save 2.Update data 3.Checked whether it is getting inserted in ACASalary_History table. We will move this next level with UI refresh build.
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 19/Jul/17 01:03 PM
            • Time Spent:
              0.5h
               

              Discussion with QA

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 11h [ 39600 ] 11.5h [ 41400 ]
            Worklog Id 64731 [ 64731 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 22/Aug/2017
            Stage Due Date 14/Aug/17 [ 2017-08-14 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment WT-9201.xls [ 58462 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 11/Aug/17 01:22 PM
            • Time Spent:
              1h
               

              Test cases & testing

            smita.pawar Smita Pawar (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: On Hold(10211)
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 11.5h [ 41400 ] 12.5h [ 45000 ]
            Worklog Id 71268 [ 71268 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Assigning back to DEV for enhancement which needs to be done for LB.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Assigning back to DEV for enhancement which needs to be done for LB.
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Kumar Chhajed [ kumar.chhajed ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) added a comment -

            Hi Smita Pawar,
            .
            This JIRA is deployed to LB (Old UI)

            Show
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Smita Pawar , . This JIRA is deployed to LB (Old UI)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Aug/17 02:37 PM - edited
            • Time Spent:
              2h
               

              Unit testing
              Code Checks-ins

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 13.5h [ 48600 ]
            Worklog Id 73901 [ 73901 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 14.5h [ 52200 ]
            Worklog Id 73901 [ 73901 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 23/Aug/17 04:38 PM
            • Time Spent:
              1h
               

              Testing

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 15.5h [ 55800 ]
            Worklog Id 74297 [ 74297 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 30/Aug/17 01:56 PM
            • Time Spent:
              0.5h
               

              Analysis

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 16h [ 57600 ]
            Worklog Id 75344 [ 75344 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 30/Aug/17 04:28 PM
            • Time Spent:
              0.5h
               

              Testing

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 16h [ 57600 ] 16.5h [ 59400 ]
            Worklog Id 75394 [ 75394 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Link This issue causes WT-10896 [ WT-10896 ]
            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Verified this enhancement on LB.

            Tested scenarios are as follows.
            1.Save
            2.Update data
            3.Checked whether it is getting inserted in ACASalary_History table.

            Company - For QA ASML

            Its working as expected. Hence , Marking as ready for stage.

            Thanks,
            Yogita

            Mandar Kulkarni Smita Pawar Prajakta Belhe Kumar Chhajed

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Verified this enhancement on LB. Tested scenarios are as follows. 1.Save 2.Update data 3.Checked whether it is getting inserted in ACASalary_History table. Company - For QA ASML Its working as expected. Hence , Marking as ready for stage. Thanks, Yogita Mandar Kulkarni Smita Pawar Prajakta Belhe Kumar Chhajed
            yogita.bhadane Yogita Bhadane (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)
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 04/Sep/17 01:44 PM
            • Time Spent:
              0.5h
               

              Code Check-ins

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 17h [ 61200 ]
            Worklog Id 76731 [ 76731 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 04/Sep/17 04:27 PM
            • Time Spent:
              0.5h
               

              Testing

            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)
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 17h [ 61200 ] 17.5h [ 63000 ]
            Worklog Id 77193 [ 77193 ]
            smita.pawar Smita Pawar (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Yogita Bhadane [ yogita.bhadane ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 22/Aug/2017 21/Sep/2017
            smita.pawar Smita Pawar (Inactive) made changes -
            Stage Due Date 14/Aug/17 [ 2017-08-14 ] 20/Sep/17 [ 2017-09-20 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            As discussed with kumar this enhancement is not deployed on stage hence changing status to ready for stage.
            Will start test after this will get deploy to stage.

            Thanks,
            Yogita

            Mandar KulkarniPrajakta BelheRakesh RoySmita PawarKumar Chhajed

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - As discussed with kumar this enhancement is not deployed on stage hence changing status to ready for stage. Will start test after this will get deploy to stage. Thanks, Yogita Mandar Kulkarni Prajakta Belhe Rakesh Roy Smita Pawar Kumar Chhajed
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 18/Sep/17 01:53 PM
            • Time Spent:
              0.5h
               

              Internal discussion with QA
              Analysis

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 18h [ 64800 ]
            Worklog Id 79343 [ 79343 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 18/Sep/17 04:30 PM
            • Time Spent:
              0.5h
               

              Testing and discussion.

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 18h [ 64800 ] 18.5h [ 66600 ]
            Worklog Id 79377 [ 79377 ]
            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)
            yogita.bhadane Yogita Bhadane (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)
            yogita.bhadane Yogita Bhadane (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)
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 22/Sep/17 07:02 AM
            • Time Spent:
              1h
               

              Testing on stage.

            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Verified this enhancement on Stage.

            Tested scenarios are as follows.
            1.Save
            2.Update data
            3.Checked whether it is getting inserted in ACASalary_History table.
            Company - University health for HSPL
            Its working as expected. Hence , Marking as ready for production.

            Thanks,
            Yogita

            CC - Mandar Kulkarni Prajakta Belhe Smita Pawar

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Verified this enhancement on Stage. Tested scenarios are as follows. 1.Save 2.Update data 3.Checked whether it is getting inserted in ACASalary_History table. Company - University health for HSPL Its working as expected. Hence , Marking as ready for production. Thanks, Yogita CC - Mandar Kulkarni Prajakta Belhe Smita Pawar
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 18.5h [ 66600 ] 19.5h [ 70200 ]
            Worklog Id 80416 [ 80416 ]
            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)
            yogita.bhadane Yogita Bhadane (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)
            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Verified this enhancement on production.

            Tested scenarios are as follows.
            1.Save
            2.Update data
            3.Checked whether it is getting inserted in ACASalary_History table.

            Company - Wacker Neuson Corporation For HSPL

            Its working as expected. Hence , Marking as production complete.

            Thanks,
            Yogita

            CC - Mandar KulkarniSmita PawarPrajakta Belhe

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Verified this enhancement on production. Tested scenarios are as follows. 1.Save 2.Update data 3.Checked whether it is getting inserted in ACASalary_History table. Company - Wacker Neuson Corporation For HSPL Its working as expected. Hence , Marking as production complete. Thanks, Yogita CC - Mandar Kulkarni Smita Pawar Prajakta Belhe
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 26/Sep/17 11:23 AM
            • Time Spent:
              1.5h
               

              Testing.

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 21h [ 75600 ]
            Worklog Id 81430 [ 81430 ]
            kumar.chhajed Kumar Chhajed (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)
            Transition Time In Source Status Execution Times
            Umesh Kolhe (Inactive) made transition -
            New Request Pending for Approval
            		83d 2h 38m 1
            Umesh Kolhe (Inactive) made transition -
            Pending for Approval Approved for Development
            		5s 1
            Umesh Kolhe (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Umesh Kolhe (Inactive) made transition -
            In Development In LB Testing
            		3d 21h 9m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		66d 7h 11m 1
            Sachin Hingole (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		7s 1
            Sachin Hingole (Inactive) made transition -
            Approved for Stage Stage Testing
            		5s 1
            Yogita Bhadane (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		11d 22h 22m 1
            Yogita Bhadane (Inactive) made transition -
            Pending for Production Approval Approved for production
            		3s 1
            Yogita Bhadane (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Yogita Bhadane (Inactive) made transition -
            In Production Testing Production Complete
            		8s 1
            Yogita Bhadane (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              yogita.bhadane Yogita Bhadane (Inactive)
              Reporter:
              kumar.chhajed Kumar Chhajed (Inactive)
              Developer:
              Kumar Chhajed (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 21h
                  21h