We have a requirement in SAP SuccessFactors Time Off where Annual Leave should not be permitted either immediately before or after a ‘Work Remotely’ leave (only working days needs to check).
Example Scenario:
If an employee applies for Work Remotely from 11th to 15th May, and 11th May (Sunday) is a working day, then:
- Annual Leave should not be allowed on the previous working day (e.g., Thursday, 8th May)
- Or on the next working day (e.g., Sunday, 18th May)
This validation should also apply in the reverse — i.e., Work Remotely should not be allowed immediately before or after Annual Leave.
What I Tried:
I attempted to implement this logic using a business rule with Lookup() function, comparing the Previous/Next Working Day against existing Work Remotely records. However, the Lookup(Employee Time) returns null values for start and end dates, which prevents the rule from functioning as expected.
Request for Help:
- Is there a better way to validate overlapping or adjacent time types (like Annual Leave vs. Work Remotely)?
- How can we handle such scenarios if Lookup() fails to fetch the relevant dates due to its limitations with date range checks?
Any suggestions, alternate approaches, or best practices would be greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.