-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Module:BenAdmin - Export
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
Total Billed Amount getting exported on Provider wise Export file is getting multiplied by 3 .
Template Details: 5308 Columnwise
Company (on LB) : ASML
Note: This was happening initially for Columniwse now its for rowise also
- relates to
-
WT-5308 Export BCC Provider Wise : Implementation
-
- Production Complete
-
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Aniruddha Dev [ aniruddha.dev ] |
Verified this fix on LB on rowise and columnwise template . Cost is getting exported properly now
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| 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) |
Updating stage and production testing estimates including multiple invoice creation and testing on export templates
| Remaining Estimate | 2h 25m [ 8700 ] | |
| Original Estimate | 2h 25m [ 8700 ] |
| Remaining Estimate | 2h 25m [ 8700 ] | 2h [ 7200 ] |
| Time Spent | 25m [ 1500 ] | |
| Worklog Id | 10416 [ 10416 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202) |
| Item State | Parent values: Stage QA(10202) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Fix is deployed along with its parent JIRA WT-5308
Verified this on stage . Cost getting exported on Provider Wise Export billing Data file is proper now.
Working as expected
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Remaining Estimate | 2h [ 7200 ] | 1h 50m [ 6600 ] |
| Time Spent | 25m [ 1500 ] | 35m [ 2100 ] |
| Worklog Id | 12367 [ 12367 ] |
| 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) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Remaining Estimate | 1h 50m [ 6600 ] | 1h 20m [ 4800 ] |
| Time Spent | 35m [ 2100 ] | 1h 5m [ 3900 ] |
| Worklog Id | 12486 [ 12486 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Verified this fix on Production by generating and finalizing multiple invoices.
Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1h 5m | 1 |
|
2s | 1 |
|
23d 21h 46m | 1 |
|
2d 20h 58m | 1 |
|
3h 12m | 1 |
|
2s | 1 |
Below are 3C's
Concern : BCC Enhancement - Cost exporting on providerwise export is multiplied by 3
Cause :This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper.
Correction We have Handle this as of now in SP.