How To Test Oracle Workflow MailerHow To Test Oracle Workflow Mailer
If you are running on Oracle E-Business Suite Applications 11i, then you should know one of the mailer in Oracle was Workflow Mailer.
Oracle Workflow Mailer sometimes do have problem where they were not able to send and receive e-mail from their outlook mailbox.
For your info, the DBC file was required when you run the test case as below and usually it was stored in $FND_TOP/secure
Testing SMTP Connectivity
This is the script that you may run in your Apps Tier to test on the SMTP connection
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp \ -Ddbcfile=<full path to dbc file>.dbc \ -Dserver=<SMTP server host.domain> -Dconnect_timeout=120 -Ddebug=Y \ -Daccount=<SMTP username or fake name> \ -Dpassword=<SMTP passwd or fake passwd> \ -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer
Example: -
$ $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp \ -Ddbcfile=/oracle/apps/secure/oracle.dbc \ -Dserver=smtp-oracle.workflow.com -Dconnect_timeout=120 -Ddebug=Y \ -Daccount=test \ -Dpassword=test \ -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer MLRTST : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started. DEBUG: getProvider() returning javax.mail.Provider [TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun Microsystems, Inc] DEBUG SMTP: useEhlo true, useAuth false DEBUG: SMTPTransport trying to connect to host "smtp-oracle.workflow.com", port 25 DEBUG SMTP RCVD: 220 mailer.oracle.workflow.com ESMTP Postfix DEBUG: SMTPTransport connected to host "smtp-oracle.workflow.com", port: 25 DEBUG SMTP SENT: EHLO oracle.apps.com DEBUG SMTP RCVD: 250-mailer.oracle.workflow.com 250-PIPELINING 250-SIZE 250-ETRN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN DEBUG SMTP Found extension "PIPELINING", arg "" DEBUG SMTP Found extension "SIZE", arg "" DEBUG SMTP Found extension "ETRN", arg "" DEBUG SMTP Found extension "ENHANCEDSTATUSCODES", arg "" DEBUG SMTP Found extension "8BITMIME", arg "" DEBUG SMTP Found extension "DSN", arg "" DEBUG SMTP SENT: QUIT
Testing IMAP Connectivity
This is the script that you may run in your Apps Tier to test on the IMAP connection
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \ -Ddbcfile=<full path to dbc file>.dbc \ -Dserver=<IMAP server host.domain> -Dconnect_timeout=120 -Ddebug=Y \ -Daccount=<IMAP username or fake name> \ -Dpassword=<IMAP passwd or fake passwd> \ -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer
Example: -
$ $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \ -Ddbcfile=/oracle/apps/secure/oracle.dbc \ -Dserver=imap-oracle.workflow.com -Dconnect_timeout=120 -Ddebug=Y \ -Daccount=test \ -Dpassword=test \ -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer DEBUG: getProvider() returning javax.mail.Provider [STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc] * OK Microsoft Exchange Server 2003 IMAP4rev1 server version 6.5.7638.1 (imap.oracle.workflow.com) ready. A0 CAPABILITY * CAPABILITY IMAP4 IMAP4rev1 IDLE LOGIN-REFERRALS MAILBOX-REFERRALS NAMESPACE LITERAL+ UIDPLUS CHILDREN A0 OK CAPABILITY completed. A1 LOGIN test test A1 NO Logon failure: unknown user name or bad password.
Leave a Comment
Recent Comments