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.
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
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) )
Tagged:
0