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

Change in XSLT for Truncate last, address and city (Form Type B & C,Manifest)

    Details

    • Type: Change Request
    • Status: Resolution Setting
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Severity:
      Simple

      Attachments

        Activity

        nandkumar Nandkumar Prabhakar Karlekar (Inactive) created issue -
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Mar/17 06:00 AM
        • Time Spent:
          1h
           
          <No comment>
        Hide
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

        Change requested from this JIRA.
        WT-8236 ACA 2017 eSubmission - Elite Staffing

        ACA e-submission need to truncate the First name last name and address in XML file as per the Regulation.This year they have strengthen the validations so instated for failing one employee complete file is getting rejected.

        Show
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Change requested from this JIRA. WT-8236 ACA 2017 eSubmission - Elite Staffing ACA e-submission need to truncate the First name last name and address in XML file as per the Regulation.This year they have strengthen the validations so instated for failing one employee complete file is getting rejected.
        nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
        Field Original Value New Value
        Remaining Estimate 9h [ 32400 ] 8h [ 28800 ]
        Time Spent 1h [ 3600 ]
        Worklog Id 30743 [ 30743 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status New Request [ 10029 ] Pending for Approval [ 10002 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Status Approved for Development [ 10003 ] In Development [ 10007 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Summary Cahange in XSLT for Truncate last, address and city Change in XSLT for Truncate last, address and city (Form Type B & C,Manifest)
        Hide
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

        Affected Files :

        \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\Common.xslt
        \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\FileData_UpstreamMessage_109495_B.xslt
        \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\FileData_UpstreamMessage_109495_C.xslt

        Show
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Affected Files : \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\Common.xslt \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\FileData_UpstreamMessage_109495_B.xslt \App\BusinessLogic\InvoiceManagement\AIRSubmissionXSLT\FileData_UpstreamMessage_109495_C.xslt
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Dev Due Date 14/Mar/2017 15/Mar/2017
        Dev Estimates 2
        Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Mar/17 09:00 PM
        • Time Spent:
          2.5h
           

          Changes,check ins -trunk & lb.

        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 8h [ 28800 ] 5.5h [ 19800 ]
        Time Spent 1h [ 3600 ] 3.5h [ 12600 ]
        Worklog Id 31084 [ 31084 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
        khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
        smita.pawar Smita Pawar (Inactive) made changes -
        Status In Development [ 10007 ] Local Testing [ 10200 ]
        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)
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        We have verified above mentioned change request on LB [ACA Automation] company.
        Its working fine.

        Tested scenarios are as follows.

        For 1094/95 B & C forms

        1.Checked whether First name of employee is getting truncated.
        2.Checked whether Last name of employee is getting truncated.
        3.Checked whether Middle name of employee is getting truncated.
        4.Checked whether Address of employee is getting truncated or not
        5.Checked whether City of the employee is getting truncated or not.

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned change request on LB [ACA Automation] company. Its working fine. Tested scenarios are as follows. For 1094/95 B & C forms 1.Checked whether First name of employee is getting truncated. 2.Checked whether Last name of employee is getting truncated. 3.Checked whether Middle name of employee is getting truncated. 4.Checked whether Address of employee is getting truncated or not 5.Checked whether City of the employee is getting truncated or not.
        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)
        smita.pawar Smita Pawar (Inactive) logged work - 16/Mar/17 01:37 PM - edited
        • Time Spent:
          3h
           

          1.Analysis
          2.LB testing

        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)
        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)
        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)
        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)
        smita.pawar Smita Pawar (Inactive) made changes -
        Remaining Estimate 5.5h [ 19800 ] 2.5h [ 9000 ]
        Time Spent 3.5h [ 12600 ] 6.5h [ 23400 ]
        Worklog Id 33298 [ 33298 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Worklog Id 33298 [ 33298 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Approved for Stage [ 10030 ] 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)
        smita.pawar Smita Pawar (Inactive) logged work - 27/Apr/17 10:48 AM
        • Time Spent:
          0.5h
           

          Stage testing

        kumar.chhajed Kumar Chhajed (Inactive) logged work - 27/Apr/17 01:51 PM
        • Time Spent:
          0.5h
           

          Discussion With QA

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 2.5h [ 9000 ] 2h [ 7200 ]
        Time Spent 6.5h [ 23400 ] 7h [ 25200 ]
        Worklog Id 41482 [ 41482 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Remaining Estimate 2h [ 7200 ] 1.5h [ 5400 ]
        Time Spent 7h [ 25200 ] 7.5h [ 27000 ]
        Worklog Id 42172 [ 42172 ]
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 11/May/17 09:00 AM
        • Time Spent:
          0.5h
           

          Discussion regarding deployment.

        smita.pawar Smita Pawar (Inactive) made changes -
        Attachment Manifest_1094_C_Request_BB2D9_20170427T53451785Z.xml [ 47732 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Attachment Manifest_1094_C_Request_BB2D9_20170427T53451785Z.xml [ 47732 ]
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        We have verified above mentioned issue on Stage.
        But issue is getting reproduced
        PFA file for additional information.

        Company: ACA Automation
        IRS submission: IRS submission two six one seven
        Run date: 4/27/2017 5:34:52 AM

        Please check whether it is deployment issue or not.

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage. But issue is getting reproduced PFA file for additional information. Company: ACA Automation IRS submission: IRS submission two six one seven Run date: 4/27/2017 5:34:52 AM Please check whether it is deployment issue or not.
        smita.pawar Smita Pawar (Inactive) made changes -
        Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
        Hide
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

        You can check now. Now files are deployed by Khandu Kshirsagar which were missed by them.

        Show
        revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - You can check now. Now files are deployed by Khandu Kshirsagar which were missed by them.
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 1.5h [ 5400 ] 1h [ 3600 ]
        Time Spent 7.5h [ 27000 ] 8h [ 28800 ]
        Worklog Id 44814 [ 44814 ]
        Hide
        khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment -

        Hi Revansiddha Gaur,

        Files were missed because these files were checked-in in App project, we are removing all files as its creating dll for projects,These are explicit files which needs to be deployed manually.
        Please let us know whenever such files needs to be manually deployed.

        Ashwin Wankhede,Satya

        Show
        khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment - Hi Revansiddha Gaur , Files were missed because these files were checked-in in App project, we are removing all files as its creating dll for projects,These are explicit files which needs to be deployed manually. Please let us know whenever such files needs to be manually deployed. Ashwin Wankhede , Satya
        smita.pawar Smita Pawar (Inactive) logged work - 11/May/17 02:27 PM
        • Time Spent:
          0.5h
           

          Stage testing

        smita.pawar Smita Pawar (Inactive) made changes -
        Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
        Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
        Worklog Id 44870 [ 44870 ]
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        We have verified above mentioned issue on Stage [ACA Automation] company.
        PFA screen shot.

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [ACA Automation] company. PFA screen shot.
        smita.pawar Smita Pawar (Inactive) made changes -
        Attachment IRS submission.png [ 48233 ]
        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)
        revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
        Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
        Time Spent 8.5h [ 30600 ] 9h [ 32400 ]
        Worklog Id 52405 [ 52405 ]
        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)
        revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Jun/17 09:00 PM
        • Time Spent:
          0.5h
           

          Production checkins.

        rakeshr Rakesh Roy (Inactive) made changes -
        Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
        rakeshr Rakesh Roy (Inactive) made changes -
        Status Approved for production [ 10034 ] Production Testing [ 10202 ]
        ashwin.wankhede Ashwin Wankhede (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)
        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)
        smita.pawar Smita Pawar (Inactive) made changes -
        Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
        smita.pawar Smita Pawar (Inactive) made changes -
        Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        Valid Xml file got generated even though employee first , middle name, last name, address name are exceeding the limits,
        Test employee used ALANA SHEPHARD from PMC for Hspl.

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - Valid Xml file got generated even though employee first , middle name, last name, address name are exceeding the limits, Test employee used ALANA SHEPHARD from PMC for Hspl.
        smita.pawar Smita Pawar (Inactive) logged work - 14/Jun/17 12:31 PM
        • Time Spent:
          1h
           
          <No comment>
        smita.pawar Smita Pawar (Inactive) made changes -
        Attachment Xml.png [ 52045 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Time Spent 9h [ 32400 ] 10h [ 36000 ]
        Worklog Id 54998 [ 54998 ]
        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)Level 1 values: Closed(10223)
        smita.pawar Smita Pawar (Inactive) made changes -
        Resolution Fixed [ 1 ]
        Status Production Testing [ 10202 ] Production Complete [ 10028 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Attachment WT-8850.xls [ 56929 ]
        smita.pawar Smita Pawar (Inactive) logged work - 27/Jul/17 09:08 AM
        • Time Spent:
          1h
           

          Jira updates & Test case

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

        Test cases has been attached in excel doc. WT-8850

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - Test cases has been attached in excel doc. WT-8850
        smita.pawar Smita Pawar (Inactive) made changes -
        Time Spent 10h [ 36000 ] 11h [ 39600 ]
        Worklog Id 66903 [ 66903 ]
        smita.pawar Smita Pawar (Inactive) logged work - 26/Feb/18 01:10 PM
        • Time Spent:
          3h
           

          Re testing on Production
          Draft
          Email communication

        smita.pawar Smita Pawar (Inactive) made changes -
        Time Spent 11h [ 39600 ] 14h [ 50400 ]
        Worklog Id 106300 [ 106300 ]
        smita.pawar Smita Pawar (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status Production Complete [ 10028 ] Closed [ 6 ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Assignee Smita Pawar [ smita.pawar ] Sachin Hingole [ sachin.hingole ]
        sachin.hingole Sachin Hingole (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status Closed [ 6 ] Resolution Setting [ 11616 ]
        Transition Time In Source Status Execution Times
        Revansiddha Gaur (Inactive) made transition -
        New Request Pending for Approval
        47m 20s 1
        Revansiddha Gaur (Inactive) made transition -
        Pending for Approval Approved for Development
        3s 1
        Revansiddha Gaur (Inactive) made transition -
        Approved for Development In Development
        2s 1
        Smita Pawar (Inactive) made transition -
        In Development In LB Testing
        1d 23h 38m 1
        Rakesh Roy (Inactive) made transition -
        In LB Testing Pending for Stage Approval
        29d 22h 18m 1
        Rakesh Roy (Inactive) made transition -
        Pending for Stage Approval Approved for Stage
        4s 1
        Rakesh Roy (Inactive) made transition -
        Approved for Stage Stage Testing
        4s 1
        Rakesh Roy (Inactive) made transition -
        Stage Testing Pending for Production Approval
        55d 6h 1m 1
        Rakesh Roy (Inactive) made transition -
        Pending for Production Approval Approved for production
        3s 1
        Rakesh Roy (Inactive) made transition -
        Approved for production In Production Testing
        3s 1
        Smita Pawar (Inactive) made transition -
        In Production Testing Production Complete
        5d 1h 59m 1
        Smita Pawar (Inactive) made transition -
        Production Complete Closed
        257d 1h 38m 1
        Sachin Hingole (Inactive) made transition -
        Closed Resolution Setting
        58d 13h 4m 1

          People

          Assignee:
          sachin.hingole Sachin Hingole (Inactive)
          Reporter:
          nandkumar Nandkumar Prabhakar Karlekar (Inactive)
          Account Executive:
          Jennifer Leugers
          Developer:
          Revansiddha Gaur (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          4 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Dev Due Date:
            Pre-Prod Due Date:
            Production Due Date:
            Code Review Date:

              Time Tracking

              Estimated:
              Original Estimate - 9h Original Estimate - 9h
              9h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 14h
              14h