Forum Stats

  • 3,874,905 Users
  • 2,266,789 Discussions


Absence Entry Validation

Cecilia-Oracle Member Posts: 24 Employee
edited Mar 26, 2020 9:20PM in HCM Cloud Service

Is there any fast formula that can check the previous absence record upon absence submission, if there are absence records with the same absence type of the current selected absence type that have applied on the day before the current selected date (also consider day off, holiday), system could prompt an error message to ask the user to cancel the previous one and submit one absence request as a whole.

Example, User has applied a no pay leave on 5-6 Mar 2020, and now applying another no pay leave on 9-10 Mar 2020. As 7-8 is day off (Sat & Sun), and 5-10 should considered as a consecutive absence records, system should prompt error message to ask user to cancel 5-6 Mar 2020 absence and apply for 5-10 Mar 2020 instead.

Please advise, thank you.