EBS DBA: WF Mailer Override Address and Cloning: How to

Posted in: Technical Track

I just recently faced an issue on how to automate the Workflow Mailer override address for development and testing environments during the EBS cloning process. For the information of others, the “override address” is an email address you can set per EBS environment where WF Mailer will send ALL emails avoiding sending emails to real users during testing and development.

The problem is that the only official way to set the override address in the latest ATG releases is to go through the OAM portal and change the override email via the GUI interface. The GUI sends a verification code to the email address entered, asking to enter it on the next screen to confirm the change. The issue is that we as Apps DBAs do not always have access to the override address mail box. On top of that if we are looking to script whole EBS cloning process we need to find SQL-PL/SQL based solution.

I did some searches for an “official” PL/SQL API to be used, however failed to find one (biside of FND_SVC_COMP_PARAM_VALS_PKG.UPDATE_ROW which isn’t the most user friendly interface anyway).

I came to the following solution:

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;
	fnd_svc_comp_param_vals fscpv
	fscpv.PARAMETER_VALUE = '<override email address>'
	fscpv.parameter_id in (
			fnd_svc_comp_params_tl fscpt
			fscpt.display_name = 'Test 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;

Hope some of you will find it useful. As always use at your own risk and after careful testing :).

On the other hand I would be more than happy if you could point me to a better way of addressing the challenge.

Wishing all the best in your cloning efforts,

Thank God its Friday!

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Yury is a nice person who enjoys meeting and working with people on challenging projects in the Oracle space. He started to work as an Oracle DBA 14 years ago (1997). For the past 10 years (since 2001) his main area of expertise is Oracle e-Business Suite. Yury is an OCP 7,8,9,10g and OCM 9i,10g. He is a frequent presenter at Oracle related conferences such as Hotsos, UKOUG and AUOUG. Yury is a socially active person. Apart from Social Media (Twitter, Bloging, Facebook) he is the primary organizer of Sydney Oracle Meetup group (250 people). So if you happen to be in Sydney (Australia) drop Yury a message and stop by at one of his Meetups.

3 Comments. Leave new

We have used the below call to successfully update the parameter values for the service component like workflow mailer

FND_SVC_COMP_PARAM_VALS_PKG.LOAD_ROW ( x_component_name => ‘Workflow Notification Mailer’,
x_parameter_name => ‘TEST_ADDRESS’,
x_parameter_value => ‘[email protected]
x_customization_level => ‘L’
x_object_version_number => -1,
x_owner => ‘ORACLE’


By the way similar calls can be found in


The autoconfig script that updates workflow mailer details during cloning


Hello Amit,

Thank you for sharing the syntax you are using for setting override address.
It looks like blogging is mutually beneficial process. You share information with others and get to valuable feedback as yours.

Thanks once again,


Leave a Reply

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