openssl s_client -connect outlook.office365.com:995 < /dev/null | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > public.crt
keytool -import -alias outlook.office365.com -keystore $AF_JRE_TOP/lib/security/cacerts -file public.crt
keytool -list -keystore $AF_JRE_TOP/lib/security/cacerts
Test the mail connection:
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=outlook.office365.com -Dport=993 -Dsecurity=TLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=xxxxx -Dpassword=xxxxx -Dfolder=Inbox -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=IMAPSSLTest.log oracle.apps.fnd.wf.mailer.Mailer >>IMAPSSLTest.txt
Two files will be generated:
IMAPSSLTest.log
IMAPSSLTest.txt
--------------------------------------------------------
Mailer status has to be changed in order to start the mailer
update fnd_svc_components
set component_status = 'DEACTIVATED_SYSTEM'
where component_id = 10006
Then start the mailer from UI - Workflow Manager
update fnd_svc_components
set component_status = 'DEACTIVATED_SYSTEM'
where component_id = 10006
Then start the mailer from UI - Workflow Manager
------------------------------------------------------------------------------
Catch up current workflow mailer log file:
SELECT fcp.logfile_name
FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup
WHERE concurrent_queue_name in ('WFMLRSVC')
AND fcq.concurrent_queue_id = fcp.concurrent_queue_id
AND fcq.application_id = fcp.queue_application_id
AND flkup.lookup_code=fcp.process_status_code
AND lookup_type ='CP_PROCESS_STATUS_CODE'
AND meaning='Active';
FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup
WHERE concurrent_queue_name in ('WFMLRSVC')
AND fcq.concurrent_queue_id = fcp.concurrent_queue_id
AND fcq.application_id = fcp.queue_application_id
AND flkup.lookup_code=fcp.process_status_code
AND lookup_type ='CP_PROCESS_STATUS_CODE'
AND meaning='Active';
----------------------------------------------------------------------------------------
Change parameters from backend:
sqlplus apps/apps @$FND_TOP/sql/afsvcpup.sql
--------------------------start wf from backend
DECLARE
p_retcode NUMBER;
p_errbuf VARCHAR2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
BEGIN
SELECT component_id
INTO m_mailerid
FROM fnd_svc_components
WHERE component_name ='Workflow Notification Mailer';
fnd_svc_component.start_component (m_mailerid,
p_retcode,
p_errbuf
);
COMMIT;
END;
/
--------------------------STOP wf from backend
DECLARE
p_retcode NUMBER;
p_errbuf VARCHAR2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
BEGIN
SELECT component_id
INTO m_mailerid
FROM fnd_svc_components
WHERE component_name ='Workflow Notification Mailer';
fnd_svc_component.stop_component (m_mailerid,
p_retcode,
p_errbuf
);
COMMIT;
END;
/
------------------------- Find current mailer status
SELECT component_status
FROM fnd_svc_components
WHERE component_id =(SELECT component_id
FROM fnd_svc_components
WHERE component_name ='Workflow Notification Mailer');
SELECT component_status
FROM fnd_svc_components
WHERE component_id =(SELECT component_id
FROM fnd_svc_components
WHERE component_name ='Workflow Notification Mailer');
RUNNING
STARTING
STOPPED_ERROR
DEACTIVATED_USER
DEACTIVATED_SYSTEM
STARTING
STOPPED_ERROR
DEACTIVATED_USER
DEACTIVATED_SYSTEM
