-
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
Hi ,
Found this issue while testing WT-5308 . Steps to reproduce
Note: Self Insured Component is not set for plans selected on Template as well as on invoice
1) Generate and finalize the invoice
2) Go to Template Management
3) Create complete Billing Data Type Template (Rowise/Columnwise)
4) Manually Export the template
Result : No Records found
Template Details
Company Name (on LB): ASML
Template names:
1) Test_Billing Rowise
2) Test_Billing Columnwise
- relates to
-
WT-5308 Export BCC Provider Wise : Implementation
-
- Production Complete
-
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Summary | Export > No Records found on Providerwise Billing Data type Template export | Export > BCC Enhancement - No Records found on Providerwise Billing Data type Template export |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Aniruddha Dev [ aniruddha.dev ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Verified this fix on LB on Rowise and Column wise templates . Records getting exported properly on Providerwise Billing Data export file
| 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) |
adding stage and production testing estimates
| Remaining Estimate | 1h [ 3600 ] | |
| Original Estimate | 1h [ 3600 ] |
| Remaining Estimate | 1h [ 3600 ] | 0.75h [ 2700 ] |
| Time Spent | 0.25h [ 900 ] | |
| Worklog Id | 10418 [ 10418 ] |
| 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) |
Fix is deployed along with its parent JIRA WT-5308
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Verified the fix on Stage for Rowise and Columnwise Billing Data Templates . Working as expected
| 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) |
| Remaining Estimate | 0.75h [ 2700 ] | 25m [ 1500 ] |
| Time Spent | 0.25h [ 900 ] | 35m [ 2100 ] |
| Worklog Id | 12321 [ 12321 ] |
| 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 ] |
| 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. Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Remaining Estimate | 25m [ 1500 ] | 0h [ 0 ] |
| Time Spent | 35m [ 2100 ] | 1h [ 3600 ] |
| Worklog Id | 12478 [ 12478 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
16h 26m | 1 |
|
2d 43m | 1 |
|
20d 4h 39m | 1 |
|
4d 22h 8m | 1 |
|
2h 55m | 1 |
|
15s | 1 |
Concern : Export > BCC Enhancement - No Records found on Provider wise Billing Data type Template export.
Cause : This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper.
Correction We have Handle this as of now in SP.