Saturday, December 17, 2016

check last email sent from oracle EBusiness Suite

Query to check the last email sent from oracle Ebusiness suite


select to_char(max(begin_date),'DD-MON-YY HH24:MI:SS')
 from apps.wf_notifications
 where mail_status = 'SENT';

No comments:

Post a Comment