Categories
12.1 12.2 Oracle EBS Workflow

Workflow: Set override e-mail address from backend

Get the override e-mail address from the backend

select parameter_value
from fnd_svc_comp_param_vals
where  parameter_id = 
( select parameter_id
  from   fnd_svc_comp_params_tl
  where  display_name = 'Test Address'
);

Set the override e-mail address from the backend

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

afsvcpup.sql

Leave a Reply

Your email address will not be published. Required fields are marked *