Oracle EBS Workflow Notification Mailer with Cloud E-Mail Servers

Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers (Doc ID 2077434.1)

How to set Workflow Mailer Override Address from Backend ? (Doc ID 1533596.1)

Query to get the workflow notification mailer logfile to troubleshoot issues.

select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','mailer container','WFALSNRSVC','listener container',fcq.concurrent_queue_name) "CONTAINER",
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;


Inbound Connection Setup

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap1.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap2.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap3.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap4.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap5.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap6.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap7.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap8.log 2>&1