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

ACA_Worxtime Feed_All dependents are not reflected on file.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      ACA - Reports
    • Reported by:
      Client
    • Company:
      MRTX
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      1.Login to LB.
      2.Edit company say 'Caiso for Hspl'.
      3.Create a template as specs given for Worxtime.
      4.Export template.
      5.Check sample employee data e.g. Robert B Russell

      Actual: Data of all dependents is not reflected file.
      Expected: Data of all dependent should reflect on file.

        Attachments

          Issue Links

            Activity

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 18/Nov/17 07:24 AM - edited
            • Time Spent:
              1h
               

              sloution discussion for the Eligibility repeated data

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 22/Nov/17 01:12 AM
            • Time Spent:
              1.5h
               

              Analysis of issue reported for MRXT

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 23/Nov/17 01:13 AM
            • Time Spent:
              8h
               

              Analysis of this issue , found error in minimum cost implementation.
              Started working to resolve this issue

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Nandkumar Prabhakar Karlekar [ satyap ] Yogesh Chaudhari [ yogesh.chaudhari ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-11873 [ WT-11873 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            Remaining Estimate 50h [ 180000 ]
            Original Estimate 50h [ 180000 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 50h [ 180000 ] 48.5h [ 174600 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 92749 [ 92749 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 48.5h [ 174600 ] 40.5h [ 145800 ]
            Time Spent 1.5h [ 5400 ] 9.5h [ 34200 ]
            Worklog Id 92750 [ 92750 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 40.5h [ 145800 ] 38.5h [ 138600 ]
            Time Spent 9.5h [ 34200 ] 11.5h [ 41400 ]
            Worklog Id 92756 [ 92756 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 25/Nov/17 01:19 AM
            • Time Spent:
              2h
               

              Worked on this issue by enrollment table check.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 38.5h [ 138600 ] 37.5h [ 135000 ]
            Time Spent 11.5h [ 41400 ] 12.5h [ 45000 ]
            Worklog Id 92930 [ 92930 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 28/Nov/17 06:07 AM
            • Time Spent:
              6h
               

              Analysis,discussion and unit testing of this issue on local machine.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Worklog Id 92930 [ 92930 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 37.5h [ 135000 ] 31.5h [ 113400 ]
            Time Spent 12.5h [ 45000 ] 18.5h [ 66600 ]
            Worklog Id 94186 [ 94186 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Reported by Harbinger [ 10700 ] Client [ 10352 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Account Executive Amber Love-Jones [ alov ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            3C's :

            Concern : Here the basic issue is, if we export file records gets duplicated on file.

            Cause : While exporting ACA template, If employee has multiple enrollments during the exporting tenure i.e. From and To Date and ACA Minimum cost field is mapped in template then records gets populated multiple times or duplicated.
            We have not putted check for enrollment effective date there.

            Correction : When we exposed minimum cost field we have checked UserID, RundateMaintainance. We had not checked the enrollment effective date.
            Now we have added below check while exporting data for minimum cost field and issue gets resolved.
            EMPENROll.EffectiveDate BETWEEN OES_VIEW_ACA_MinimumCostPlan.MonthStartDate AND OES_VIEW_ACA_MinimumCostPlan.MonthEndDate

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - 3C's : Concern : Here the basic issue is, if we export file records gets duplicated on file. Cause : While exporting ACA template, If employee has multiple enrollments during the exporting tenure i.e. From and To Date and ACA Minimum cost field is mapped in template then records gets populated multiple times or duplicated. We have not putted check for enrollment effective date there. Correction : When we exposed minimum cost field we have checked UserID, RundateMaintainance. We had not checked the enrollment effective date. Now we have added below check while exporting data for minimum cost field and issue gets resolved. EMPENROll.EffectiveDate BETWEEN OES_VIEW_ACA_MinimumCostPlan.MonthStartDate AND OES_VIEW_ACA_MinimumCostPlan.MonthEndDate
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 13/Dec/17 11:39 AM
            • Time Spent:
              3h
               

              Analysis and discussion with team, call with onshore for Issue description

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Dev Estimates 22
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Development Approval No [ 18473 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Revansiddha Gaur [ revansiddha.gaur ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 15/Dec/17 11:26 PM
            • Time Spent:
              5h
               

              Unit testing and discussion , review and documentation of this task.
              handvover the task to revan

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 18/Dec/17 10:00 PM - edited
            • Time Spent:
              7h
               

              Email go through received from Satya for Approval , internal discussion on email to take an approval with Gaurav,Test Case scenario find out,Client Call attend.

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) 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 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Code Review Date 15/Dec/2017
            Code Reviewed By Revansiddha [ 13002 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 31.5h [ 113400 ] 26.5h [ 95400 ]
            Time Spent 18.5h [ 66600 ] 23.5h [ 84600 ]
            Worklog Id 97136 [ 97136 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Development Approval No [ 18473 ] Yes [ 18474 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 41 [ 95 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Labels aca_export
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 26.5h [ 95400 ] 23.5h [ 84600 ]
            Time Spent 23.5h [ 84600 ] 26.5h [ 95400 ]
            Worklog Id 97148 [ 97148 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            QA Smita Pawar [ smita.pawar ]
            QA Estimates 7
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 23.5h [ 84600 ] 23h [ 82800 ]
            Time Spent 26.5h [ 95400 ] 27h [ 97200 ]
            Worklog Id 97199 [ 97199 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to EDI-2311 [ EDI-2311 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 20/Dec/17 10:00 PM
            • Time Spent:
              0.5h
               

              Code check ins & discussion.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 23h [ 82800 ] 17h [ 61200 ]
            Time Spent 27h [ 97200 ] 33h [ 118800 ]
            Worklog Id 97279 [ 97279 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 17h [ 61200 ] 16h [ 57600 ]
            Time Spent 33h [ 118800 ] 34h [ 122400 ]
            Worklog Id 97279 [ 97279 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Link This issue is cloned by WT-12858 [ WT-12858 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ]
            smita.pawar Smita Pawar (Inactive) logged work - 21/Dec/17 11:19 AM - edited
            • Time Spent:
              1.5h
               

              LB testing

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

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB. Its working fine.
            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)
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 21/Dec/17 10:00 PM
            • Time Spent:
              9h
               

              Impact testing,scenario testing(from home) for raised queries by qa.

            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)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 7h [ 25200 ]
            Time Spent 34h [ 122400 ] 43h [ 154800 ]
            Worklog Id 97521 [ 97521 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 7h [ 25200 ] 5.5h [ 19800 ]
            Time Spent 43h [ 154800 ] 44.5h [ 160200 ]
            Worklog Id 97528 [ 97528 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 97528 [ 97528 ]
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            This ticket has been approved for stage deployment on 12/21/17.

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, This ticket has been approved for stage deployment on 12/21/17. Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment [ 18455 ]
            Production Due Date 29/Dec/2017
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (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) made changes -
            Attachment All dependents.png [ 70908 ]
            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
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage company [MRTX for Hspl].
            Its working fine.
            Please find attached screen shot for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage company [MRTX for Hspl] . Its working fine. Please find attached screen shot for additional information.
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 5.5h [ 19800 ] 4.5h [ 16200 ]
            Time Spent 44.5h [ 160200 ] 45.5h [ 163800 ]
            Worklog Id 98289 [ 98289 ]
            smita.pawar Smita Pawar (Inactive) logged work - 28/Dec/17 01:58 PM
            • Time Spent:
              40m
               

              Stage testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 4.5h [ 16200 ] 3h 50m [ 13800 ]
            Time Spent 45.5h [ 163800 ] 46h 10m [ 166200 ]
            Worklog Id 98382 [ 98382 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 28/Dec/17 10:00 PM
            • Time Spent:
              1h
               

              CODE CHECKINS TO PRODUCTION.

            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            smita.pawar Smita Pawar (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
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have started working on Jira. We have exported Employee and coverage existing files and verified files are getting exported without server error.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have started working on Jira. We have exported Employee and coverage existing files and verified files are getting exported without server error.
            smita.pawar Smita Pawar (Inactive) logged work - 29/Dec/17 10:52 AM - edited
            • Time Spent:
              0.5h
               

              File exporting

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3h 50m [ 13800 ] 3h 35m [ 12900 ]
            Time Spent 46h 10m [ 166200 ] 46h 25m [ 167100 ]
            Worklog Id 98720 [ 98720 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3h 35m [ 12900 ] 3h 20m [ 12000 ]
            Time Spent 46h 25m [ 167100 ] 46h 40m [ 168000 ]
            Worklog Id 98720 [ 98720 ]
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the production deployment approval email for reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the production deployment approval email for reference Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment [ 18455 ] Approved for production deployment [ 18457 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned jira on production company.
            Its working fine.
            PFA screen shot for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned jira on production company. Its working fine. PFA screen shot for additional information.
            smita.pawar Smita Pawar (Inactive) logged work - 03/Jan/18 06:55 AM
            • Time Spent:
              10m
               

              Jira updates and discussion

            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 -
            Remaining Estimate 3h 20m [ 12000 ] 3h 10m [ 11400 ]
            Time Spent 46h 40m [ 168000 ] 46h 50m [ 168600 ]
            Worklog Id 99133 [ 99133 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Production Complete(10222) 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 -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Yogesh Chaudhari (Inactive) made transition -
            Open In Development
            1d 16m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            26d 2h 31m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            6d 20h 20m 1
            Smita Pawar (Inactive) made transition -
            Stage Testing In Production Testing
            2d 3h 55m 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            4d 20h 58m 1
            Smita Pawar (Inactive) made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Amber Love-Jones (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 50h
                  50h
                  Remaining:
                  Time Spent - 46h 50m Remaining Estimate - 3h 10m
                  3h 10m
                  Logged:
                  Time Spent - 46h 50m Remaining Estimate - 3h 10m
                  46h 50m