Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Redwood: Existing Absences Page giving wrong absence entry start date

Hi All,

We have a requirement to not to allow employees to update absences whose date is 30 days before the current date (Backdated absence).

We found a way to implement this through fast formula using ANC_PER_ABS_ENTRS_START_DATE DBI which helps us in

  1. Identifying whether we are updating the absence / submitting a new absence.
  2. Compare the older absence start date with today's (SYSDATE) date. To determine employee is trying to update an absence record that has a start date which is before 30 days from current date.

Example:

Today's Date : 25/07/2024

30 days before : 25/06/2024

if absence start date : 23/06/2024 and employee is trying to update this record.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!