Core Workflow - EBS (MOSC)

MOSC Banner

WF_NOTIFICATIONS-> mail_satus is NULL and Status-> CLOSED but email is not Sent , Can you please let

edited Jan 24, 2020 2:10AM in Core Workflow - EBS (MOSC) 13 commentsAnswered ✓
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center