–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)
