WORKTERRAProject Type: software

WORKTERRA

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

Billing - Need to avoid double insertion in Billing when record is moved by effective date service

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Stage Deployed
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Due to Invoice Management we are tracking future rate changes in Billing Table.
      After the election is moved from Intermediate to main table, currently the Enrollment and RateChanges_LogID are not getting updated.

        Attachments

          Issue Links

          causes

          Analysis - Analysis WT-12048 Billing Details Issue

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

          Change Request - Change Request WT-8417 Need to move dead enrollments through effective date service

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Testing has been completed for Billing Trigger changes on Production. System is working as per expectation.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Testing has been completed for Billing Trigger changes on Production. System is working as per expectation. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Testing is in progress on Production. I will update this ticket once all scenarios are tested.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Testing is in progress on Production. I will update this ticket once all scenarios are tested. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Testing has been completed for Billing Trigger changes. System is working as per expectation. This is ready for Production.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Testing has been completed for Billing Trigger changes. System is working as per expectation. This is ready for Production. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Testing is in progress on Stage. I will update this ticket once all scenarios are tested.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Prasanna Karlekar , Testing is in progress on Stage. I will update this ticket once all scenarios are tested. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            Testing has been completed for Billing Trigger changes. System is working as per expectation. This is ready for Stage.

            Sachin HingolePrasanna Karlekar

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , Testing has been completed for Billing Trigger changes. System is working as per expectation. This is ready for Stage. Sachin Hingole Prasanna Karlekar Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            Testing is in progress. I will update this ticket once all scenarios are tested.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , Testing is in progress. I will update this ticket once all scenarios are tested. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            surender.kumar surender kumar (Inactive) added a comment -

            3C:

            Concern: Double insertion in Billing when record is moved by effective date service.

            Cause: BillingDetails_RateLog table stores RateChanges_Log and RateChanges_Log_Intermediate tables records. When effective Date Service move records from Intermediate to main table then BillingDetails_RateLog contain will Double record, One is already inserted by RateChanges_Log_Intermediate and another is inserted from RateChanges_Log table by Effective Date Service.

            Correction: Introduce a Column EffectiveDateServiceInsertion in BillingDetails_RateLog which will avoid Double insertion in BillingDetails_RateLog.

            Affected Files:
            /Database Objects/MasterCompanyDB/01_DDL/

            • 574_WT-8172_WTB_Report_ModTable_RateChange_Log.sql
            • 575_WT-8172_WTB_Report_ModTable_RateChanges_Log_Intermediate.sql
            • 576_WT-8172_WTB_Report_ModTable_BillingDetails_RateLog.sql

            /Database Objects/MasterCompanyDB/04_Stored Procedures/

            • dbo.OES_SP_EffectiveDateForEnrollmentData.StoredProcedure.sql

            /Database Objects/MasterCompanyDB/

            • 05_Triggers/trgDelBillingDetails_RateLog.Trigger.sql
            • 05_Triggers/trgDelBillingDetails_RateLog_Intermediate.Trigger.sql
            • 05_Triggers/trgInsBillingDetails_RateLog.Trigger.sql
            • 05_Triggers/trgInsBillingDetails_RateLog_Intermediate.Trigger.sql
            • 05_Triggers/trgUpdBillingDetails_RateLog.Trigger.sql
            • 05_Triggers/trgUpdBillingDetails_RateLog_Intermediate.Trigger.sql

            /Database Objects/MasterCompanyDB/07_Data/

            • 440_WT-8172_WTB_Report_ModData_BillingDetails_RateLog.sql

            Affected Areas :
            Effective Date Service
            All Billing Scenarios (Please Refer WT-7360)

            Show
            surender.kumar surender kumar (Inactive) added a comment - 3C: Concern : Double insertion in Billing when record is moved by effective date service. Cause : BillingDetails_RateLog table stores RateChanges_Log and RateChanges_Log_Intermediate tables records. When effective Date Service move records from Intermediate to main table then BillingDetails_RateLog contain will Double record, One is already inserted by RateChanges_Log_Intermediate and another is inserted from RateChanges_Log table by Effective Date Service. Correction : Introduce a Column EffectiveDateServiceInsertion in BillingDetails_RateLog which will avoid Double insertion in BillingDetails_RateLog. Affected Files : /Database Objects/MasterCompanyDB/01_DDL/ 574_ WT-8172 _WTB_Report_ModTable_RateChange_Log.sql 575_ WT-8172 _WTB_Report_ModTable_RateChanges_Log_Intermediate.sql 576_ WT-8172 _WTB_Report_ModTable_BillingDetails_RateLog.sql /Database Objects/MasterCompanyDB/04_Stored Procedures/ dbo.OES_SP_EffectiveDateForEnrollmentData.StoredProcedure.sql /Database Objects/MasterCompanyDB/ 05_Triggers/trgDelBillingDetails_RateLog.Trigger.sql 05_Triggers/trgDelBillingDetails_RateLog_Intermediate.Trigger.sql 05_Triggers/trgInsBillingDetails_RateLog.Trigger.sql 05_Triggers/trgInsBillingDetails_RateLog_Intermediate.Trigger.sql 05_Triggers/trgUpdBillingDetails_RateLog.Trigger.sql 05_Triggers/trgUpdBillingDetails_RateLog_Intermediate.Trigger.sql /Database Objects/MasterCompanyDB/07_Data/ 440_ WT-8172 _WTB_Report_ModData_BillingDetails_RateLog.sql Affected Areas : Effective Date Service All Billing Scenarios (Please Refer WT-7360 )

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              surender.kumar surender kumar (Inactive)
              Developer:
              surender kumar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

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