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)

Hi surender kumar,

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

Sachin Hingole

Thanks,
Venkatesh

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

Hi Prasanna Karlekar,

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

Sachin Hingole

Thanks,
Venkatesh

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

Hi Prasanna Karlekar,

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

Sachin Hingole

Thanks,
Venkatesh

Hi Prasanna Karlekar,

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

Sachin Hingole

Thanks,
Venkatesh