Dear Experts,
Few customized reports were created for appraisal templates, and they were working fine previously .
Reports were like for : First semi annual Rating, KPI, Goals etc etc .
Now there is heavy data in system, and reports are not working at all. Its taking too much time .
As Per little analysis , there are 2000 templates and loop is on HRHAP_T table , so its taking too much time( till now m not able to execute that).
And as the data will increase , timings will increase , so totally confused how to resolve it .
Is there any other table in appraisals which we can use to retreive appraisal id, name and personal number of employee ?
OR
Is there any Standard BI reports which we can use instead of them, if not is it possible to create Customized BI reports for Appraisal documents ??
Please advise.
Regards,
Pran