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) )