Issue:
Workflow notification mailer not sending emails to users. But mails going out from middle tier server and concurrent program report’s mail going out. Below is the fix.
Rebuilding the Workflow Mailer’s queue:
a. Stop Workflow Mailer and Agent Listener service
b. Change the “WF: Workflow Mailer Framework Web Agent” [WF_MAIL_WEB_AGENT] profile option to point to the
physical Web Server host address and port
c. Rebuild mailer queue with:
i. Find the tablespace where indexes on corrid are created :
SQL> select tablespace_name from dba_indexes
where index_name=’WF_NOTIFICATION_OUT_N1′
—–
ex: APPS_TS_QUEUES
ii. Rebuild Mailer queue :
SQL> sqlplus apps/<apps_pwd> @$FND_TOP/patch/115/sql/wfntfqup APPS <apps_pwd> APPLSYS
d. Start Workflow Mailer and Agent Listener service.
Output:
WF: Workflow Mailer Framework Web Agent – http://server1.oracle.com:8002 (Changed from 8001 to 8002)