Send Emails To Non Oracle Apps s Through 2y3i4t

Send emails to non Oracle Apps s through workflow Emails can be sent to persons or organizations external to Oracle apps. For instance suppliers or customers might need certain notifications from Oracle after a certain approval process. The approval process is handled by workflow. Workflows send out emails to Oracle apps s as they are configured within Oracle. Workflow can send emails to external email addresses as well. We only need to configure it. The following code can be used to create the workflow role for the external email address. This is done because the workflow has to send a notification which will then be interpreted by the email server and sent out as an email. The workflow role will contain the email address. 1 DECLARE 2 v_chk_role NUMBER; 3 v_cc_email VARCHAR2 (100) := '[email protected]') 1

select * from wf__roles where role_name = upper('[email protected]')

After we trigger off the workflow we can check the activity history in workflow monitor, Click on the notification, Note the value of ID in the notification header. This is the notification id which we shall query for in the database and check for the email status. 1 select * from wf_notifications where notification_id = 5455150 The mail_status shows SENT. This means the recipient has received the email.