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.

Solution to Employee Alert Notification when updated by HR/Manager

edited Oct 18, 2024 7:32AM in Performance Management

Hi Team,

We have requirement to create Alert to notify Employee if their goals are updated by HR/Manager within last 24 HRs.

Employee should receive mail with information of who updated their goals and the date on which it was updated.

Please suggest how this information can be sent in mail using resource alert, let me know which resource should be used for creating this alert.

I am trying to use below condition in filter to trigger the alert.

Exists (select 'Y' from HRG_GOALS s WHERE s.last_modified_by <> s.person_id AND trunc(s.last_update_date) between trunc(SYSDATE-1) and trunc(SYSDATE) )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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