Notification Mails are not sending to approver in Oracle Apps 11i
Step 1: check whether the user has selected his preference
to receive his Notification Mail HTML using the below query.
SQL > sqlplus ‘apps/apps_pwd’
SQL > SELECT * FROM FND_USER_PREFERENCES WHERE
USER_NAME='USER_NAME_OF_THE _USER' AND MODULE_NAME=’WF’;
In this above query it must show preference_value=MAILHTML , If not you need to Login to Oracle Apps
after Login to Oracle Apps on top right corner click on preferenceà scroll Down à In Notifications à select mail style as
HTML mail à
click apply.
Step 2: Login as sysadmin and go to user management search
that user name and verify his email address is associated with his Oracle ID ,
If not go to HRMS responsibility once again add his email ID to his ID and save.
Step 3: Login as sysadmin and request to run “synchronize wf
local tables “ to synchronize all table updates
Step 4 : send some test PO’s for Approval whether he is
receiving Notification mail or not
Also check through query ,
SQL > Select * from wf_notifications ORDER BY BEGIN_DATE DESC;
In this output MAIL_STATUS=’SENT’ means Notification mail’s
are sending to that user.
