fnd_user, per_all_people_f and wf_local_roles.
wf_notifications and wf_users contains the email address.
Thank you for your prompt response Taylor,
from the mentioned 3 tables, is it going to take email address from 3 tables based on any priority ?
because, in those 3 tables we will have email address. So how the workflow will look for email address to send notifications?
1 person found this helpful
The notification will be sent to the email address stored in wf_local_roles. If it comes from fnd_user or per_all_people_f (or hz_parties) depends on how the user is defined and if a supplier or party is attached.
If I want to test email notifications in Vision for example, and I have an email address I can access, I would do the following updates:
update fnd_user set email_address = 'email@example.com' where user_name
update per_all_people_f set email_address = 'firstname.lastname@example.org'
where person_id = (select employee_id from fnd_user where user_name = 'SERVICES'
set email_address = 'email@example.com'
where name = 'SERVICES'
Then send a test notification from Oracle Applications Manager Workflow section to SERVICES and it would go to that email address if SMTP outbound workflow notifications are properly configured.
Thanks a lot Michael,
After few studies, came to know that if email address is correctly located in WF_LOCAL_ROLES Table, then Workflow notifications will go fine.
To update WF_LOCAL_ROLES table we must have email addresses correctly in FND_USER. Once Workflow sync is happened correctly, then email addresses from FND_USER will be updated in WF_LOCAL_ROLES automatically.
in FND_USER table we can update emails in two ways.
1. If employee table have correct email address in PER_ALL_PEOPLE_F Table, then we can assign that person to appropriate User in FND_USER. So automatically Email Address from PER_ALL_PEOPLE_F is loaded to FND_USER table.
2. We can automatically update the email address in FND_USER table.