We have resolved issue for Bio-Rad company but it needs to deploy on all environments for companies.

Hi Gaurav Sodani,

Have attached WT-12751- Issue and implementation Approach.xls file for deployment approval. This file include all details (i.e. issues, current implementation, Bug Resolution Approach and etc.).

Please check and let us know if need more details.

CC: Prasanna Karlekar Satya Samir

Hi All,

Attaching the development approval email for reference: Unable to embed resource: FW Hot Fix and Development Approval Request.msg of type application/octet-stream

Regards
Gaurav

3C's:
Concern: When we ran billing report for a month with all plans but nothing pulls on report and it shows report as blank screen even there is records for selected criteria.
Cause: The query was taking more than 4 minutes to execute for all selected criteria and due to this report was showing blank screen.
Correction: With existing implementation while generate billing report we form a query to join two temporary tables (i.e. Billing and Enrollment) based on common criteria. But the join conditions was taking more time to execute query. We have created index on both temporary tables so it will get execute less than a minute based on the selected criteria.

CC: Prasanna Karlekar Gaurav Sodani

Verified on LB.
Company: City of Durham
Verified billing details report for a month with all benefit/plan.
Report generated properly.
PFA,

Working properly. Ready for stage.

Thanks,
Sanjana Jadhav

CC: Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy

We have verified this issue on Stage - City of Durham and observed that Billing details report generated successfully

Hence marking ready for Production.

Mahendra

Hi All,

This ticket has been approved for stage deployment on 12/21/17.

Regards
Gaurav

Verified this issue on Production on AFI For Hspl company. Report being generated with correct records.

Thanks,
Venkatesh

Hi All,

Attaching the production deployment approval email for reference

Regards
Gaurav