How to re-send any failed notifications ?

How to re-send any failed notifications ?


- Run "Resend Failed Notifications"  request


UR's Key Run ;-) 

Steps to perform the telnet SMTP test

Steps to perform the telnet SMTP test

1) Identify mailer running node ( which CM node its running )

select target_node
from fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';

SELECT b.component_name,
       c.parameter_name,
       a.parameter_value
FROM fnd_svc_comp_param_vals a,
     fnd_svc_components b,
     fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
     AND b.component_type = c.component_type
     AND c.parameter_id = a.parameter_id
     AND c.encrypted_flag = 'N'
     AND b.component_name like '%Mailer%'
     AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;

2) From mailer node

telnet [outbound_server_name] 25

Clear steps

Ref ID : ID 753845.1


UR's Key Run ;-) 

Check WF Status :

Check WF Status :

$FND_TOP/sql/wfver.sql

- Gives the status of below

Workflow Agent Listener
Workflow Mailer
Workflow Document Web Services

Also,

select fcq.USER_CONCURRENT_QUEUE_NAME Container_Name, DECODE(fcp.OS_PROCESS_ID,NULL,'Not
Running',fcp.OS_PROCESS_ID) PROCID,
fcq.MAX_PROCESSES TARGET,
fcq.RUNNING_PROCESSES ACTUAL,
fcq.ENABLED_FLAG ENABLED,
fsc.COMPONENT_NAME,
fsc.STARTUP_MODE,
fsc.COMPONENT_STATUS
from APPS.FND_CONCURRENT_QUEUES_VL fcq, APPS.FND_CP_SERVICES fcs, APPS.FND_CONCURRENT_PROCESSES
fcp, fnd_svc_components fsc
where fcq.MANAGER_TYPE = fcs.SERVICE_ID
and fcs.SERVICE_HANDLE = 'FNDCPGSC'
and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
and fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
and fcq.application_id = fcp.queue_application_id(+)
and fcp.process_status_code(+) = 'A'
order by fcp.OS_PROCESS_ID, fsc.STARTUP_MODE

UR's Key Run ;-) 

How to Check CM Tier able to reach IMAP Server ???

How to Check CM Tier able to reach IMAP Server ???

telnet <imap_server_name> 143

Ref : ID 741352.1


UR's Key Run ;-) 

How to get confirmed is there any conflicts in Workflow Mailer accounts of TEST/DEV/PROD

Query to get confirmed is there any conflicts in Workflow Mailer accounts of TEST/DEV/PROD

set pagesize 100
set linesize 132
set feedback off
set verify off

col value format a35
col component_name format a30

select c.component_id, c.component_name, p.parameter_id, p.parameter_name, v.parameter_value value
from fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c
where c.component_type = 'WF_MAILER'
and v.component_id = c.component_id
and v.parameter_id = p.parameter_id
and p.parameter_name in ( 'INBOUND_SERVER','ACCOUNT', 'REPLYTO')
order by c.component_id, c.component_name,p.parameter_name;


UR's Key Run ;-) 

Inbound Flow

Troubleshooting Inbound Email Notifications [ID 1184846.1]


Beautiful note with below info :

- Inbound Flow
- External Setup and Influences on the IMAP account
- Mailer configuration
- How to clean out the IMAP account
- Cloning Activities


UR's Key Run ;-) 

How to clean out the IMAP account ???

How to clean out the IMAP account ???

1. Shut down the Mailer.
2. Using any desktop IMAP client such as Outlook, logon to the imap account and review the contents of the inbox. Remove any spam messages from the inbox.
3. Use the IMAP client tools to delete and purge excess messages from Process and Discard Folders.
4. When the account is cleaned up, log off of the account

Note : Remove the account from your desktop mail client so that you don’t accidentally automatically log in while the mailer is ever running.

Ref : 1184846.1


UR's Key Run ;-) 

How to check/debug status of a Notification Mssg

How to check/debug status of a Notification Mssg

Run  $FND_TOP/sql/wfmlrdbg.sql for Notification id in issue.


How to get the Notification ID ????????

a) from the body of the message
or
b) from the status monitor / activity history
(drill down to see the notification id at the bottom along with Workflow Type and internal name)


UR's Key Run ;-) 

How to stops the mailer from sending mail to the smtp server.

Set the Outbound Threads to 0.  This stops the mailer from sending mail to the smtp server.

Edit Notification Mailer ->  Advanced

Set "Outbound Threads" to 0
then
Finish.

For alternate ways ref  Note ID : 828812.1


UR's Key Run ;-) 

How to Setup an override Address for WF

U can setup an override Address for WF notifications, so that it will automatically route all outbound email to one address.

How ???

OAM -> Workflow Manager -> Notification Mailer / Select  Mailer / View Details.

- Select 'Set Override Address' button

- Provide the email ID here

UR's Key Run ;-) 

Approval Links In Wf Notification Emails Are Pointing To Wrong Server

Approval Links In Wf Notification Emails Are Pointing To Wrong Server

Error :
Page cannot be displayed

When attempting to view a notification via email by clicking on the link

