Workflow Email Override oracle apps R12
If you are testing with for alert.Sending email to required user then you need to enter your email in workflow mailer then and then only you will get email.Also just updating and changing email address wont work until and unless you run below script from backed and commit the changes.
--workflow email override
BEGIN
FND_SVC_COMP_PARAM_VALS_PKG.LOAD_ROW
( x_component_name => 'Workflow Notification Mailer',
x_parameter_name => 'TEST_ADDRESS',
x_parameter_value => 'User_Email_id',
x_customization_level => 'L',
x_object_version_number => -1,
x_owner => 'user_name'
);
END;
COMMIT;
