Hi All,

Oracle Application: 12.0.3
Issue Background: After having setup the profiles
"HR: Absence Duration Auto Overwrite" profile is set to Yes.
"HR: Schedule Based Absence Calculation" is not set to Yes.
And used a custom function to calculate the Absence Duration and called it in BG_ABSENCE_DURATION fast formula, I am able to get the Absence days in the absence screen.

Issue: The user enters the holiday days in the holiday calander after entering the absence days and the holidays are not being deducted from the already entered absence days field unless we re-enter the absence start and end date and save.

What could be the best solution ?
1. To write a "After update trigger" on Per_Calander_entries table to update the Absebce days field
2. If so can any one help be find code for the same...

Best Regards
MSA

Hi All,

Any updates on the subject line!
I was even thinking of creating a custom table and insert the absence entries during holiday period for the specific assignment, once the holiday days are updated in the per_calendar_entries table by the user the request will validate the entry and update the PER_ABSENCE_ATTENDANCES table @ Absence_days column with the actual Absence days (deducting the newly entered holidays)
...Am I making sence?

Any comments people! pls

Rgds
MSA