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)

Recent Posts

Start typing and press Enter to search