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

ACA_EIN Import_Data transformed fields are not populating in Data Transformation Tab

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      ACA - Management Platform
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Browser:
      Google Chrome

      Description

      1.Login to LB.
      2.Edit company say 'Test_Venky_14th_July_2017'.
      3.Navigate to Home >> Company Home >> Template Management
      4.Edit existing template 'ACA EIN Import'.
      5.check sub template
      6.Click on Data Transformation tab.

      Actual: Data transformed field's data not displayed
      Expected: Data transformed field's data should display

        Attachments

          Issue Links

            Activity

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-9197 [ WT-9197 ]
            smita.pawar Smita Pawar (Inactive) logged work - 26/Jul/17 01:27 PM
            • Time Spent:
              0.5h
               

              Internal discussion

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 15.5h [ 55800 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 66623 [ 66623 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 26/Jul/17 09:00 PM
            • Time Spent:
              0.5h
               

              Internal discussion on dts issue.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 15h [ 54000 ]
            Time Spent 0.5h [ 1800 ] 1h [ 3600 ]
            Worklog Id 66762 [ 66762 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 07/Sep/2017
            Stage Due Date 30/Aug/17 [ 2017-08-30 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Code Review Date 01/Sep/2017
            Code Reviewed By Revansiddha [ 13002 ]
            Production Due Date 07/Sep/2017 07/Sep/2017
            Stage Due Date 30/Aug/17 [ 2017-08-30 ] 30/Aug/17 [ 2017-08-30 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 01/Sep/17 12:00 PM
            • Time Spent:
              4.5h
               

              Working and analysis of issue, for EIN import template user not able to see country fields in DTS.
              Analysis of EIN import is not working.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 10.5h [ 37800 ]
            Time Spent 1h [ 3600 ] 5.5h [ 19800 ]
            Worklog Id 76648 [ 76648 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 10.5h [ 37800 ] 10h [ 36000 ]
            Time Spent 5.5h [ 19800 ] 6h [ 21600 ]
            Worklog Id 76679 [ 76679 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 04/Sep/17 01:39 PM
            • Time Spent:
              6h
               

              Find out the issue in EIn import and resolve it.Done unit testing,code review.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 4h [ 14400 ]
            Time Spent 6h [ 21600 ] 12h [ 43200 ]
            Worklog Id 76729 [ 76729 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 04/Sep/17 09:00 PM
            • Time Spent:
              0.5h
               

              Code Review.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Sep/17 01:11 PM
            • Time Spent:
              0.5h
               

              Check-in code on local,LB and UIRefresh

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
            Time Spent 12h [ 43200 ] 12.5h [ 45000 ]
            Worklog Id 77112 [ 77112 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Smita Pawar [ smita.pawar ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            3C's

            Concern : 1. ACA_EIN Import_Data transformed fields are not populating in Data Transformation Tab.
            2. EIN import was giving server error

            Casue : 1. Country and state fields was not DTSapplicable , so not able Data transformed field's data not displayed
            2. we have used OES_SP_InsertUpdate_GenericEligibilityRule stored procedure and some parameters added in this Sp which was not updated in calling SP dbo.OES_SP_InsertUpdate_GenericEligibilityRuleForACA.

            Correction : 1. make coutry and state as DTS Applicable.
            2. Making the changes in dbo.OES_SP_InsertUpdate_GenericEligibilityRuleForACA, added new parameters while calling OES_SP_InsertUpdate_GenericEligibilityRule.

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - 3C's Concern : 1. ACA_EIN Import_Data transformed fields are not populating in Data Transformation Tab. 2. EIN import was giving server error Casue : 1. Country and state fields was not DTSapplicable , so not able Data transformed field's data not displayed 2. we have used OES_SP_InsertUpdate_GenericEligibilityRule stored procedure and some parameters added in this Sp which was not updated in calling SP dbo.OES_SP_InsertUpdate_GenericEligibilityRuleForACA. Correction : 1. make coutry and state as DTS Applicable. 2. Making the changes in dbo.OES_SP_InsertUpdate_GenericEligibilityRuleForACA, added new parameters while calling OES_SP_InsertUpdate_GenericEligibilityRule.
            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 -
            Status Open [ 1 ] In Development [ 10007 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Rutuja Chilwar [ rutuja.chilwar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Developer Yogesh Chaudhari [ yogesh.chaudhari ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 25/Sep/17 09:36 AM
            • Time Spent:
              0.5h
               

              Bug regression

            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have regressed this issue on LB,Azure and observed that it is fix.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue on LB,Azure and observed that it is fix.
            mahendra.mungase Mahendra Mungase (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)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 3h [ 10800 ]
            Time Spent 12.5h [ 45000 ] 13h [ 46800 ]
            Worklog Id 82627 [ 82627 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 29/Sep/17 10:21 AM
            • Time Spent:
              1.5h
               
              <No comment>
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 1.5h [ 5400 ]
            Time Spent 13h [ 46800 ] 14.5h [ 52200 ]
            Worklog Id 82653 [ 82653 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 29/Sep/17 12:41 PM
            • Time Spent:
              2h
               

              analysis of the issue

            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 14.5h [ 52200 ] 16.5h [ 59400 ]
            Worklog Id 82806 [ 82806 ]
            smita.pawar Smita Pawar (Inactive) logged work - 29/Sep/17 01:54 PM
            • Time Spent:
              0.25h
               

              Internal discussion

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 16.75h [ 60300 ]
            Worklog Id 82869 [ 82869 ]
            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 -
            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 -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Attachment WT-10311_done1 stage.png [ 63302 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Attachment WT-10311_done2 stage.png [ 63303 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Production Due Date 07/Sep/2017 09/Oct/2017
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Stage Due Date 30/Aug/17 [ 2017-08-30 ] 5/Oct/17 [ 2017-10-05 ]
            Hide
            rutuja.chilwar Rutuja Chilwar (Inactive) added a comment -

            verified this issue for stage, it is working as Expected.

            CC- Rakesh Roy Sachin Hingole Smita Pawar

            Show
            rutuja.chilwar Rutuja Chilwar (Inactive) added a comment - verified this issue for stage, it is working as Expected. CC- Rakesh Roy Sachin Hingole Smita Pawar
            rutuja.chilwar Rutuja Chilwar (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Assignee Rutuja Chilwar [ rutuja.chilwar ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue relates to WT-10995 [ WT-10995 ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have verified this issue on Production and observed it is working as expected. Hence closing the same.

            Thanks,
            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have verified this issue on Production and observed it is working as expected. Hence closing the same. Thanks, Mahendra
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 30/Nov/17 04:18 AM
            • Time Spent:
              0.5h
               

              Issue verification on Production

            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Time Spent 16.75h [ 60300 ] 17.25h [ 62100 ]
            Worklog Id 93792 [ 93792 ]
            Transition Time In Source Status Execution Times
            Smita Pawar (Inactive) made transition -
            Open In Development
            50d 20h 50m 1
            Smita Pawar (Inactive) made transition -
            In Development In LB Testing
            17m 52s 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            17d 23h 59m 1
            Mahendra Mungase (Inactive) made transition -
            Stage Testing In Production Testing
            56d 21h 12m 1
            Mahendra Mungase (Inactive) made transition -
            In Production Testing Production Complete
            8s 1
            Mahendra Mungase (Inactive) made transition -
            Production Complete Closed
            8s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Developer:
              Yogesh Chaudhari (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:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h Original Estimate - 16h
                  16h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 17.25h
                  17.25h