workflow - email

[satish]

Hi Erman,

When we are unable to send email when we try to run test mailer and subsequently we could see the user preference is setting to disabled.We have enabled statement level logging and attached the log for review.
Can you please help.

Thank youworkflow.txt

[satish]

Hi Erman,

Can a user have multiple roles in wf_local_roles table with active status.For example, orig_system as PER,PER_ROLE and HZ_PARTY.Do we need have same email adress in fnd_user,per_all_people_f and hz_parties tables.please confirm we are unable to sort out the issue

Here,it is saying multiple roles should not be active

http://oracleappsdna.com/2011/09/workflow-email-notifications-not-working-for-a-particular-user/

In our case,user has 3 roles active per,per_Role and hz_parties and this user is unable to recieve email

Thank you

[ErmanArslansOracleBlog]

That disabling can be caused the ntf mailer's inability to send emails to those users.
ıt must be notificaiton mailer making the user's mail preference to be set to DISABLED..
Notification mailer does that if it can't send an email to that user. Especially, if Mailer encounters a problem queuing its emails to the Mail Server, It marks the status of the notification as  FAILED, and makes the mail preference of the related user to be set to DISABLED..

Check the user's email adress in all possible places, as well as the ntf mailer's log for catching any other errors related with the ntf mailer's inability to send emails to those users.

Read this -> https://ermanarslan.blogspot.com/2014/08/ebs-workflow-notification-mailer.html

[satish]

Dear Erman,

Actually my doubt is Can a user have multiple roles in wf_local_roles table with active status.For example, orig_system as PER,PER_ROLE and HZ_PARTY.

Thank you

[ErmanArslansOracleBlog]

are the values of the name column exactly the same for these 3 records?
what is the values of user_flag column?

[satish]

Hi Erman,

Thanks for the update.

Please find the attached output

Active_roles.xlsx

We are referring to user in 4,5 and 14.we are doing test mailer for 14 HZ_PARTY:18937 and the mailer could not send it and finally it is making the status to disabled.

Thank you

[ErmanArslansOracleBlog]

It seems two roles can exist in workflow for a user/employee in EBS. Check tihs blog post -> https://keithturley.wordpress.com/2010/12/01/workflow-roles-and-userperson-synchronization/

Is the email adress and the domain of that role (HZ_PARTY:18937)  correct ?
Is your mail server configured to be able to send emails to that domain?

[ErmanArslansOracleBlog]

Any errors in the worflow mailer's log? (take it to statement level and reproduce the issue.. Then check the log)

[satish]

Dear Erman,

Thanks for the updates.


1)Is the email adress and the domain of that role (HZ_PARTY:18937)  correct ?

Yes

2)Is your mail server configured to be able to send emails to that domain?

Application team updated that they are able to receive emails to this domain from cofigured alerts in r12.But recently,they are not receiving them.

Enabled statement level logging and found the below error.In detail attached.

[Apr 27, 2020 3:35:04 PM IST]:1587981904626:-1:-1:node1.domain.com:10.0.2.8:-1:-1:1:20420:SYSADMIN(0):-1:Thread
[outboundThreadGroup1,5,outboundThreadGroup]:10.0.2.8:7353:1587977504430:6:ERROR:[SVC-GSM-WFMLRSVC-155357-10006 :
 oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[[[e-mail]],
 [[e-mail]], [[e-mail]]]} -> javax.mail.SendFailedException: Invalid Addresses;
  nested exception is:
        class javax.mail.SendFailedException: 554 This server requires PTR for unauthenticated connections.
  nested exception is:

But the vendor claims that they have updated PTR record in their SMTP server.Not sure what and where to look at in this case.please suggest.We are able to send mails to other domains like gmail etc..domain.com is our internal domain

exception.txt

Thank You

[ErmanArslansOracleBlog]

your email server can not send the emails to @domain.com.
That's obvious.
The error is clear . It is "554 This server requires PTR for unauthenticated connections"
If the email adress reported in the log is correct, then the fix for your problem is in the Mail Server config.

[satish]

Hi erman,

Is this something a smtp server admin has to look into it? Or an apps dba has to check it? Any idea about this error?Application team said they are able to receive emails earlier


Thank you

[ErmanArslansOracleBlog]

Again, if the email that you see in the log is correct, then mail server admin should check it on the mail server side.