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

Export > Rule, Action , Action Value is not working on field level

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production QA

      Description

      Found issue while checking EDI-53 on CAISO for HSPL

      Template Name :_CAISO Prudential Testing
      Field Name :Benefit Volume1

      on field level below customization is done
      Rule - in case of Termination
      Action : Replace
      Value: 0

      Below are the results for this field on exported template

      After Termination
      1) Approved Coverage amount salary index value is getting displayed as it is in case of termination instead of 0 . (Test Employee:Johnson Candace)

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Description Found issue while checking EDI-53 on CAISO for HSPL

            Template Name :_CAISO Prudential Testing
            Field Name :Benefit Volume1

            on field level below customization is done
            Rule - in case of Termination
            Action : Replace
            Value: 0

            Below are the results for this field on exported template

            After Termination
            1) Approved Coverage amount salary index value is getting displayed as it is in case of termination instead of 0 . (Test Employee:Johnson Candace)

            Employee is not enrolled in Plan
            2) If employee is not enrolled in Voluntary Life, 0 is getting displayed for Benefit Volume1 field

            Found issue while checking EDI-53 on CAISO for HSPL

            Template Name :_CAISO Prudential Testing
            Field Name :Benefit Volume1

            on field level below customization is done
            Rule - in case of Termination
            Action : Replace
            Value: 0

            Below are the results for this field on exported template

            After Termination
            1) Approved Coverage amount salary index value is getting displayed as it is in case of termination instead of 0 . (Test Employee:Johnson Candace)


            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Concern: In case termination field level rule not working for column wise template.

            Cause: Terminated benefit type compare with block sequence. so it will give error.

            Correction: We need code changes to handle this scenario.

            Note: As we compare to benefit type, so this will work for terminated benefit only. and this issue is not for row wise templates.
            -----------------------------------------------------------------------------------------------------------------------------------------------

            Concern: Zero value exported on file even not enrolled into plan for salary index field.

            Cause: Salary index is float type, in code it change if float data type value is null then export 0 on file. It not check for enrollment.

            Correction: We need code changes to handle this scenario.

            Note : This issue will not for any field, because we are checked against enrollment. if employee is enrollment then only field will export value 0 if has blank.

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Concern : In case termination field level rule not working for column wise template. Cause : Terminated benefit type compare with block sequence. so it will give error. Correction : We need code changes to handle this scenario. Note : As we compare to benefit type, so this will work for terminated benefit only. and this issue is not for row wise templates. ----------------------------------------------------------------------------------------------------------------------------------------------- Concern : Zero value exported on file even not enrolled into plan for salary index field. Cause : Salary index is float type, in code it change if float data type value is null then export 0 on file. It not check for enrollment. Correction : We need code changes to handle this scenario. Note : This issue will not for any field, because we are checked against enrollment. if employee is enrollment then only field will export value 0 if has blank. Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Affected Files:

            1. ExportProcess.vb
            2. ExportProcessXML.vb
            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Affected Files: ExportProcess.vb ExportProcessXML.vb
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Code Review Date 10/Jun/2016
            Code Reviewed By Rohan Khandave [ 11903 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment 613201654922PM_1601_2.txt [ 19639 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

            Ganesh Sadawarte
            Hi Ganesh ,

            I was checking WT-2244 for ANSI Template. And got server error while export . After discussion with Rakesh Shahane and Rohan J Khandave came to know that server error is due to this patch which was deployed on LB today . So could not test Rakesh S enhancement (for Manual Export) for ANSI Template. Attaching Error log 613201654922PM_1601_2.txt . Please look into this ASAP .

            CC: Hrishikesh Deshpande

            Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Ganesh Sadawarte Hi Ganesh , I was checking WT-2244 for ANSI Template. And got server error while export . After discussion with Rakesh Shahane and Rohan J Khandave came to know that server error is due to this patch which was deployed on LB today . So could not test Rakesh S enhancement (for Manual Export) for ANSI Template. Attaching Error log 613201654922PM_1601_2.txt . Please look into this ASAP . CC: Hrishikesh Deshpande Regards, Aniruddha Dev
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Aniruddha Dev [ aniruddha.dev ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Priya,

            Can you please verify this fix on LB ? Let me know if any help required from my side

            Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Priya, Can you please verify this fix on LB ? Let me know if any help required from my side Regards, Aniruddha Dev
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (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
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi

            I have started testing for the Jira. The testing is in progress.

            Thanks

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi I have started testing for the Jira. The testing is in progress. Thanks
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            The issue is verified on LB, it is working as expected.

            1. Now, The Action Rule: On Termination > Replace 0 works as expected. Now it is replaced by 0 if an employee gets terminated from plan.

            2. The Approved Coverage amount salary index is not shown if the employee gets terminated from the plan.

            Both the issues are verified and ready for Stage.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - The issue is verified on LB, it is working as expected. 1. Now, The Action Rule: On Termination > Replace 0 works as expected. Now it is replaced by 0 if an employee gets terminated from plan. 2. The Approved Coverage amount salary index is not shown if the employee gets terminated from the plan. Both the issues are verified and ready for Stage.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            priya.dhamande Priya Dhamande (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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Production Due Date 23/Jun/2016
            Stage Due Date 22/Jun/16 [ 2016-06-22 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Ganesh Sadawarte [ ganesh.sadawarte ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi Ganesh Sadawarte,

            Even after adding the rule, i am able to see the values on exported file.

            Can you please verify once at your end.

            Thanks

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi Ganesh Sadawarte , Even after adding the rule, i am able to see the values on exported file. Can you please verify once at your end. Thanks
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Ganesh Sadawarte [ ganesh.sadawarte ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Ganesh.sadawarte Ganesh Sadawarte (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)
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Hi Priya Dhamande,

            CC- Rohan J Khandave,Vinayak Kulkarni

            We have checked this. going forward please mention company and template name so it will better find easily. I have checked this on Caiso HSPL of AddTempForSalIndex template. This working as per rule set. Rule will work only in case of termination only and you set as replace with 0.

            Please check once and also specify scenario which falling.

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Priya Dhamande , CC- Rohan J Khandave , Vinayak Kulkarni We have checked this. going forward please mention company and template name so it will better find easily. I have checked this on Caiso HSPL of AddTempForSalIndex template. This working as per rule set. Rule will work only in case of termination only and you set as replace with 0. Please check once and also specify scenario which falling. Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Priya Dhamande [ priya.dhamande ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            The issue is verified on Stage on Caiso for Hspl company.

            1. Blank value is exported when employee not enrolled by Salary Index.
            2. If employee is terminated from plan then its cost changed to zero.

            This runs as expected. This is ready for production.

            Thanks,
            Priya

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited The issue is verified on Stage on Caiso for Hspl company. 1. Blank value is exported when employee not enrolled by Salary Index. 2. If employee is terminated from plan then its cost changed to zero. This runs as expected. This is ready for production. Thanks, Priya
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Found issue while testing the other feed on local environment.
            Scenario.

            If Salary Index map and not give benefit type that time its throwing server error. so i am doing check in into LB branch of this fix on LB. please also verify for All benefit. Priya Dhamande please reopen this. If All benefit type given salary index must have have or 0.

            Thanks,

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Found issue while testing the other feed on local environment. Scenario. If Salary Index map and not give benefit type that time its throwing server error. so i am doing check in into LB branch of this fix on LB. please also verify for All benefit. Priya Dhamande please reopen this. If All benefit type given salary index must have have or 0. Thanks,
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Ganesh Sadawarte [ ganesh.sadawarte ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Priya Dhamande [ priya.dhamande ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            Unable to test as Sub template page popup unable to save changes jira for the same is created with ID: WT-3231

            Thanks,
            Priya

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited Unable to test as Sub template page popup unable to save changes jira for the same is created with ID: WT-3231 Thanks, Priya
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Link This issue is blocked by WT-3231 [ WT-3231 ]
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            Hi,

            CC Satya Rohan J Khandave Rakesh Roy

            This JIRA is blocked due to WT-3231, the issue is due to jquerry patch on LB. Request you to please suggest the next set of action for the same as this is pending from last 3 days.

            Thanks,
            Priya

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited Hi, CC Satya Rohan J Khandave Rakesh Roy This JIRA is blocked due to WT-3231 , the issue is due to jquerry patch on LB. Request you to please suggest the next set of action for the same as this is pending from last 3 days. Thanks, Priya
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Adding Vijay Siddha

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Adding Vijay Siddha
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi Ganesh Sadawarte

            Please checkin code for this JIRA in stage for monday patch. Discussed with rakesh for the same.

            So, Pushing this Jira on Stage without testing on LB.

            Thanks,
            Priya

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi Ganesh Sadawarte Please checkin code for this JIRA in stage for monday patch. Discussed with rakesh for the same. So, Pushing this Jira on Stage without testing on LB. Thanks, Priya
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rakesh.shahane Rakesh Shahane (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)
            priya.dhamande Priya Dhamande (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)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            The issue of Server error after unmapping the Benefit type is resolved along with above two issue.

            This is ready for Production.

            Thanks,
            priya

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - The issue of Server error after unmapping the Benefit type is resolved along with above two issue. This is ready for Production. Thanks, priya
            priya.dhamande Priya Dhamande (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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rakesh.shahane Rakesh Shahane (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)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi

            All the three issues namely:
            1. In case of termination 0 value was not displaying even it is placed in rule.
            2. Salary Index value was showing even employee is not enrolled in plan.
            3. Server error on not mapping the Benefit type on Salary Index field.
            are resolved on production and displaying values as expected.

            Checked on Caiso for Hspl company on production on template _CAISO Prudential ProdTesting.
            The issues are verified and closed on Production.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi All the three issues namely: 1. In case of termination 0 value was not displaying even it is placed in rule. 2. Salary Index value was showing even employee is not enrolled in plan. 3. Server error on not mapping the Benefit type on Salary Index field. are resolved on production and displaying values as expected. Checked on Caiso for Hspl company on production on template _CAISO Prudential ProdTesting. The issues are verified and closed on Production.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ganesh Sadawarte (Inactive) made transition -
            Open In Development
            1d 3h 24m 1
            Priya Dhamande (Inactive) made transition -
            In Production Testing Reopen in Production
            10s 1
            Priya Dhamande (Inactive) made transition -
            Reopen in Production In Development
            2s 1
            Priya Dhamande (Inactive) made transition -
            Stage Testing Reopened in Stage
            1d 6h 40m 1
            Ganesh Sadawarte (Inactive) made transition -
            Reopened in Stage In Development
            1h 39m 1
            Ganesh Sadawarte (Inactive) made transition -
            In Development In LB Testing
            4d 20h 12m 3
            Priya Dhamande (Inactive) made transition -
            In LB Testing Stage Testing
            18d 22h 7m 3
            Priya Dhamande (Inactive) made transition -
            Stage Testing In Production Testing
            22h 37m 2
            Priya Dhamande (Inactive) made transition -
            In Production Testing Production Complete
            16s 1
            Priya Dhamande (Inactive) made transition -
            Production Complete Closed
            2s 1

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              Developer:
              Ganesh Sadawarte (Inactive)
              QA:
              Aniruddha Dev (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: