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

TIBCO & COSB ER contribution not showing

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Client
    • Company:
      TIBCO
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple
    • Reported by Customer:
      BCC

      Description

      We are still having the same issues as ticket WT-10635 where the ER contribution does not show on the confirmation statement or enrollment summary.

      I am trying to test this out on stage on TIBCO and I am getting the error below when I try and post an event.

      This issue has been going on for way too long. Can we please have a call in the morning to discuss


      Kira Hamilton

        Attachments

        1. AffectedEEList(WT10957).xls
          617 kB
        2. CompanyInfo(companyclasses).png
          CompanyInfo(companyclasses).png
          138 kB
        3. CompnayList(WT10957).xls
          9 kB
        4. confirmation2222.png
          confirmation2222.png
          151 kB
        5. Costandcoverage.png
          Costandcoverage.png
          21 kB
        6. EnrollNowHsa.png
          EnrollNowHsa.png
          26 kB
        7. Enroll now screen.png
          Enroll now screen.png
          235 kB
        8. GenericEligiblityRules.png
          GenericEligiblityRules.png
          150 kB
        9. image-2017-09-05-13-34-35-170.png
          image-2017-09-05-13-34-35-170.png
          24 kB
        10. Impact on File.PNG
          Impact on File.PNG
          20 kB
        11. Quincy_EMP.txt
          0.6 kB
        12. Quincy_reprodued issue.png
          Quincy_reprodued issue.png
          215 kB
        13. screenshot-1.png
          screenshot-1.png
          87 kB
        14. screenshot-2.png
          screenshot-2.png
          168 kB
        15. Tibco COSSB Quincy EE list.xls
          28 kB
        16. Untitled.png
          Untitled.png
          114 kB

          Issue Links

            Activity

            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Swapnil Pandhare

            CC:Rakesh Roy,Hrishikesh Deshpande,Satya,Gaurav Sodani

            Verified TIBCO for hspl this issue it comes when we try to initiate qualifying event for employee
            Refer below error Log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetRaiseQualifyingEventCollection->GenericEligblityCheck.FetchDemographicEligibility
            ErrorMessage: Incorrect syntax near ')'.
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
            TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Swapnil Pandhare CC: Rakesh Roy , Hrishikesh Deshpande , Satya , Gaurav Sodani Verified TIBCO for hspl this issue it comes when we try to initiate qualifying event for employee Refer below error Log: ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetRaiseQualifyingEventCollection->GenericEligblityCheck.FetchDemographicEligibility ErrorMessage: Incorrect syntax near ')'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput) TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) Thanks, Rashmita
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Rashmita Dudhe,

            Please find below 3C's:

            Concern: Server error occurred, when try to initiate qualifying event for employee.
            Cause: This issue occurred due to customization.
            • 'From Non NY to NY DBL' and 'NY DBL to Non N' this eligibility rules following customization available.
            • Class2 name was changed by Ocsd test on '01/04/2017' from 'NY Non Exempt SM' changed to 'NY Non Exempt SM BW'.
            • This change was saved by Shelly Bugay on 09/04/2017 without editing class2 name, as 'NY Non Exempt SM' , 'NY Non Exempt SM BW' these two class2 names are not matched hence class2 names goes blank and server error shows on initiate qualifying event page.
            Correction: We have done changes on tibco company on stage.

            Please Verify And Confirm.

            Thanks And Regards,
            Rohit Shete

            CC:Debbie Kulling,Amruta Lohiya,Jyoti Mayne,Avnish Yadav,Umesh Kadam

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Rashmita Dudhe , Please find below 3C's: Concern: Server error occurred, when try to initiate qualifying event for employee. Cause: This issue occurred due to customization. 'From Non NY to NY DBL' and 'NY DBL to Non N' this eligibility rules following customization available. Class2 name was changed by Ocsd test on '01/04/2017' from 'NY Non Exempt SM' changed to 'NY Non Exempt SM BW'. This change was saved by Shelly Bugay on 09/04/2017 without editing class2 name, as 'NY Non Exempt SM' , 'NY Non Exempt SM BW' these two class2 names are not matched hence class2 names goes blank and server error shows on initiate qualifying event page. Correction: We have done changes on tibco company on stage. Please Verify And Confirm. Thanks And Regards, Rohit Shete CC: Debbie Kulling , Amruta Lohiya , Jyoti Mayne , Avnish Yadav , Umesh Kadam
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling,

            CC:Rakesh Roy,Amruta Lohiya,Rohit Shete,Hrishikesh Deshpande

            1) Server error Issue is Fixed, We have also tested same on TIBCO company.

            2) Issue of ER contribution does not show on the confirmation statement or enrollment summary -

            We have tried all scenarios for this and it is not getting reproduced at our end.
            Can you please share Employee Details whose ER cost is not showing. Also, let us know on which user (Admin/Partner) you are facing this.

            Please refer screenshot of our testing where ER cost is showing proper. In the screenshot, the employee is same which you had reported in WT-10635.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling , CC: Rakesh Roy , Amruta Lohiya , Rohit Shete , Hrishikesh Deshpande 1) Server error Issue is Fixed, We have also tested same on TIBCO company. 2) Issue of ER contribution does not show on the confirmation statement or enrollment summary - We have tried all scenarios for this and it is not getting reproduced at our end. Can you please share Employee Details whose ER cost is not showing. Also, let us know on which user (Admin/Partner) you are facing this. Please refer screenshot of our testing where ER cost is showing proper. In the screenshot, the employee is same which you had reported in WT-10635 . Thanks, Rashmita
            Hide
            dkulling Debbie Kulling added a comment -

            Please stop marking an issue as resolved when you cannot reproduce it.

            Show
            dkulling Debbie Kulling added a comment - Please stop marking an issue as resolved when you cannot reproduce it.
            Hide
            satyap Satya added a comment -

            Hi Debbie Kulling,

            Development has considered this issue for 'Qualifying event' server error, which occurred due to Generic Eligibility migration. That has been fixed, however for 'ER contribution not showing on Confirmation statement' - development is looking into this in jira WT-10635. We have re-opened this and will share update in related jira ticket.

            Regards,
            Satya Prakash.

            Show
            satyap Satya added a comment - Hi Debbie Kulling , Development has considered this issue for 'Qualifying event' server error, which occurred due to Generic Eligibility migration. That has been fixed, however for 'ER contribution not showing on Confirmation statement' - development is looking into this in jira WT-10635 . We have re-opened this and will share update in related jira ticket. Regards, Satya Prakash.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Hi Debbie Kulling, The issue reprted in WT-10635 got Reproduced at our end. Development team is working on same.
            We will Keep you updated with Status.

            Let us know in case you required call for this issue from our end?
            —

            Hi Rohit Shete,

            This issue is getting Reproduced follow below steps:

            As per view history of PAIGE N RAUTIO employee.
            1]Insert Employee data through import template Employee Test Import refer attached file for demographics data
            2]Done Election Import in a medical plan through template Election Import no PCP with effective date 6/1
            3]HSA plan is contingent on Medical plan(eligibility contingency).
            4]Partner login through UI Enrolled into the HSA plan with effective date 7/1 Qualifying event BCC admin.
            Cross verified on Ui it is not showing ER contribution.

            Refer attached screen shots.

            CC:Rakesh Roy,Hrishikesh Deshpande,Satya,Hrishikesh Deshpande,Gaurav Sodani

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Hi Debbie Kulling , The issue reprted in WT-10635 got Reproduced at our end. Development team is working on same. We will Keep you updated with Status. Let us know in case you required call for this issue from our end? — Hi Rohit Shete , This issue is getting Reproduced follow below steps: As per view history of PAIGE N RAUTIO employee. 1]Insert Employee data through import template Employee Test Import refer attached file for demographics data 2]Done Election Import in a medical plan through template Election Import no PCP with effective date 6/1 3]HSA plan is contingent on Medical plan(eligibility contingency). 4]Partner login through UI Enrolled into the HSA plan with effective date 7/1 Qualifying event BCC admin. Cross verified on Ui it is not showing ER contribution. Refer attached screen shots. CC: Rakesh Roy , Hrishikesh Deshpande , Satya , Hrishikesh Deshpande , Gaurav Sodani Thanks, Rashmita
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            We are working on this and we will update you.

            Thanks And Regards,
            Rohit Shete.

            CC:Amruta Lohiya,Jyoti Mayne,Gaurav Sodani,Rashmita Dudhe

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , We are working on this and we will update you. Thanks And Regards, Rohit Shete. CC: Amruta Lohiya , Jyoti Mayne , Gaurav Sodani , Rashmita Dudhe
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment - - edited

            Hi Rashmita Dudhe,

            Please find below 3C's:

            Concern: The ER contribution is not showing on the summary or confirmation statement.
            Cause: This is scenario specific issue.
            • For flex and transit benefit type, on cost and coverage page Age Wise Coverage flag is yes.
            • EE enroll in plan, enter amount in employee coverage text box & directly click on enroll now button that time ER coverage goes null and not show on confirmation statement.
            Correction: We have done code-fix and we working on data correction. We will deploy this patch as per process.

            Thanks And Regards,
            Rohit Shete

            CC:Satya,Amruta Lohiya,Jyoti Mayne,Umesh Kadam,Gaurav Sodani

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - - edited Hi Rashmita Dudhe , Please find below 3C's: Concern: The ER contribution is not showing on the summary or confirmation statement. Cause: This is scenario specific issue. For flex and transit benefit type, on cost and coverage page Age Wise Coverage flag is yes . EE enroll in plan, enter amount in employee coverage text box & directly click on enroll now button that time ER coverage goes null and not show on confirmation statement. Correction: We have done code-fix and we working on data correction. We will deploy this patch as per process. Thanks And Regards, Rohit Shete CC: Satya , Amruta Lohiya , Jyoti Mayne , Umesh Kadam , Gaurav Sodani
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            We found around 4900+ employees across 49 do not received employer coverage. Please find attached list of affected employees and company names.
            We will target data correction on Quincy and TIBCO first. Please go through the attached list first. Many of these enrollments might have gone on export files with 0 employer coverage. Once we do the correction the changes will reflect on export files again. Please let us know if you are OK with this.

            AffectedEEList(WT10957).xls CompnayList(WT10957).xls

            Thanks And Regards,
            Rohit Shete.

            CC:Satya,Amruta Lohiya,Jaideep Vinchurkar,Jyoti Mayne,Umesh Kadam,Rashmita Dudhe

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , We found around 4900+ employees across 49 do not received employer coverage. Please find attached list of affected employees and company names. We will target data correction on Quincy and TIBCO first. Please go through the attached list first. Many of these enrollments might have gone on export files with 0 employer coverage. Once we do the correction the changes will reflect on export files again. Please let us know if you are OK with this. AffectedEEList(WT10957).xls CompnayList(WT10957).xls Thanks And Regards, Rohit Shete. CC: Satya , Amruta Lohiya , Jaideep Vinchurkar , Jyoti Mayne , Umesh Kadam , Rashmita Dudhe
            Hide
            dkulling Debbie Kulling added a comment -

            Please give me an ETA on the fix for TIBCO and Quincy. BCC also had this issue with COSB.

            I will inform the other CEs of the other groups impacted.

            Show
            dkulling Debbie Kulling added a comment - Please give me an ETA on the fix for TIBCO and Quincy. BCC also had this issue with COSB. I will inform the other CEs of the other groups impacted.
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            There was one condition missed in earlier scanning script. Now we have corrected scanning script and found attached EE Tibco COSSB Quincy EE list.xls were having issue of blank ER Coverage for TIBCO, Quincy and COSB.

            We have also checked these EEs impact on file. Please find below details.

            For Correction we will do following:
            1. Update ER coverage amount
            2. Recalculate ER cost with Consider Export Flag to True

            After correction, ER Coverage and cost will roll out on file. Please confirm if you want same to be roll out on file or not for these 3 companies.

            Our correction script is ready. After your approval, we will correct these 3 companies data immediately.

            Note: We are in progress of scanning EEs for all production companies and will share result with you. Please ignore previously shared list of affected EEs and companies.

            Cc: Amruta Lohiya, Jyoti Mayne

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , There was one condition missed in earlier scanning script. Now we have corrected scanning script and found attached EE Tibco COSSB Quincy EE list.xls were having issue of blank ER Coverage for TIBCO, Quincy and COSB . We have also checked these EEs impact on file. Please find below details. For Correction we will do following: 1. Update ER coverage amount 2. Recalculate ER cost with Consider Export Flag to True After correction, ER Coverage and cost will roll out on file. Please confirm if you want same to be roll out on file or not for these 3 companies. Our correction script is ready. After your approval, we will correct these 3 companies data immediately. Note: We are in progress of scanning EEs for all production companies and will share result with you. Please ignore previously shared list of affected EEs and companies. Cc: Amruta Lohiya , Jyoti Mayne
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            Code fix is deployed under WT-10635 JIRA today on LB. After QA approval, we will move it to Stage and Production.

            This JIRA is correction purpose.

            Cc: Amruta Lohiya, Jyoti Mayne

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , Code fix is deployed under WT-10635 JIRA today on LB. After QA approval, we will move it to Stage and Production. This JIRA is correction purpose. Cc: Amruta Lohiya , Jyoti Mayne
            Hide
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hello,

            Can you give me a specific date for release to PROD?

            Thank you,
            Kira
            Debbie Kulling

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Can you give me a specific date for release to PROD? Thank you, Kira Debbie Kulling
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Kira Hamilton,

            CC:Debbie Kulling,Hrishikesh Deshpande,Rohit Shete

            WT-10635 is deployed and verified on the local environment. We will deploy this on production with next production patch 19 September 2017.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Kira Hamilton , CC: Debbie Kulling , Hrishikesh Deshpande , Rohit Shete WT-10635 is deployed and verified on the local environment. We will deploy this on production with next production patch 19 September 2017. Thanks, Rashmita
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Debbie Kulling,

            As per our discussion in a call, we will do correction for TIBCO, Quincy and COSB companies tomorrow on priority. Also as discussed, this correction will be roll out on file.

            We have also scanned others companies and found only Castleberry and Rogers Memorial Hospital having impact on file for blank ER Coverage. These companies have only 4 affected records. Among those 4 records, Castleberry has 1 affected record and Rogers Memorial Hospital has 3 affected record.

            Code fix for this issue has been deployed on LB under WT-10635. We will deploy the same on Stage tomorrow and Production on Monday.

            Thanks and Regards,
            Rohit Shete

            CC : Satya, Amruta Lohiya, Jyoti Mayne, Umesh Kadam

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Debbie Kulling , As per our discussion in a call, we will do correction for TIBCO, Quincy and COSB companies tomorrow on priority. Also as discussed, this correction will be roll out on file. We have also scanned others companies and found only Castleberry and Rogers Memorial Hospital having impact on file for blank ER Coverage. These companies have only 4 affected records. Among those 4 records, Castleberry has 1 affected record and Rogers Memorial Hospital has 3 affected record. Code fix for this issue has been deployed on LB under WT-10635 . We will deploy the same on Stage tomorrow and Production on Monday. Thanks and Regards, Rohit Shete CC : Satya , Amruta Lohiya , Jyoti Mayne , Umesh Kadam
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Hrishikesh Deshpande,

            Correction is done on Tibco for HSPL and COSB for HSPL. Please verify ER coverage and Cost for impacted EEs.

            Cc: Amruta Lohiya

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Hrishikesh Deshpande , Correction is done on Tibco for HSPL and COSB for HSPL. Please verify ER coverage and Cost for impacted EEs. Cc: Amruta Lohiya
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Jyoti Mayne,

            CC:Hrishikesh Deshpande

            Verified impacted employee sheet on COSB for hspl and Tibco for hspl .
            employees are getting proper ER coverage.

            You can do this on the main company.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jyoti Mayne , CC: Hrishikesh Deshpande Verified impacted employee sheet on COSB for hspl and Tibco for hspl . employees are getting proper ER coverage. You can do this on the main company. Thanks, Rashmita
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Debbie Kulling,

            We have done correction on TIBCO, Quincy and COSB companies.

            Note:

            • On COSB there is plan 'Mass Transit II' having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 9 EEs enrolled in this plan and we have not done any correction to them.
            • On Quincy there is plan 'Health Savings Account 2017 No Annual-A' having having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 3 EEs enrolled in this plan and we have not done any correction to them.

            Please confirm and let us know if you face any issue.

            Cc: Amruta Lohiya, Satya

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Debbie Kulling , We have done correction on TIBCO, Quincy and COSB companies. Note: On COSB there is plan 'Mass Transit II' having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 9 EEs enrolled in this plan and we have not done any correction to them. On Quincy there is plan 'Health Savings Account 2017 No Annual-A' having having ER contribution customized as $0 and ShowEmployerCoverage flag on cost and coverage is set to No. There are 3 EEs enrolled in this plan and we have not done any correction to them. Please confirm and let us know if you face any issue. Cc: Amruta Lohiya , Satya
            Hide
            jyoti.mayne Jyoti Mayne added a comment - - edited

            Hi Hrishikesh Deshpande,

            Please verify correction on TIBCO, Quincy and COSB company.

            Cc: Amruta Lohiya, Satya, Rashmita Dudhe

            Show
            jyoti.mayne Jyoti Mayne added a comment - - edited Hi Hrishikesh Deshpande , Please verify correction on TIBCO, Quincy and COSB company. Cc: Amruta Lohiya , Satya , Rashmita Dudhe
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified affected employee list for TIBCO, Quincy and COSB company showing proper ER coverage
            1]View enrollment summary
            2]Enroll now screen
            3]Confrimation Statement
            4]View history

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified affected employee list for TIBCO, Quincy and COSB company showing proper ER coverage 1]View enrollment summary 2]Enroll now screen 3]Confrimation Statement 4]View history
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling/Kira Hamilton

            This is deployed and verified on production.
            Data correction Done on TIBCO, Quincy and COSB company.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling / Kira Hamilton This is deployed and verified on production. Data correction Done on TIBCO, Quincy and COSB company. Thanks, Rashmita
            Hide
            jyoti.mayne Jyoti Mayne added a comment - - edited

            Hi Debbie Kulling,

            Regarding remaining two companies, Castleberry and Rogers Memorial Hospital there were only 4 EE found and they don't required correction as ShowEmployerCoverage is flag is set to No and Employer coverage is customized as $0.

            Cc: Satya, Amruta Lohiya

            Show
            jyoti.mayne Jyoti Mayne added a comment - - edited Hi Debbie Kulling , Regarding remaining two companies, Castleberry and Rogers Memorial Hospital there were only 4 EE found and they don't required correction as ShowEmployerCoverage is flag is set to No and Employer coverage is customized as $0. Cc: Satya , Amruta Lohiya

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Developer:
              Rohit Shete (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h Original Estimate - 1h
                  1h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 71h
                  71h