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 Report.xls
          5.33 MB
        2. Billing report2.xls
          2.80 MB
        3. Billing Report3.xls
          5.33 MB
        4. Billing Report 4.xls
          4.31 MB
        5. Test.xls
          125 kB
        6. Test one.xls
          98 kB
        7. WT_10739.xls
          737 kB
        8. WT-10739.xls
          908 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
            meghana.joshi Meghana Joshi (Inactive) created issue -
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-8642 [ WT-8642 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Summary Billing report - Throws Server error if Effective Date Fields exposed on Report Billing report - Throws Dataset error if Effective Date Fields exposed on Report
            meghana.joshi Meghana Joshi (Inactive) made changes -
            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 error. If we un-mapped Date fields then report ran properly.

            CC - [~sachin.hingole]             		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]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 36 - Bugs [ 84 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 04/Sep/2017
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Prasanna Karlekar [ prasanna ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 31/Aug/17 12:26 PM
            • Time Spent:
              4.5h
               

              Analysis, code fix, unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 0.5h [ 1800 ]
            Time Spent 4.5h [ 16200 ]
            Worklog Id 76188 [ 76188 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            Code Review Date 04/Sep/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Developer Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            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
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 04/Sep/17 09:17 AM
            • Time Spent:
              0.25h
               

              Code check-in, jira update

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0.25h [ 900 ]
            Time Spent 4.5h [ 16200 ] 4.75h [ 17100 ]
            Worklog Id 76600 [ 76600 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Sachin Hingole [ sachin.hingole ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 04/Sep/17 06:30 PM
            • Time Spent:
              0.25h
               

              Code review

            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            [~meghana joshi]

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - [~meghana joshi]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Priya Handepatil [ priya.handepatil ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 4.75h [ 17100 ] 5h [ 18000 ]
            Worklog Id 77003 [ 77003 ]
            priya.handepatil Priya Handepatil (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)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Billing Report 4.xls [ 60940 ]
            Attachment billing Report.xls [ 60941 ]
            Attachment Billing report2.xls [ 60942 ]
            Attachment Billing Report3.xls [ 60943 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Billing Report3.xls [ 60943 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Billing report2.xls [ 60942 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment billing Report.xls [ 60941 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Billing Report 4.xls [ 60940 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Billing Report 4.xls [ 60960 ]
            Attachment billing Report.xls [ 60961 ]
            Attachment Billing report2.xls [ 60962 ]
            Attachment Billing Report3.xls [ 60963 ]
            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
            priya.handepatil Priya Handepatil (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.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 5h [ 18000 ] 6h [ 21600 ]
            Worklog Id 77520 [ 77520 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Worklog Id 77520 [ 77520 ]
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 09/Sep/17 06:35 AM - edited
            • Time Spent:
              1h
               
              <No comment>
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            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
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 11/Sep/17 07:43 AM
            • Time Spent:
              0.5h
               

              Internal discussions

            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 6h [ 21600 ] 6.5h [ 23400 ]
            Worklog Id 77895 [ 77895 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            QA Priya Handepatil [ priya.handepatil ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 12/Oct/2017
            Stage Due Date 6/Oct/17 [ 2017-10-06 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            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
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 12/Oct/2017 11/Oct/2017
            Stage Due Date 6/Oct/17 [ 2017-10-06 ] 9/Oct/17 [ 2017-10-09 ]
            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)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 11/Oct/2017 18/Oct/2017
            Stage Due Date 9/Oct/17 [ 2017-10-09 ] 10/Oct/17 [ 2017-10-10 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT-10739.xls [ 64060 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT_10739.xls [ 64061 ]
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 11/Oct/17 09:45 AM
            • Time Spent:
              1h
               
              <No comment>
            priya.handepatil Priya Handepatil (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
            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 !!
            priya.handepatil Priya Handepatil (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.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
            Worklog Id 84261 [ 84261 ]
            ashwin.wankhede Ashwin Wankhede (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)
            priya.handepatil Priya Handepatil (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)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Test.xls [ 64558 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment Test one.xls [ 64559 ]
            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 !
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 8.5h [ 30600 ]
            Worklog Id 85170 [ 85170 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Production Complete(10222) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Worklog Id 85170 [ 85170 ]
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 17/Oct/17 05:39 AM - edited
            • Time Spent:
              1h
               

              Company Restore
              Testing for different scenarios
              Jira Updates

            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue is cloned by NF-5136 [ NF-5136 ]
            Transition Time In Source Status Execution Times
            Jyoti Agrawal (Inactive) made transition -
            Open In Development
            		12d 21h 48m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		5d 20h 12m 1
            Meghana Joshi (Inactive) made transition -
            In LB Testing Stage Testing
            		35d 3h 27m 1
            Priya Handepatil (Inactive) made transition -
            Stage Testing In Production Testing
            		4d 20h 9m 1
            Priya Handepatil (Inactive) made transition -
            In Production Testing Production Complete
            		11s 1
            Priya Handepatil (Inactive) made transition -
            Production Complete Closed
            		1m 3s 1

              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