WordPress.com



WORKFLOW MAILER CONFIGURATIONWorkflow Mailer Configuration SSL Implementation [Video] (Doc ID 1324799.1)Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers (Doc ID 2077434.1)Configuring Oracle E-Business Suite Workflow Mailer with TLS for Microsoft Office365, Gmail, or Cloud Based Email Services for 12.1.3 and 12.2 (Doc ID 2051827.1)Point 1:- SMTP certificate “xxxxx.crt “Point 2:- Import SMTP certificate password “ xxxx ”apltmprd@ebsapps[/home/apltmprd]#keytool -import -alias mycertnew –.crt -keystore $AF_JRE_TOP/lib/security/cacerts -storepass xxxxCertificate was added to keystorePoint 3:- Check SMTP connection “ ip=xxxxx Port = 25 Dsecurity=NONE “$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc \-Dserver=xxxxxxx -Dport=25 \-Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle_alert@ \-Dpassword=xxxxx \-Dconnect_timeout=120 -Ddebug=Y -Dlogfile=SMTPTLSTest.log oracle.apps.fnd.wf.mailer.MailerLog file :-[Feb 26, 2017 11:22:00 AM GMT+03:00]:1488097320924:-1:-1:xxxxxx:xxxxxx:-1:-1:1:20420:SYSADMIN(0):-1:Thread[main,5,main]:10.255.220.34:62089:1488097319904:2:EXCEPTION:[MLRTST : oracle.apps.fnd.wf.mailer.MailerUtils.hostConnectionTest(WorkflowContext, Logger, Properties)]:Server {xxxxxx} at port {25} is reachable[Feb 26, 2017 11:22:00 AM GMT+03:00]:1488097320931:-1:-1:xxxxxx:xxxxxx:-1:-1:1:20420:SYSADMIN(0):-1:Thread[main,5,main]:10.255.220.34:62089:1488097319904:2:STATEMENT:[MLRTST : oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger, Properties)]:The OUTBOUND SECURE protocol property -> {NONE}[Feb 26, 2017 11:22:00 AM GMT+03:00]:1488097320932:-1:-1:xxxxxxxx:-1:-1:1:20420:SYSADMIN(0):-1:Thread[main,5,main]:10.255.220.34:62089:1488097319904:2:EXCEPTION:[MLRTST : oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger, Properties)]:Debug property -> {true}[Feb 26, 2017 11:22:01 AM GMT+03:00]:1488097321984:-1:-1:xxxxxxxxxx:-1:-1:1:20420:SYSADMIN(0):-1:Thread[main,5,main]:10.255.220.34:62089:1488097319904:2:EXCEPTION:[MLRTST : oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger, Properties)]:Successfully connected to the SMTP accountPoint 4:- Configure SMTP passwordapltmprd@ebsapps[/home/apltmprd]#sqlplus apps/apps @wfmlrpwupd_out.sqlSQL*Plus: Release 10.1.0.5.0 - Production on Sat Feb 25 11:53:13 2017Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsEnter value for password: xxxxxEnter value for componentid: 10006Point 5:-Deactivate Workflow Notification MailerSQL> update fnd_svc_componentsset component_status='DEACTIVATED_USER'where component_name='Workflow Notification Mailer';1 row updated.SQL> commit;Point 6:- Set workflow SMTP Parameters value.Outbound Server Name = xxxxxOutboundUser = oracle_alert@Outbound Security Protocol = NONEReply-to Address = oracle_alert@Username = oracle_alert@Inbound Thread Count = 0Point 7 :- Start SMTP workflow services.SMTP working finePoint 8 :- Configure IMAP serverStop workflow mailer services.SQL> @$FND_TOP/sql/afsvcpup.sqlInbound Server Name = ip:143Inbound Thread Count= 1SQL> update fnd_svc_components set component_status='DEACTIVATED_USER' where component_name='Workflow Notification Mailer';commit;Start workflow services.########################### IMAP & SMTP working fine ############################### ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download