ORACLE Created Reports and queries:

                                    

1) Bursting queries with example.

2) To fetch the Manager's overall rating and payroll run result value (Annual Bonus letter).

3) To fetch the assignment details as of the effective date and their accrual balance.(Health check report).

4) To fetch the elements Payroll run result values. (Appreciation Bonus Letter).

5) To fetch the count of employee's contact relationships and their run result value(Education allowance report).

6)  Active and Terminated Employee Details

7) Annual Bonus Report (To fetch the payroll run result value of an element)

8) Active Employee Report (To find all the assignment and personal details)