How To Configure Workflow Notification Mailer To Send Email Notification For Only One Workflow Item type/Process?

How To Assign custom workflow mailer to custom workflow process 

Follow the below Steps to create a dedicated Workflow Notification Mailer to Process only one
particular Workflow Process:

1. Log in to applications as SYSADMIN.

2. Choose "Workflow Administrator Web Applications" responsibility.

3. Navigate to Oracle Applications Manager --> Workflow Manager.

4. Click on "Service Components".

5. Click on 'Container' to sort the displayed Service Components and check for 'Workflow Mailer
Service'.  Make sure the associated "Workflow Notification Mailer" is down.

6. Once confirmed, on the same page Click on "Create" button to create new custom Mailer.

The following options are available:

Select Name Description
1. Workflow Web Services Outbound -Component Type used to create a Workflow Web Services Outbound Component
2. Workflow Java Agent Listener -Component Type used to create a Workflow Java Agent Listener Service Component
3. Workflow Agent Listener -Component Type used to create a Workflow Agent Listener Service Component
4. Workflow Mailer -Component Type used to create a Workflow Mailer Service Component

Select 4 Workflow Mailer and continue.

7. Configure the Mailer with SMTP connection details.

8. On carrying out 'Advanced ' Edit,Please specify "Correlation ID" click on touch Light icon.
Now in pop -up window.Search and Select: Item Type which you want this dedicated Mailer to run/process.

For example: POAPPRV for PO Approval.

Important note:

For ATG RUP 4, the correlation id should be POAPPRV.

For ATG RUP 5 , the correlation id should be POAPPRV%.

For ATG RUP 7, the correlation id should be POAPPRV:%.

For R12 , the correlation id should be POAPPRV:%

9. Complete rest of the configuration and Finish to Save.

10. Stop and re-start the Workflow Notification Mailer to test.

Note: A separate custom notification mailer must be created for each workflow Item type / process as the "Correlation ID" does not allow to choose multiple values.  This is by design

To Know the OVERVIEW of WF below Images:

How to mass change Mail Preferences for FND USERS (Doc ID 451929.1)

Direct table updates are not supported.  Please ensure to perform a backup prior to making any changes reflected in this document.

Using sqlplus as the apps user:

Step 1). SQL> update wf_local_roles set notification_preference = 'MAILHTML' where user_flag='Y';

Step 2). SQL > update fnd_user_preferences set preference_value = 'MAILHTML'  where module_name = 'WF' and preference_name = 'MAILTYPE';

Step 3). SQL> commit

+++++++++++++++++

Notify Function When Running Concurrent Request Not Sending Notification to User (Doc ID 1370390.1)

Backup WF_LOCAL_ROLE Table before doing update:

SQL> update wf_local_roles set email_address='svr.snr@singiri.com' where name='SYSADMIN';

commit;

SQL> select RECIPIENT_ROLE,status,mail_status,MESSAGE_NAME from apps.wf_notifications where begin_date>sysdate-1

++++++++++++++++++++++++
How to remove all the emails from wf_local_roles table:
SQL> update wf_local_roles set email_address = null where email_address is not null;
             90786 rows updated.

SQL> select name, email_address from wf_local_roles where email_address is not null;
             no rows selected

SQL> commit;

++++++++++Manjunatha++++++++++

Note: Doc ID 786647.1

NOTE:415723.1 - Configuring A Notification Mailer Based On A Specific Item Type.

NOTE:561435.1 - How to Check if Custom Dedicated Notification Mailers have been Defined?