Dynamic alert recipient list (Oracle Alerts)

Scenario:
I want to send an alert to a recipient that is identified by the output of the alert SQL.
Solution:
Enter variables from the select into the recipient list and subject header

Transfer Process in SSHR

Requirement:In the Transfer process after all the approvals notification should go to the employee being transferred.

Solution:As per standard Oracle workflow process, after approval notification goes to the person who has initiated the request.
Process for Transfer - HR_TRANSFER_JSP_PRC Then go to HR_NOTIFICATION_PRC then Go to HR_HRSSA_V5_APPROVED_PRC then go to
notification HR_NTFY_APPROVAL_OWNER_V4_NTF. In the node change performer from Creator Person User Name to Current Person User Name.

Test the process