Workflow Notifications - "Override Email address" Functionality

Background :

      Very often on a Oracle Apps Test or Development environment, you would like all the Workflow Email notifications to be sent to one temporary email address instead of the original users to avoid confusion and to avoid filling the users mail box with Test data. Some companies will setup a temporary mail box and give access to the consultants.

Please  find the steps required to assign a temporary email address. This is much needed when testing Oracle Workflows based applications and especially time out reminder notifications.

These steps have been tried and tested on R12 environment.

Note: Please do not try these steps on Production Environment. Hopefully DBA only will have access to it :)

Steps:

Step 1 : Login to  Workflow Administrator > Oracle Applications Manager > Workflow Manager



Step 2 : Ensure that Notification Mailer is running, and then click on icon as below



 Step 3 : Click on the Notification Mailer > View Details



Step 4 : Click on "Set Override Address



Step 5 : You can enter an email ID to which you want to send all workflow Notifications and submit. (Note: you can also change it any time.)

You will receive a verification code, just enter it here and click on apply.

 You can verify the same Override Address using the below SQL:

select fscpv.parameter_value test_address
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
,      fnd_svc_components fsc
where  fscpt.parameter_id = fscpv.parameter_id
and    fscpv.component_id = fsc.component_id
and    fscpt.display_name = 'Test Address'
and    fsc.component_name = 'Workflow Notification Mailer';

Workflow Notification Mailer Outbound SMTP Server

We can get the Outbound SMTP Server Name using the below SQL:

select fscpv.parameter_value smtp_server_name
from   fnd_svc_comp_params_tl fscpt
,      fnd_svc_comp_param_vals fscpv
,      fnd_svc_components fsc
where  fscpt.parameter_id = fscpv.parameter_id
and    fscpv.component_id = fsc.component_id
and    fscpt.display_name = 'Outbound Server Name'
and    fsc.component_name = 'Workflow Notification Mailer';