WORKTERRAProject Type: software

WORKTERRA

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

Billing report - Throws Dataset error if Effective Date Fields exposed on Report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 36 - Bugs

      Description

      Customization :

      Customize Billing Report with Field Like as
      SSN , FName, LName, Plan Design Name, Effective Date, Termination Date, Employee Cost , Employer Cost and Total Amount

      Replication Steps :
      1) Partner Login
      2) Navigate up to Report -> Billing Report
      3) Run Report

      Issue: It throws DataSet error. If we un-mapped Date fields then report ran properly.

      CC - Sachin Hingole

        Attachments

        1. Billing report2.xls
          2.80 MB
        2. Billing Report 4.xls
          4.31 MB
        3. billing Report.xls
          5.33 MB
        4. Billing Report3.xls
          5.33 MB
        5. WT-10739.xls
          908 kB
        6. WT_10739.xls
          737 kB
        7. Test.xls
          125 kB
        8. Test one.xls
          98 kB

          Issue Links

          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. NF-5136 Billing report - Throws Dataset error if Effective Date Fields exposed on Report

          • Medium - Has the potential to affect progress.
          • Production Complete
          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-8642 Issue with coverages per family

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            3c's :-
            Concern:- Throws Data set error if Effective Date Fields exposed on Report
            Cause :- Incorrect drop of temp. table for Enrollment fields
            Correction:- Made conditional dropping of temp table for Enrollment fields

            Affected File :- Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql

            Affected Area :- Billing Details Report
            Any of the enrollment fields(mentioned below) were throwing error when there was no selection made of Approved coverage fields.
            Enrollment fields :-
            -Qualifying Even Name
            -Coverage tier label
            -Health tier policy number
            -Effective Date
            -Termination Date
            Approved coverage fields :-
            -Applied Coverages
            -Approved Coverages
            -Approved Coverage Amount
            -Enrollment Coverage Count

            Tested Scenario :-
            All above Enrollment as well Approved coverage fields with single and combinations

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - 3c's :- Concern:- Throws Data set error if Effective Date Fields exposed on Report Cause :- Incorrect drop of temp. table for Enrollment fields Correction:- Made conditional dropping of temp table for Enrollment fields Affected File :- Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql Affected Area :- Billing Details Report Any of the enrollment fields(mentioned below) were throwing error when there was no selection made of Approved coverage fields. Enrollment fields :- -Qualifying Even Name -Coverage tier label -Health tier policy number -Effective Date -Termination Date Approved coverage fields :- -Applied Coverages -Approved Coverages -Approved Coverage Amount -Enrollment Coverage Count Tested Scenario :- All above Enrollment as well Approved coverage fields with single and combinations
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            [~meghana joshi]

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - [~meghana joshi]
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Hi
            Verified this issue on LB

            Verified on company ""For Qa Fdu For Hspl"

            Verified with Mapping and without mapping of Date fields

            Billing Reports are properly generating

            Billing Report 4.xls billing Report.xls Billing report2.xls Billing Report3.xls

            Hence, Marking it as Ready for Stage

            Thanks,
            Priya Handepatil
            CC:Sachin Hingole Prasad Pise Rakesh Roy

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Verified this issue on LB Verified on company ""For Qa Fdu For Hspl" Verified with Mapping and without mapping of Date fields Billing Reports are properly generating Billing Report 4.xls billing Report.xls Billing report2.xls Billing Report3.xls Hence, Marking it as Ready for Stage Thanks, Priya Handepatil CC: Sachin Hingole Prasad Pise Rakesh Roy
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Patch will move to stage with WT-8642.

            CC - Prasanna Karlekar Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Patch will move to stage with WT-8642 . CC - Prasanna Karlekar Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Good to go on Stage

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Good to go on Stage CC - Sachin Hingole
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Hi

            Verified this issue on Stage

            Verified on company "JE Dunn For Hspl"

            Verified with Mapping and without mapping of Date fields

            Billing Reports are properly generating
            WT-10739.xls WT_10739.xls

            Hence, Marking it as Ready for Production

            cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

            Thank You !!

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Verified this issue on Stage Verified on company "JE Dunn For Hspl" Verified with Mapping and without mapping of Date fields Billing Reports are properly generating WT-10739.xls WT_10739.xls Hence, Marking it as Ready for Production cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank You !!
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Hi Jyoti Agrawal

            I have verified this issue on Production

            Verified on Company " TIBCO For HSPL"

            Verified with Broker Login

            Verified with Mapping of Date Fields
            Test.xls

            Verified with Unmapping of Date Fields
            Test one.xls

            Its working fine

            Hence, Marking it as Production Complete

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

            Thank You !

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Jyoti Agrawal I have verified this issue on Production Verified on Company " TIBCO For HSPL" Verified with Broker Login Verified with Mapping of Date Fields Test.xls Verified with Unmapping of Date Fields Test one.xls Its working fine Hence, Marking it as Production Complete cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande [~meghana joshi] Thank You !

              People

              Assignee:
              priya.handepatil Priya Handepatil (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Jyoti Agrawal (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 - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8.5h
                  8.5h