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

Current Year flag is getting flipped AFTER OE start date (during OE window)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Export
    • Reported by:
      Support
    • Company:
      Sunnyvale School District
    • Item State:
      Production Complete
    • Sprint:
      WT Sprint 40 - Bugs

      Description

      We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually. This happens during the open enrollment. We asked the following question last week and the response indicates that this behavior is not a feature but is a bug, We are experiencing it for the company Sunnyvale School District.

      _When a company is in open enrollment, does the flag-flip service that runs every night reset the Current year flag to YES? We ask because there was a case where EDI analyst manually set the flag to NO – and it got flipped the next day.
      _
      Vinayak Kulkarni responded:
      Current Year Flag Flipping to YES happens in below two cases

      • Current Flag will be changed to YES if OE Start Date is matched to today's date i.e. the date on which service runs)
      • Or if the OE start date is less than today's date and it is updated a day before service runs. (This second case was identified as a redundant check and WT-11585 asked for it's removal.)

      CC Amit Thorve Van Nguyen Nathaniel Cornejo-Walker Cindy Wibbing

        Attachments

          Issue Links

            Activity

            abhay.patil Abhay Patil (Inactive) created issue -
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Hi Abhay Patil,

            Please find below 3C's

            Concern: We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually.

            Cause: This issue is occurred due to the WT-11585 second point of Vinayak Kulkarni comments i'e redundant check for current year flag flipping.

            Correction: As we have removing redundant check for current year flag flipping under WT-11585,so going forward this issue will never occur.

            Affected files: OES_SP_Export_SetCurrentYearFlagToYESFromOpenEnrollmentDashboard

            Impacted Areas: OE dashbaord's SQL JOB which set Current year flag to YES on OE start date.

            Swapnil Eksambekar please check this scenario.

            Please let me know any details needed.

            CC-Vinayak Kulkarni,

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Abhay Patil , Please find below 3C's Concern : We are experiencing a problem where CY flag is being set back to YES after the EDI analyst had set it to NO manually. Cause : This issue is occurred due to the WT-11585 second point of Vinayak Kulkarni comments i'e redundant check for current year flag flipping. Correction : As we have removing redundant check for current year flag flipping under WT-11585 ,so going forward this issue will never occur. Affected files : OES_SP_Export_SetCurrentYearFlagToYESFromOpenEnrollmentDashboard Impacted Areas : OE dashbaord's SQL JOB which set Current year flag to YES on OE start date. Swapnil Eksambekar please check this scenario. Please let me know any details needed. CC- Vinayak Kulkarni , Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Field Original Value New Value
            Remaining Estimate 1h [ 3600 ]
            Original Estimate 1h [ 3600 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 85757 [ 85757 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Swapnil Eksambekar [ swapnil.eksambekar ]
            Code Reviewed By Ganesh Sadawarte [ 12101 ]
            Dev Due Date 23/Oct/2017
            Developer Vinayak Kulkarni [ vinayak.kulkarni ]
            QA Swapnil Eksambekar [ swapnil.eksambekar ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Sprint WT Sprint 40 - Bugs [ 94 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 23/Oct/17 12:56 PM
            • Time Spent:
              1h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 23/Oct/17 03:16 PM
            • Time Spent:
              1h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (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)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 24/Oct/17 12:01 PM
            • Time Spent:
              2.5h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (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)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3.5h [ 12600 ]
            Worklog Id 86044 [ 86044 ]
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on LB,It is working as expected.
            Ready for stage.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh Roy

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on LB,It is working as expected. Ready for stage. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Export(10110)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Root Cause Duplicate Issue [ 18433 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 3.5h [ 12600 ] 4.5h [ 16200 ]
            Worklog Id 87922 [ 87922 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Labels Open_Enrollment_Dashboard
            satyap Satya made changes -
            Root Cause Duplicate Issue [ 18433 ] Scenario/Requirement Missed [ 18432 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Environment Production [ 10005 ]
            Environment_New Production [ 18442 ]
            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 ]
            swapnil.eksambekar Swapnil Eksambekar (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)
            swapnil.eksambekar Swapnil Eksambekar (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
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            verified this on Stage,it is working as expected.
            Ready for Production Deployment.

            CC-Aniruddha DevRakesh RoyHrishikesh Deshpande

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - verified this on Stage,it is working as expected. Ready for Production Deployment. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 6h [ 21600 ]
            Worklog Id 89236 [ 89236 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 07/Nov/17 07:15 AM - edited
            • Time Spent:
              1.5h
               
              <No comment>
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 25/Nov/2017
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Worklog Id 89236 [ 89236 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for production deployment [ 18457 ]
            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)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            swapnil.eksambekar Swapnil Eksambekar (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)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 25/Nov/17 09:26 AM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on production,It is working as expected.
            So assigning this ticket to you,please verify at your end and close it;

            Thanku,
            Swapnil E.

            CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeGaurav Sodani

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on production,It is working as expected. So assigning this ticket to you,please verify at your end and close it; Thanku, Swapnil E. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande Gaurav Sodani
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 6h [ 21600 ] 7h [ 25200 ]
            Worklog Id 92788 [ 92788 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Abhay Patil [ abhay.patil ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            Nathaniel, can you please confirm that we no longer face this problem? Thanks!

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Nathaniel, can you please confirm that we no longer face this problem? Thanks!
            abhay.patil Abhay Patil (Inactive) made changes -
            Assignee Abhay Patil [ abhay.patil ] Nathaniel Cornejo-Walker [ nwalker ]
            punam.satpute Punam Satpute (Inactive) made changes -
            Link This issue relates to NF-5227 [ NF-5227 ]
            abhay.patil Abhay Patil (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ganesh Sadawarte (Inactive) made transition -
            Open In Development
            4d 10h 21m 1
            Ganesh Sadawarte (Inactive) made transition -
            In Development In LB Testing
            1m 26s 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            12d 4h 7m 1
            Swapnil Eksambekar (Inactive) made transition -
            Stage Testing In Production Testing
            20d 19h 36m 1
            Swapnil Eksambekar (Inactive) made transition -
            In Production Testing Production Complete
            44m 4s 1
            Abhay Patil (Inactive) made transition -
            Production Complete Closed
            6d 9h 28m 1

              People

              Assignee:
              nwalker Nathaniel Cornejo-Walker (Inactive)
              Reporter:
              abhay.patil Abhay Patil (Inactive)
              Developer:
              Vinayak Kulkarni (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Production Due Date:

                  Time Tracking

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