Alert Email Not going to PR Requestor
Hi Gurus,
Requirement :- Once Approvers are approving the PR, the Alert should hit to mail box of Requestor so they know the Status of their PR's.
We are using R12.2.7 version. when Preparer is submitting the PR for Approval, the Requestor is getting Email through Alert but when Approvers are approving the PR then Requestor is not receiving any email. I have created an Event alert which is calling Pl/SQL package to send the email to Requestor.
I mean the Alert Event is running fine for the first time when PR is submitted for Approval but when Approvers are approving the PR from Notification window then Email is not going to Requestor but data inserted in PO_ACTION_HISTORY table and other Approvers are receiving the Approval Notification.