This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,049 Users
  • 2,269,775 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.