WORKTERRAProject Type: software

WORKTERRA

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

On benefit type name change after invoice generation results into server error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT- Sprint 43

      Description

      Example :-
      Step 1: Select a benefit type named 'LTD' in an invoice template.
      Step 2: Generate invoice.
      Step 3: Now change the Benefit Type name 'LTD' to 'Long Term Disability'
      Step 4 : Generate next invoice or view invoice.

      Result : Server error

        Attachments

        1. WT-11679_Code Review Checklist.docx
          18 kB
          Prasanna Karlekar
        2. FW Development approval for 9-Nov-2017.msg
          141 kB
          Gaurav Sodani
        3. FW Development approval for 9-Nov-2017.msg
          141 kB
          Gaurav Sodani
        4. WT-11679.xls
          7 kB
          Venkatesh Pujari

          Issue Links

          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. NF-5859 CLONE - On benefit type name change after invoice generation results into server error

          • Medium - Has the potential to affect progress.
          • Resolution Setting

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg Regards Gaurav
            Hide
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Below are 3C's :-
            Concern :- On benefit type name change after invoice generation, results into server error
            Cause :- Invoice table is created with fix column, named with benefit name. On benefit name change , during insertion in the table there was a mismatch of column name.
            Correction :- Instead of creating column with benefit name, we are using benefit ID to create column as benefit ID will never change.

            Affected File :-

            • Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GetBenefitInvoiceMappingFields.sql
            • Database Objects/MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_Display_BenefitWiseBilling.sql

            Affected Area :-

            • Invoice Generation
            • Invoice View
            • Download Excel File
            • Invoice table structure

            Tested Scenario :-
            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            3) Change demographic fields name and then checked
            4) Change additional fields and checked
            4) Checked excel download
            5) Checked invoice summary

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Below are 3C's :- Concern :- On benefit type name change after invoice generation, results into server error Cause :- Invoice table is created with fix column, named with benefit name. On benefit name change , during insertion in the table there was a mismatch of column name. Correction :- Instead of creating column with benefit name, we are using benefit ID to create column as benefit ID will never change. Affected File :- Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GetBenefitInvoiceMappingFields.sql Database Objects/MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_Display_BenefitWiseBilling.sql Affected Area :- Invoice Generation Invoice View Download Excel File Invoice table structure Tested Scenario :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 3) Change demographic fields name and then checked 4) Change additional fields and checked 4) Checked excel download 5) Checked invoice summary
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Please check this.

            Prasad Pise Venkatesh Pujari

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Please check this. Prasad Pise Venkatesh Pujari
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            As discussed with Rakesh Roy, assigning this jira to you

            CC : Sachin Hingole Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - As discussed with Rakesh Roy , assigning this jira to you CC : Sachin Hingole Prasad Pise
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited

            Hi Jyoti Agrawal,

            Tested this issue on LB on City of Durham for hspl. Working fine as expected. Verified the below listed scenarios :-

            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            This is ready for Stage

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited Hi Jyoti Agrawal , Tested this issue on LB on City of Durham for hspl. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary This is ready for Stage Thanks, Venkatesh
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Keeping the ticket on hold, as it has not been approved for stage deployment
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Keeping the ticket on hold, as it has not been approved for stage deployment Regards Gaurav
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested this issue on Stage on AFI for hspl. Working fine as expected. Verified the below listed scenarios :-
            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            This is ready for Production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested this issue on Stage on AFI for hspl. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary This is ready for Production. Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested this issue on Production on Community Development Commission For HSPL company. Working fine as expected. Verified the below listed scenarios :-

            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested this issue on Production on Community Development Commission For HSPL company. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary Thanks, Venkatesh

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 35.75h
                  35.75h