Email Notification when Employee Changes Their Name
I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a list of people who changed their names that day.
I have a client who wants to be notified through email each time an employee changes their name. I'm not sure how to go about this. Would it be best to use OTBI, BI Publisher, or is it possible to setup in Alert Composer?
If I do need to use BI Publisher, I assume I'd start with PER_PERSON_NAMES_F. From there would I use a combination of Last_update_date and Former_last_name != Last_Name?