Apps Functional

How set an override address for Workflow mailer:Oracle Apps Funtional

By Jag - April 16, 2014
Here are the steps to set it.
Responsibility: System Administrator
Navigation: System Administration > Oracle Applications Manager > Workflow
Click on Site Map on the top left

On clicking the next window opens
Click on Notification Mailer in the Workflow section
On clicking you will get
Now click on the link, Workflow Mailer Service, under Name section.
On clicking the details of the service is displayed
Now click on Set Override Address button on the top right.
On clicking a new window opens
As you can see an override address is already set. You can enter a new override address here and press on Submit button as shown below.
If you want to reset the override address you can press Clear Override Address button.
If the override address has not been set previously then the form will show the Current Override Address as NONE.
Enter email
Press Submit button
Now log in to the mailbox of the Override address mail id and you will find a notification mail with the verification code. The email is shown below.
The verification code is 371347685. Enter this value back on the Override Address OAF form.
Press Apply button and the Override address will be set. You may need to bounce the Workflow Notification Mailer service for the change to take place.

Set the email address from the back end:Execute the following SQL statement to select the override address from the back end
1
2
3
4
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
Now we want to change the email address to oracledev4user@****.com. Execute the following SQL
1
2
3
4
5
UPDATE fnd_svc_comp_param_vals fscpv
   SET fscpv.parameter_value = '&&email_address'
 WHERE fscpv.parameter_id IN (SELECT fscpt.parameter_id
                                FROM fnd_svc_comp_params_tl fscpt
                               WHERE fscpt.display_name = 'Test Address')
Enter the email address when prompted. The SQL will update 1 row. Commit the change.
A better way to set the mail address is to use an API, e.g.
1
2
3
4
5
6
7
8
9
10
BEGIN
   fnd_svc_comp_param_vals_pkg.load_row
                         (x_component_name             => 'Workflow Notification Mailer',
                          x_parameter_name             => 'TEST_ADDRESS',
                          x_parameter_value            => 'oracledev4@******.com',
                          x_customization_level        => 'L',
                          x_object_version_number      => -1,
                          x_owner                      => 'ORACLE'
                         );
END;
COMMIT the session. Now query the previous SQL to view the Override address.
Now bounce the Workflow Notification Mailer service, i.e. stop and start. If you check the Override address form from the front end you will see the following.
This shows that the override email address has been set.
Note: When the override address is not set
Execute the same SQL (given above) to retrieve the address
We would normally expect this value to be NULL but you can see that the value is NONE as no override email address is set.

SQL to retrieve the reply-to email address
1
2
3
4
5
6
7
8
SELECT fscpv.parameter_value smtp_server_name, fscpt.display_name
  FROM fnd_svc_comp_params_vl 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 = 'Reply-to Address'
   AND fsc.component_name = 'Workflow Notification Mailer';
  • Share:

You Might Also Like

0 comments