Changing WF_MAIL_WEB_AGENT Value

Here in my case profile options 'APPS_FRAMEWORK_AGENT' and 'WF_MAIL_WEB_AGENT' are having different values but it should have the same value. So to make corrections I followed the below steps.

select PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE from fnd_profile_options a, fnd_profile_option_values b where a.APPLICATION_ID = b.APPLICATION_ID and
a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID and a.PROFILE_OPTION_NAME in ('APPS_FRAMEWORK_AGENT','WF_MAIL_WEB_AGENT') and b.level_value = 0;

Before making the changes it is advised to stop all the workflow components.

Now change the profile option 'WF_MAIL_WEB_AGENT' to physical host-name of the server. Hostname of the server can be identified by the command 'hostname'. Here in this profile option the value should be the login URL of the application server.

Now run the same query to make sure the changes got effect.

Now use the below query to identify the tablespace where indexes on corrid for queue tables are created.

select tablespace_name from dba_indexes where index_name like 'WF%OUT%';

select distinct tablespace_name from dba_indexes,dba_queues where index_name like 'WF%OUT%' and table_name=queue_table and name like '%WF%';

Rebuild the mailer queue

sqlplus apps/<apps_pwd> @$FND_TOP/patch/115/sql/wfntfqup APPS <apps_pwd> APPLSYS

Recreate index on corrid column

CREATE INDEX WF_NOTIFICATION_OUT_N1 ON WF_NOTIFICATION_OUT(CORRID) STORAGE (INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) TABLESPACE &tbs;

Now start the workflow mailer components and check the test mail is sent/received properly.



                               ****************************நன்றி****************************