WORKTERRAProject Type: software

WORKTERRA

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

Column-Wise Billing Report - Displayed blank effective date

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production, Stage, QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 37 - Bugs, WT Sprint 38 - Bugs

      Description

      Precondition :

      Create one Column-wise billing report like as :

      Replication Steps :
      1) Partner Login
      2) Navigate up to Billing Report
      3) Ran Report

      Issue : Displayed blank Enrollment Effective Date for particular plan. Extra column added at end of report to display effective date.

      CC - Sachin Hingole

        Attachments

        1. Fields.jpg
          Fields.jpg
          23 kB
        2. WT-10859_PROD_BillingReport.png
          WT-10859_PROD_BillingReport.png
          79 kB
        3. WT-10859.xls
          17 kB
        4. WT-10859.xls
          429 kB
        5. WT-10859.xls
          1.59 MB
        6. WT-10859 (c97352a5-72a8-4a47-9a02-2d725b57c4db).xls
          80 kB
        7. WT-10859-ETA.xls
          7 kB

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          harshada.borole Harshada Borole (Inactive) added a comment -

          Below are the 3C's:
          Concern:- Reports - Displayed blank Effective Date.
          Cause:- Flag for Enrollment Effective date was getting set to False because of mismatch of query for Enrollment Effective Date.
          Correction:- Corrected the query with Enrollment Effective Date.

          Apart from this we also found an issue related to Effective Date which we have fixed with this ticket.
          Below are the details:-
          Issue:- 'Enrollment Effective Date' in Benefit Field section appeared as 'Effective Date' at the time of selection. On saving the report and re-opening the template the 'Effective Date' now appeared as 'Enrollment Effective Date'.

          Excepted:- 'Effective Date' in Benefit field should always appear as 'Enrollment Effective Date' before or after saving the template.

          Affected Files:-
          RDLGenerator.vb

          Area's Affected:-
          While pulling Billing Details Reports.

          Testing Scenario's:-
          Pulled Billing Details Report by selecting 'Enrollment Effective Date' from Benefit Fields section in the template.

          Show
          harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern:- Reports - Displayed blank Effective Date. Cause:- Flag for Enrollment Effective date was getting set to False because of mismatch of query for Enrollment Effective Date. Correction:- Corrected the query with Enrollment Effective Date. Apart from this we also found an issue related to Effective Date which we have fixed with this ticket. Below are the details:- Issue:- 'Enrollment Effective Date' in Benefit Field section appeared as 'Effective Date' at the time of selection. On saving the report and re-opening the template the 'Effective Date' now appeared as 'Enrollment Effective Date'. Excepted:- 'Effective Date' in Benefit field should always appear as 'Enrollment Effective Date' before or after saving the template. Affected Files:- RDLGenerator.vb Area's Affected:- While pulling Billing Details Reports. Testing Scenario's:- Pulled Billing Details Report by selecting 'Enrollment Effective Date' from Benefit Fields section in the template.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Please plan this for testing, also provide stage and production due dates.
          Let us know if you need any other details on this.

          [~meghana joshi] Rakesh Roy Hrishikesh Deshpande Prasad Patil Prasanna Karlekar

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Please plan this for testing, also provide stage and production due dates. Let us know if you need any other details on this. [~meghana joshi] Rakesh Roy Hrishikesh Deshpande Prasad Patil Prasanna Karlekar
          Hide
          Permalink
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Harshada Borole

          I have verified this issue on LB

          Verified with Partner login

          Verified on Company "For QA Fdu for Hspl"

          Its getting Re-Open
          WT-10859.xls

          cc:Rakesh Roy Sachin Hingole Prasad Pise [~meghana joshi]

          Thank you !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Harshada Borole I have verified this issue on LB Verified with Partner login Verified on Company "For QA Fdu for Hspl" Its getting Re-Open WT-10859.xls cc: Rakesh Roy Sachin Hingole Prasad Pise [~meghana joshi] Thank you !
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Have verified this issue in Production environment. Effective date issue is present in Production environment too. Please refer below screen shot from Production site:

          Unlinking WT-8642 from this JIRA as this is not caused by fix done in it.

          Thank you!

          cc: Gaurav Sodani

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Have verified this issue in Production environment. Effective date issue is present in Production environment too. Please refer below screen shot from Production site: Unlinking WT-8642 from this JIRA as this is not caused by fix done in it. Thank you! cc: Gaurav Sodani
          Hide
          Permalink
          harshada.borole Harshada Borole (Inactive) added a comment -

          Below are the 3C's:
          Concern:- Reports - Displayed blank Effective Date.
          Cause:- Query was not handled in SP for Enrollment Effective Date.
          Correction:- Corrected the query for Enrollment Effective Date.

          Affected Files:-
          RDLGenerator.vb
          ReportDetails.vb
          OES_SP_GetBillingDetailsMonthlyColumnWise

          Show
          harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern:- Reports - Displayed blank Effective Date. Cause:- Query was not handled in SP for Enrollment Effective Date. Correction:- Corrected the query for Enrollment Effective Date. Affected Files:- RDLGenerator.vb ReportDetails.vb OES_SP_GetBillingDetailsMonthlyColumnWise
          Hide
          Permalink
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hello, Harshada Borole

          I have verified this issue on LB

          Verified with Partner login

          Verified on Company "For QA Fdu for Hspl"

          Its Getting Re-Open
          WT-10859.xls

          cc: Rakesh Roy Prasad Pise Sachin Hingole [~meghana joshi]

          Thank You !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hello, Harshada Borole I have verified this issue on LB Verified with Partner login Verified on Company "For QA Fdu for Hspl" Its Getting Re-Open WT-10859.xls cc: Rakesh Roy Prasad Pise Sachin Hingole [~meghana joshi] Thank You !
          Hide
          Permalink
          harshada.borole Harshada Borole (Inactive) added a comment -

          Below are the 3C's:
          Concern:-
          Every benefit plan field had blank data in columnwise report.

          Cause:-
          In a fix for WT-10466, to form RDL field set special character were replaced by Underscore ('_').This change was missing in column-wise billing report.Due to this there were mismatch in Data Source fields and RDL fields which resulted into blank data in respective fields.

          Correction:-
          Replaced special characters with Underscore ('_') in Column-wise report.

          Files Affected:-
          OES_SP_GetBillingDetailsMonthlyColumnWise

          Show
          harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern:- Every benefit plan field had blank data in columnwise report. Cause:- In a fix for WT-10466 , to form RDL field set special character were replaced by Underscore ('_').This change was missing in column-wise billing report.Due to this there were mismatch in Data Source fields and RDL fields which resulted into blank data in respective fields. Correction:- Replaced special characters with Underscore ('_') in Column-wise report. Files Affected:- OES_SP_GetBillingDetailsMonthlyColumnWise
          Hide
          Permalink
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Harshada Borole

          I have verified this issue on LB

          Verified with Partner Login

          Verified with Company " For Qa Asml"

          Its working fine
          WT-10859.xls

          Hence, Marking is as Ready for stage

          cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande @rakesh

          Thank you !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Harshada Borole I have verified this issue on LB Verified with Partner Login Verified with Company " For Qa Asml" Its working fine WT-10859.xls Hence, Marking is as Ready for stage cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande @rakesh Thank you !
          Hide
          Permalink
          harshada.borole Harshada Borole (Inactive) added a comment -

          Code check-in done for UI Refresh.

          Show
          harshada.borole Harshada Borole (Inactive) added a comment - Code check-in done for UI Refresh.
          Hide
          Permalink
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Harshada Borole

          I have verified this issue on Azure

          Verified with Partner Login

          Verified with Company " City Of Denton For Hspl"

          Its working fine

          WT-10859.xls

          cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

          Thank You !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Harshada Borole I have verified this issue on Azure Verified with Partner Login Verified with Company " City Of Denton For Hspl" Its working fine WT-10859.xls cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank You !

            People

            Assignee:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Reporter:
            meghana.joshi Meghana Joshi (Inactive)
            Developer:
            Harshada Borole (Inactive)
            QA:
            Priya Handepatil (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Time Spent - 55.8h Remaining Estimate - 3h
                3h
                Logged:
                Time Spent - 55.8h Remaining Estimate - 3h
                55.8h