I have taken the example of setting override address here however all other parameters of the workflow mailer can be configured by choosing the respective "Comp Param Id" while running below script "afsvcpup.sql"
HOW TO SET THE OVERRIDE ADDRESS in WORKFLOW MAILER
------------------------------------------------------------------------------------------------
--Set the override address to 'xyz@abc.com' , using the following script:
--Login to the application server..
cd $FND_TOP/sql
execute below script : (you will be prompted to choose between list of components you would like to configure )
sqlplus apps/apps @afsvcpup.sql
From the list of components available
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.
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');
No comments:
Post a Comment