Accrual Plan Days Calculation
Hi,
There is a requirement of accrual plan to be calculated on the monthly basis
the emloyee is entitled to 24 days Annual Leave in a year
entitlement is reduce due to unpaid leave
unpaid Leave Accrual for deduction = no of unpaid lleave days * per_day_AL_accrual
Where
per_day_AL_accrual = monthly_accrual /(days in that month)
Ex:
Yearly Entitlement = 24
Monthly Entitlement = 24/12 = 2
per_day accrual in Jan = 2 / 31
per_day accrual in Feb = 2 / 28
if employee is on 1 day unpaid leave in Jan
total accrual in Jan = monthly accrual - (per_day accrual in Jan)
Is there any oracle standard formula in the accrual plan to achieve this?