HOW TO SET THE OVERRIDE ADDRESS in WORKFLOW MAILER

0

–Set the override address to  ‘xyz@abc.com’ , using the following script:
–Login to the application server..
cd $FND_TOP/sql
@afsvcpup.sql

Enter Component Id: 10006
Enter the Comp Param Id to update : 10093

Enter a value for the parameter  : xyz@abc.com

–Check the workflow services using the below query.

set pagesize 400
set linesize 120
set pagesize 50
column COMPONENT_NAME format a45
column STARTUP_MODE format a15
column COMPONENT_STATUS format a15
select fsc.COMPONENT_NAME,fsc.STARTUP_MODE,fsc.COMPONENT_STATUS
from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc
where fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
order by COMPONENT_STATUS , STARTUP_MODE , COMPONENT_NAME;


To Check What is the Current Email Address Set

SQL> select fscpv.parameter_value
from fnd_svc_comp_params_tl fscpt
,fnd_svc_comp_param_vals fscpv
where fscpt.display_name = ‘Test Address’
and fscpt.parameter_id = fscpv.parameter_id;  2    3    4    5

PARAMETER_VALUE
——————————————————————————–
xyz.abc@domain.com

Also one alternate is there to set it from back-end using the below query
——————————————————————————————
update fnd_svc_comp_param_vals
set    parameter_value = ‘&EnterEmailID’
where  parameter_id =
( select parameter_id
from   fnd_svc_comp_params_tl
where  display_name = ‘Test Address’);

 

http://garethroberts.blogspot.com/2008/05/clearing-email-notifications-and.html

How to set Workflow Mailer Override Address from Backend ? (Doc ID 1533596.1)

Share.

About Author

Leave A Reply

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.