-
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
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.
-
- Time Spent:
- 7h
-
Analysis
Discussion
Coding
Field | Original Value | New Value |
---|---|---|
Remaining Estimate | 0h [ 0 ] | |
Time Spent | 7h [ 25200 ] | |
Worklog Id | 22413 [ 22413 ] |
-
- Time Spent:
- 2h
-
Discussion on addition of column in RateChanges_Log table to identify if the record got inserted by effective date service or not.
Discussion on code changes required in effective date service.
Time Spent | 7h [ 25200 ] | 10.5h [ 37800 ] |
Worklog Id | 22736 [ 22736 ] |
Environment | Production [ 10005 ] | |
Issue Type | Change Request [ 10002 ] | Bug [ 1 ] |
Status | New Request [ 10029 ] | Open [ 1 ] |
Workflow | WT_Features [ 31722 ] | WT_Defects [ 32310 ] |
Summary | Changes in effective date service for billing table | Rate and Enrollment ID not getting updated when record is moved by Effective date service |
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. |
Summary | Rate and Enrollment ID not getting updated when record is moved by Effective date service | Billing - Rate and Enrollment ID not getting updated when record is moved by Effective date service |
Assignee | surender kumar [ surender.kumar ] | Prasanna Karlekar [ prasanna ] |
Assignee | Prasanna Karlekar [ prasanna ] | surender kumar [ surender.kumar ] |
Summary | Billing - Rate and Enrollment ID not getting updated when record is moved by Effective date service | Billing - Need to avoid double insertion in Billing when record is moved by effective date service |
Time Spent | 10.5h [ 37800 ] | 12h [ 43200 ] |
Worklog Id | 24277 [ 24277 ] |
-
- Time Spent:
- 0.5h
-
Discussion on addition of "EffectiveDateServiceInsertion" in both RateChanges_log table
Time Spent | 12h [ 43200 ] | 12.5h [ 45000 ] |
Worklog Id | 24317 [ 24317 ] |
Time Spent | 12.5h [ 45000 ] | 14h [ 50400 ] |
Worklog Id | 24392 [ 24392 ] |
Time Spent | 14h [ 50400 ] | 14.5h [ 52200 ] |
Worklog Id | 24461 [ 24461 ] |
-
- Time Spent:
- 1.5h
-
Design Team meeting on addition of flag
Discussion on - flag needs to be added in Ratechanges_log table.
Time Spent | 14.5h [ 52200 ] | 15h [ 54000 ] |
Worklog Id | 25116 [ 25116 ] |
Status | Open [ 1 ] | In Development [ 10007 ] |
Time Spent | 15h [ 54000 ] | 17h [ 61200 ] |
Worklog Id | 26273 [ 26273 ] |
Severity | Complex [ 13103 ] | |
Original Estimate | 0h [ 0 ] |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Dev Due Date | 31/May/2017 |
Assignee | surender kumar [ surender.kumar ] | Prasanna Karlekar [ prasanna ] |
-
- Time Spent:
- 2.25h
-
Go through of already done code changes
Test scenario preparation
Time Spent | 17h [ 61200 ] | 19.25h [ 69300 ] |
Worklog Id | 50467 [ 50467 ] |
Time Spent | 19.25h [ 69300 ] | 19.75h [ 71100 ] |
Worklog Id | 51138 [ 51138 ] |
-
- Time Spent:
- 0.5h
-
Scenario creation on local
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Due Date | 06/Jun/2017 |
Dev Due Date | 31/May/2017 | 07/Jun/2017 |
Sprint | WT Sprint 30 -Bugs [ 70 ] |
-
- Time Spent:
- 0.5h
-
Effective date procedure go through and analysis on introducing flag for Rates Intermediate
-
- Time Spent:
- 1.25h
-
DDL and changes in effective date service procedure IsRatesIntermediate flag
Dev Due Date | 07/Jun/2017 | 09/Jun/2017 |
Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
Dev Due Date | 09/Jun/2017 | 14/Jun/2017 |
-
- Time Spent:
- 8h
-
Analysis
Discussion
Coding
Testing
Time Spent | 19.75h [ 71100 ] | 27.75h [ 99900 ] |
Worklog Id | 54176 [ 54176 ] |
-
- Time Spent:
- 0.5h
-
Discussion on Billing trigger fix related to effective date service
Time Spent | 27.75h [ 99900 ] | 31.75h [ 114300 ] |
Worklog Id | 54692 [ 54692 ] |
Time Spent | 31.75h [ 114300 ] | 34.75h [ 125100 ] |
Worklog Id | 55088 [ 55088 ] |
-
- Time Spent:
- 1.5h
-
Code review and discussion on scenarios tested
Time Spent | 34.75h [ 125100 ] | 35.25h [ 126900 ] |
Worklog Id | 55310 [ 55310 ] |
Time Spent | 35.25h [ 126900 ] | 36.75h [ 132300 ] |
Worklog Id | 55322 [ 55322 ] |
Time Spent | 36.75h [ 132300 ] | 37.25h [ 134100 ] |
Worklog Id | 55341 [ 55341 ] |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Assignee | Prasanna Karlekar [ prasanna ] | Sachin Hingole [ sachin.hingole ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Time Spent | 37.25h [ 134100 ] | 39.25h [ 141300 ] |
Worklog Id | 55558 [ 55558 ] |
-
- Time Spent:
- 0.25h
-
Review of script to update existing records
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Assignee | Sachin Hingole [ sachin.hingole ] | Venkatesh Pujari [ venkatesh.pujari ] |
Time Spent | 39.25h [ 141300 ] | 43.25h [ 155700 ] |
Worklog Id | 56533 [ 56533 ] |
Time Spent | 43.25h [ 155700 ] | 44.5h [ 160200 ] |
Worklog Id | 56606 [ 56606 ] |
Time Spent | 44.5h [ 160200 ] | 46h [ 165600 ] |
Worklog Id | 56628 [ 56628 ] |
Time Spent | 46h [ 165600 ] | 50h [ 180000 ] |
Worklog Id | 56771 [ 56771 ] |
Time Spent | 50h [ 180000 ] | 50.25h [ 180900 ] |
Worklog Id | 56836 [ 56836 ] |
Time Spent | 50.25h [ 180900 ] | 52.25h [ 188100 ] |
Worklog Id | 56919 [ 56919 ] |
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) |
Developer | surender kumar [ surender.kumar ] |
Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
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) |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
-
- Time Spent:
- 2h
-
Billing trigger changes on Stage
Time Spent | 52.25h [ 188100 ] | 54.25h [ 195300 ] |
Worklog Id | 62328 [ 62328 ] |
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) |
Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Time Spent | 54.25h [ 195300 ] | 58.25h [ 209700 ] |
Worklog Id | 62626 [ 62626 ] |
Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Time Spent | 58.25h [ 209700 ] | 59.25h [ 213300 ] |
Worklog Id | 64145 [ 64145 ] |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Resolution | Fixed [ 1 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
-
- Time Spent:
- 1.5h
-
Testing of scenarios on Production
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Time Spent | 59.25h [ 213300 ] | 60.75h [ 218700 ] |
Worklog Id | 64297 [ 64297 ] |
-
- Time Spent:
- 2.5h
-
Code check in
Disucssion related to Patch Deployment and revert
coding - Correction script to correct records which have RateChanges_LogID but their IsRatesIntermediate flag is NULL
Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Time Spent | 60.75h [ 218700 ] | 63.25h [ 227700 ] |
Worklog Id | 65898 [ 65898 ] |
Link | This issue relates to EDI-2229 [ EDI-2229 ] |
Bug Severity | Medium [ 16702 ] |
Environment_New | Production [ 18442 ] |
Transition | Time In Source Status | Execution Times |
---|
|
6d 22h 48m | 1 |
|
8d 17h 24m | 1 |
|
118d 5h 44m | 1 |
|
26d 21h 55m | 1 |
|
5d 21h 3m | 1 |
|
5h 51m | 1 |
|
40s | 1 |
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/
WT-8172_WTB_Report_ModTable_RateChange_Log.sqlWT-8172_WTB_Report_ModTable_RateChanges_Log_Intermediate.sqlWT-8172_WTB_Report_ModTable_BillingDetails_RateLog.sql/Database Objects/MasterCompanyDB/04_Stored Procedures/
/Database Objects/MasterCompanyDB/
/Database Objects/MasterCompanyDB/07_Data/
WT-8172_WTB_Report_ModData_BillingDetails_RateLog.sqlAffected Areas :
Effective Date Service
All Billing Scenarios (Please Refer
WT-7360)