Accrual Leave Balance Report Not Showing Calender Leave Balance (Doc ID 1629841.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Goal

User is trying to develop Accrual Leave Balance Report through "Oracle BI Publisher" for Organization's all employees. But they are not getting exact number of days for leaves using per_absence_attendances and per_abs_attendance_types_tl tables. As these tables does not have consider calendar days and Our organization holidays list.

For example if some body have applied leaves from 5-Feb-2014 to 20-Feb-2014 than (date_end - date_start) from per_absence_attendances will give output as 15 days but it should NOT consider Saturday and Sunday in its calculation. users have tried to calculate leaves using per_accrual_balances_v but that will also provide total leave balance as on Today. It does not consider future leaves.

User is trying to calculate leaves using per_accrual_balances_v, per_absence_attendances and per_abs_attendance_types_tl tables. Subtracting (date_end-date_start) from per_absence_attendances table does not give exact number of days for leave.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms