ERPstuff - Oracle EBS Community

Posted: **Thu Apr 29, 2010 6:47 am**

Hi,

Need to exclude Sat and Sun from Leave Apply, the requirement is when user apply for leave and when he enter days like 1 to 10 the system should exclude sat and sun in this duration and Calculate Duration Button should show the remaining days in Total Field. In which formula or PL/SQL script should open to amend this. Currently system is only excluding Sunday.

Regards,

Posted: **Mon May 03, 2010 9:10 am**

Dear Ssali,

You should modify the Fast Formula "BG_ABSENCE_DURATION" of type QuickPaint. If you need further explanation, feel free to post.

Best Regards,

Ahmad Ghanem

Posted: **Wed May 05, 2010 3:07 am**

Dear Ssali,

Modify the Fast Formula as Ahmed said their is a function (not remembering exactly) some thing like calculate days or else in BG_Absence_Duration formula. Modify it and use calculate working days to exclude sat and sun. You can find the exact name of function to be modified in BG_absence_duration fast formula in Fast formula user guide.

Regards

Majid

Posted: **Mon May 24, 2010 4:53 pm**

You can also use work schedules in order to exclude holidays..