How to Check and Update Email Addresses for Workflow Notifications in Oracle EBS

Step 1: Verify the User’s Email Address in FND_USER

Run the following query to check if the user has a valid email address assigned in FND_USER:

SELECT user_name, email_address, employee_id FROM fnd_user WHERE user_name LIKE 'KUMAR';

If the email_address is missing or incorrect, update it using the System Administrator responsibility:

Navigate to System Administrator → Security → User → Define

Search for the user and update the email address

Step 2: Check User Preferences and Email Address in WF_ROLES

The WF_ROLES table determines User preferences for workflow notifications. Run the following query:

SELECT name, email_address, NVL(WF_PREF.get_pref(name, 'MAILTYPE'), notification_preference) AS preference FROM wf_roles WHERE name = UPPER('KUMAR');

If preference is MAIL or MAILHTML, email notifications should be sent.

If the email_address is missing, proceed to the next step.

Step 3: Update the Email Address in WF_LOCAL_ROLES

If the email is missing in wf_roles view, update it using the following query:

UPDATE applsys.wf_local_roles SET email_address = 'kumar@xxxx.xxx' WHERE name = 'KUMAR';

COMMIT;