WF_NOTIFICATIONS-> mail_satus is NULL and Status-> CLOSED but email is not Sent , Can you please let
Hi
We have PO approved Notification, where WF_NOTIFICATIONS table -> mail_satus is NULL
and Status-> CLOSED but email is not Sent , Can you please let me know, where I need to define email ?
I looked fnd_user-> email is there in the System Admintstartor Resp. but when I ran it's not bringing email,
Can you please let me know with Navigation, where I need to change or add ?
SQL> SELECT email_address,
2 nvl(WF_PREF.get_pref(name, 'MAILTYPE'),notification_preference)
3 FROM wf_roles
4 WHERE name = 'TKERBER';
EMAIL_ADDRESS
--------------------------------------------------------------------------------
NVL(WF_PREF.GET_PREF(NAME,'MAILTYPE'),NOTIFICATION_PREFERENCE)
1