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

            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
            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
            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
            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
            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.
            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
            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
            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
            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,
            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
            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
            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
            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.

              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: