WORKTERRAProject Type: software

WORKTERRA

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

ACA 2017 1095C Remove employees from ACAEmployeeFilter table if not under employee table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete
    • Issue Importance:
      Must Have

      Description

      Delete employees from 1095C ACAEmployeeFilter table, if present in ACA_IRSSubmissionAckErrorData or ACA_1095CCorrectionData but deleted from Employee main table.
      This issue occurred on certain companies which caused server error while furnishing the 1095-C reports.

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          kumar.chhajed Kumar Chhajed (Inactive) created issue -
          Hide
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          FYI Nandkumar Prabhakar Karlekar Ramya Tantry Revansiddha Gaur Smita Pawar

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - FYI Nandkumar Prabhakar Karlekar Ramya Tantry Revansiddha Gaur Smita Pawar
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Development [ 10007 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Reviewed By Ramya Tantry [ 13001 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Review Date 30/Mar/2017
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Development(10200)Level 1 values: In Analysis(10204)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
          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)
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 30/Mar/17 12:41 PM
          • Time Spent:
            0.5h
             

            discussion with Kumar and sachin

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 24h [ 86400 ] 23.5h [ 84600 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 34844 [ 34844 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 30/Mar/17 01:57 PM - edited
          • Time Spent:
            2h
             

            Changes in scripts
            Production and LB Check-ins

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 23.5h [ 84600 ] 22.5h [ 81000 ]
          Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
          Worklog Id 34962 [ 34962 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 22.5h [ 81000 ] 21.5h [ 77400 ]
          Time Spent 1.5h [ 5400 ] 2.5h [ 9000 ]
          Worklog Id 34962 [ 34962 ]
          Hide
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Hi Smita Pawar,

          Please move this JIRA to stage and production as early as possible

          Thanks,
          Kumar

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Smita Pawar , Please move this JIRA to stage and production as early as possible Thanks, Kumar
          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)
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Apr/17 01:18 PM
          • Time Spent:
            0.5h
             

            Discussion with smita

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 21.5h [ 77400 ] 21h [ 75600 ]
          Time Spent 2.5h [ 9000 ] 3h [ 10800 ]
          Worklog Id 38768 [ 38768 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We could not test issue due to LB build issues on 17,18 April 2017

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We could not test issue due to LB build issues on 17,18 April 2017
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 18/Apr/17 11:05 AM
          • Time Spent:
            2h
             

            Internal discussion
            LB testing
            Customization
            Report creation

          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on LB Company [ACA Automation].

          There is no server error after furnishing 1095-C report.
          Tested scenarios are as follows
          1.Done correction of employee, deleted employee and furnish 1095-C report
          2.Uploaded Acknowledgement file, deleted employee and furnish 1095-C report.

          Fix is ready for stage.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB Company [ACA Automation] . There is no server error after furnishing 1095-C report. Tested scenarios are as follows 1.Done correction of employee, deleted employee and furnish 1095-C report 2.Uploaded Acknowledgement file, deleted employee and furnish 1095-C report. Fix is ready for stage.
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 21h [ 75600 ] 19h [ 68400 ]
          Time Spent 3h [ 10800 ] 5h [ 18000 ]
          Worklog Id 38941 [ 38941 ]
          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: Ready for Stage(10213)
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 27/Apr/17 10:47 AM
          • Time Spent:
            0.25h
             

            Deployment discussion

          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 19h [ 68400 ] 18.75h [ 67500 ]
          Time Spent 5h [ 18000 ] 5.25h [ 18900 ]
          Worklog Id 42170 [ 42170 ]
          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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          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)
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Stage Company [ACA Automation]
          Now no server error received after clicking on SAVE & PREVIEW.
          Its working fine.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage Company [ACA Automation] Now no server error received after clicking on SAVE & PREVIEW. Its working fine.
          smita.pawar Smita Pawar (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
          smita.pawar Smita Pawar (Inactive) added a comment -

          This patch is already deployed on Production

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - This patch is already deployed on Production
          smita.pawar Smita Pawar (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)
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Production.
          Its working fine.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production. Its working fine.
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Bug Severity Medium [ 16702 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Kumar Chhajed (Inactive) made transition -
          Open In Development
          		23h 57m 1
          Kumar Chhajed (Inactive) made transition -
          In Development In LB Testing
          		2s 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		46d 19h 39m 1
          Smita Pawar (Inactive) made transition -
          Stage Testing In Production Testing
          		6d 5h 16m 1
          Smita Pawar (Inactive) made transition -
          In Production Testing Production Complete
          		10s 1
          Smita Pawar (Inactive) made transition -
          Production Complete Closed
          		3s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            kumar.chhajed Kumar Chhajed (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Time Spent - 5.25h Remaining Estimate - 18.75h
                18.75h
                Logged:
                Time Spent - 5.25h Remaining Estimate - 18.75h
                5.25h