Core Workflow - EBS (MOSC)

MOSC Banner

How to find email text associated with workflow notification_id?

edited Sep 7, 2016 9:59AM in Core Workflow - EBS (MOSC) 2 commentsAnswered ✓

Hello,

We are going to follow document 372933.1, stop the worflow mailers, and do an update like below:

   update   wf_notifications
   set      mail_status = 'SENT', status = 'CLOSED'
   where    mail_status = 'MAIL'
   and message_name in
         ('OTA_CLS_RESCHEDULE_LRNR_EMB'
         ,'OTA_CERT_ENROLL_LRNR_MSG'
         ,'OTA_BULK_ENR_NTF_MSG_EMB'
         ,'OTA_CERT_COMPLETION_MSG'
         ,'OTA_LNR_NTF_ENR_STATUS_NO_EMB'
         ,'OTA_LNR_NTF_ENR_STS_OA_NO_EMB');

We want to be extra confident that we are only updating workflows for particular certificates, that will be named in the email header or text.

Is there a table we can link to the wf_notifications table to read the email header/body?

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