Updating Test Mail ID override address for Workflow Notification Mailer in backend in R12

Login as apps user in sqlplus

Then run

SQL> @$FND_TOP/sql/afsvcpup.sql

Enter : 10006 (for Workflow Notification Mailer)

Then enter 10093

Now enter the new test mail id

Then Execute this query to see the update

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