Fix : Check  "HTML Agent" is pointing to MT

System Adminstrator >Workflow Manager >Notification Mailer > Edit > Advance

Set HTML Agent to http://hostname.domainname:8088/pls/sid

if works change the things accordingly in xml/context file

UR's Key Run ;-) 

Inbound Processing failing While Approving/Rejecting From Emails

Inbound Processing failing While Approving/Rejecting From Emails

Error : INBOUND SERVER unable to make a network connection

Effect: Response email lies in the INBOX folder of mailer and does not move further.

Cause : This happens mostly after a Clone/ Refresh, when all DEV/TEST/PROD sharing the same IMAP account and also have the same mailer node name.
        As a result the mail will be down with error.

Fix   :

It is recommended that each workflow mailer have its own dedicated IMAP account to prevent any locking issues.
In a scenario where multiple instances are sharing the same IMAP account, Its always recommended to have diff mailer node names for all the mailers.

- Run this in all the instances to make sure whether all instances sharing same mailer node names or diff

select SC.COMPONENT_NAME, v.PARAMETER_DISPLAY_NAME, v.parameter_name,
v.PARAMETER_VALUE
from FND_SVC_COMP_PARAM_VALS_V v, FND_SVC_COMPONENTS SC
where v.COMPONENT_ID=sc.COMPONENT_ID
and v.parameter_name in ('NODENAME','ACCOUNT')
order by sc.COMPONENT_ID, v.parameter_name;

- In case they are sharing the same...then need to edit the mailer configuration parameters.
OAM-> Workflow manager ->  Notification Mailers -> Edit
- Change the mailer Node name in either of the instance TEST/PROD
- Bring up mailer once changed
- Check the inbound processing works fine
- In Case..still issue exists then go for a dedicated IMAP account to each mailer.

Ref : ID 418931.1


UR's Key Run ;-) 

Get Notification Emails in a diff Languages other than English

Get Notification Emails in a diff Languages other than English

Steps :
1) Set "default application language" to desired lang

Login -> Preferences -> Default Application Language to Desired Lang

Apply

This should make the same to reflect in "ICX: Language" personal profile option and also in wf_local_roles table

select language
from wf_local_roles
where name = 'User_Name';

2) System Administrator -> Workflow ->  Service Components -> Workflow Notification Mailer + Edit
-> Advanced configuration and press next till you get Reset NLS parameter
-> Check Reset NLS check box
 Apply changes

- Restart Mailer


UR's Key Run ;-) 

PROCESSED or DISCARD folder

Once the mailer has finished with the processing of the inbound email responses to notifications, it will move those items to the PROCESSED or DISCARD folder of the IMAP account, to make way for more inbound items.
The mails in these folders need to be deleted manually or you can set a rule to delete the old ones automatically based on the rule defined.


UR's Key Run ;-) 

Workflow Mailer Failing to Send Notifications Emails for Some Employees

Workflow Mailer Failing to Send Notifications Emails for Some Employees :

Findings : WF_NOTIFICATIONS.status is "FAILED" for some notifications.
Cause    :

Since workflow was not able to parse the file names with special characters, the notifications with attachments were not emailed.
However, the same notification using file names without special characters works fine.

Sol :

Upgrade Application to recent levels

or

Workaround : don't use special characters in the file names

Refer :  [ID 1305894.1]


UR's Key Run ;-) 

Workflow Notifications not cmg - Troubleshooting flow

Troubleshooting WF Notification Email In/Outbound :

- 1st need to check is that notification itself is created / Not ?
- Check status & mail_status in wf_notifications for that particular recipient ( where recipient_role like '&user_name'; )
- Check for valid email addr of recipient in wf_roles

SELECT email_address,
nvl(WF_PREF.get_pref(name, 'MAILTYPE'), notification_preference)
FROM wf_roles
WHERE name = '&recipient_role';

Recipient can receive email notification only if
-- notification preference is not set 'QUERY' / 'DISABLED' / 'SUMMARY' / 'SUMHTML'      &
-- recipient has valid email address

- Check Workflow Service Components are up and running.

Workflow Deferred Agent Listener
Workflow Deferred Notification Agent Listener
Notification Mailer

Flow :

Send Event Raised -> Enqueued to WF_DEFERRED Queue --> Processed by Deferred Agent Listener -->
Enqueued to WF_NOTIFICATION_OUT Queue --> Processed by Notification Mailer and sent as e-mail

Any error occurs during dispatch of oracle.apps.wf.notification.send, the message is enqueued to WF_ERROR queue

-  @$FND_TOP/sql/wfmlrdbg.sql for notification id and check the status of the message in WF_DEFERRED and WF_NOTIFICATION_OUT queue.

PROCESSED in WF_DEFERRED - The message is enqueued to WF_NOTIFICATION_OUT
PROCESSED in WF_NOTIFICATION_OUT - The message is sent as e-mail
READY in WF_DEFERRED - Check if Deferred Agent Listener is running
READY in WF_NOTIFICATION_OUT - Check if Notification Mailer is running

Ref : 831982.1

UR's Key Run ;-)