Issue with PTO_SIMPLE_PERIOD_ACCRUAL fast formula
Budget: $30 – $250 USD
I'm new to Oracle E-Business suite version 12.1.2.3
after I set up the accrual plan
My issue is that the PTO_SIMPLE_PERIOD_ACCRUAL fast formula is calculated daily based (not monthly based)
this gives me the wrong value in the accrual formula because there are too big fractions.
I have two accruals, 45 days and 35 days
for Employees who have more than 15 years of experience, they will take 45 days of accrual, and less than 15 years will take 35 days of accrual.
if the employee will complete 15 years of experience through the year, of course, he will take a number between 35 and 45 days.
now if you divide 45/365=0.123287671232877 which is a big fraction and it makes a problem with me in the net accrual. because if you take this number and multiply it by 365 again it will equal 45.00000000000011.this number when I ceil (we need to use ceil function, not round function) it gives me 46 days of accrual and this is wrong.
but if you divide 45/12=3.75 which is a suitable number that we can deal with to calculate the accrual for an Employee and fraction issue will not happen.
the second issue is this formula makes the absence form too slow, when I hide the code for loop in the accrual fast formula I found the absence form coming very fast, so I thought that the reason for the slow accrual fast formula is the PTO_SIMPLE_PERIOD_ACCRUAL fast formula.
So please I need help to solve these two issues:
1-Make the accrual base on monthly based (not daily based)
2-Find the reason for the slow of this formula
Please find the attached files
after I set up the accrual plan
My issue is that the PTO_SIMPLE_PERIOD_ACCRUAL fast formula is calculated daily based (not monthly based)
this gives me the wrong value in the accrual formula because there are too big fractions.
I have two accruals, 45 days and 35 days
for Employees who have more than 15 years of experience, they will take 45 days of accrual, and less than 15 years will take 35 days of accrual.
if the employee will complete 15 years of experience through the year, of course, he will take a number between 35 and 45 days.
now if you divide 45/365=0.123287671232877 which is a big fraction and it makes a problem with me in the net accrual. because if you take this number and multiply it by 365 again it will equal 45.00000000000011.this number when I ceil (we need to use ceil function, not round function) it gives me 46 days of accrual and this is wrong.
but if you divide 45/12=3.75 which is a suitable number that we can deal with to calculate the accrual for an Employee and fraction issue will not happen.
the second issue is this formula makes the absence form too slow, when I hide the code for loop in the accrual fast formula I found the absence form coming very fast, so I thought that the reason for the slow accrual fast formula is the PTO_SIMPLE_PERIOD_ACCRUAL fast formula.
So please I need help to solve these two issues:
1-Make the accrual base on monthly based (not daily based)
2-Find the reason for the slow of this formula
Please find the attached files