Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
GET_WORKING_DAYS function for proration?
Our customer wants to prorate based on working days instead of calendar days. I've replaced DAYS_BETWEEN with the GET_WORKING_DAYS function but it's still doing the calculation using calendar days, There is no other formula doing the proration as I've tested this by removing proration formula from the element.
We're using EBS 12.1.3 RUP11
Here's the formula body:
DEFAULT FOR PAY_PROC_PERIOD_START_DATE is '01-JAN-1951' (Date)
DEFAULT FOR PAY_PROC_PERIOD_END_DATE is '01-JAN-4000' (Date)
DEFAULT FOR annual_salary is 0
Inputs are Annual_Salary,
Prorate_Start (Date),
Prorate_End (Date)
days_worked = GET_WORKING_DAYS(prorate_Start,Prorate_End)