This ticket is covered under Global Level Report Enhancement and it is moved up to LB . Some issues are reported back from QA whose fix is in progress.

Aditya VishwakarmaTRAC ID, Please

the trac Id is : 14674

TRAC details:-
#16844 : completed on LB
#16845 : completed on LB
#16846 : Dev non-repro
#16847 : with respective Dev person

Aditya VishwakarmaAmnesh GoelPlease update on # 16847.

#16847 : Fixed locally not pushed to LB. it will go on LB with others changes

Aditya VishwakarmaWhat's the plan to push on LB?

Hi Deepali Tidke,

Following three companies are having replication-on on LB. You may plan for a fresh round of testing of this task. Aditya Vishwakarma will help you further if required.

1. For_Report_LB_Austin_12286
2. For_Report_LB_JE_Dunn_12287
3. For_Report_LB_LHP_12285

Thanks,
Amnesh Goel

Deepali Tidke Aditya Vishwakarma What is the current status?

Deepali TidkeAditya Vishwakarma Please update the current status.

Rakesh Roy , Amnesh Goel, Deepali Tidke
I feel we need an internal discussion on this ticket.

Aditya Vishwakarma Deepali Tidke What's the current status?

This is currently on hold due to other task.

Hello
This Item is partially developed and moved to Stage with recent stage build.
So Menu for this item from Global Level should be disabled to avoid errors. When this will developed completely then we can enable the item from Global level Menu.

Currently holding development on this ticket. Due to billing correction.

As discussed with Jaideep Vinchurkar assigning to Prasanna Karlekar

3C's:
Concern: Enrollment Across all compnies report notworking
Cause: Mismatch query were generate.
Correction: Now we are generating query with elimination of global fields.

Description: It's working now. In old implementation having problem for mismatch fields in Global select query and company specific query. So while create structure to save reult as temporary while calculate all companies result it was giving exception.

Affetcted Areas: Global Reports, Reports

Affected Files:
Please find attached Modified-Files.txt file.

Tested Scenarios:
1. Verified every type report at global level with selection of additional fields and without additional fields.
2. verified preview and run functionality of global reports

Note; Along with this task need to check WT-3693 , WT-7718, WT-8284, WT-703, WT-707 tasks

Hi [~parmeshwar.jumbade] ,

As discussed , we are not able to save global report . it always throws validation message.
So, Enhancement testing is blocked.

Till the time, I will write test cases for Enhancement.

Thanks,
[~meghana joshi]

Prasanna Karlekar [~parmeshwar.jumbade]

PFA Test cases Global Level Report_Test Scenarios.xls and let me know if any scenarios needs to add.

CC - Sachin Hingole

Hi [~meghana joshi]

PFA Implementation document WT-129 _Implementation Document.doc which will helpful to test/understand this task.

CC- Prasanna Karlekar

Tested all the attached scenarios on LB.

Found Issues :

1) WT-10045
2) WT-10074
3) WT-10089
4) WT-10091

Suggestion :

1) WT-10076
2) WT-10090

One's all reported issues are solved then we will move that Enhancement to Stage.

CC - Sachin Hingole Prasanna Karlekar

Tested above issues on LB ( WT-10045 ,WT-10074,WT-10089 and WT-10091 ).
All are working Fine.

Will update testing status ones two issues ( WT-10324 , WT-10321 ,WT-10323 ) are completed on LB.

CC - Sachin Hingole Prasanna Karlekar

Changed Stage due date because WT-10323 is under development.

CC - Sachin Hingole

All above mentioned issues are working fine on LB.

Hence , That Jira is ready for Stage

CC - Sachin Hingole Prasanna Karlekar

Hi [~parmeshwar.jumbade] , Prasanna Karlekar ,

Getting server error on selecting any company for global level standard report creation.

PFA Error Log. ErrorLog.txt

CC - Sachin Hingole

Thanks,
[~meghana joshi]

Hi [~meghana joshi],

On stage environment had some issue related to read data from multiple DB servers. Now we have done some changes which will get deployed to next stage patch (Will deployed changes on all environment). For now we have executed script on stage due to this you can able to list of reports.

• CC Prasanna Karlekar

Hi [~parmeshwar.jumbade] ,

I have created one global level Standard Report for Employee Census Type.
But, Getting error on running report.

CC - Sachin Hingole , Prasanna Karlekar

Thanks,
[~meghana joshi]

HI [~meghana joshi],

As mentioned in above comment we have made some changes related to multiple DB server are deployed on LB, Stage environment. Now we can test this issue on stage.

CC Prasanna Karlekar

Hi [~parmeshwar.jumbade],

Verified Global level Standard Report for Employee Census Type for 2 companies .
Report is working Properly.

Verification for other types of Standard Report are in Progress.

CC - Sachin Hingole

Thanks,
[~meghana joshi]

Verified Global Level Standard Report for other types of Reports.
Working Fine

As per discussion with Prasanna Karlekar and [~parmeshwar.jumbade] , We will move that enhancement along with WT-9223.Hence marking item status to On HOLD.

CC - Satya Sachin Hingole

Thank you for providing the update!

Amanda Garvey | Client Support
Employee Benefit Specialists, Inc.
PO Box 11657, Pleasanton, CA 94588
PH: 925-469-2418 Ext 418| | FAX: 925-460-3920 | amanda.garvey@workterra.com<amanda.garvey@workterra.com>
[Description: Description: Description: Description: Description: twitter]<http://twitter.com/#!/workterra> [Description: Description: Description: Description: Description: linkedin-tiny-square2] <http://www.linkedin.com/company/workterra> [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] <http://www.facebook.com/workterra>

Hi Lalit Kumar,

Please attach the document for Global Level Reports feature in this JIRA.

Thank you!

cc: Gaurav Sodani, [~meghana joshi], [~parmeshwar.jumbade]

Testing is in progress on Production

Tested for below types of Report :

1) Employee Census
2) Dependent Census
3) Eligibility

Other Report types testing is in progress on Production.

Tested for Remaining types of Report

Report Types:

4) Enrollment
5) Billing Details
6) Payroll Deduction
7) System Utilization
8) Commission and Fee Details

Working Fine.

Hello Prasanna Karlekar,

I have attached the document to the ticket. Please refer Standard Reports at Global Reports Working.pptx

Regards,
Lalit Kumar

CC: Gaurav Sodani,[~meghana joshi],[~parmeshwar.jumbade]

Hi Amanda B. Garvey,

Please refer Standard Reports at Global Reports Working.pptx document for global level standard report customization .

Kindly, let me know if any more information needed from our side.

CC - Prasanna Karlekar Sachin Hingole Lalit Kumar

Thanks,
[~meghana joshi]