Change Workflow Override Address in Oracle Apps

Himanshu funoracleapps , Oracle Apps 1 comment

We can use below script to update override address from backend in Oracle Apps.

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;

Check Current Override Email Address

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;

PARAMETER_VALUE
--------------------------------------------------------------------------------
xyz.abc@domain.com

Update Overide address from back-end using the below query

update fnd_svc_comp_param_vals
set parameter_value = 'newoverride@terex.com'
where parameter_id =
( select parameter_id
from fnd_svc_comp_params_tl
where display_name = 'Test Address');