Configuring R12 Workflow Mailer’s SMTP server to send mails to all domains through telnet

1. Unable to send to the mails for any domain except the client’s domain

2. When looked into the log file FNDCPGSC***.txt ($APPLCSF/$APPLLOG), found out the following error,

Oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.send(Message)]:Problem encountered when sending to {[["ADDRESS.DOMAIN.COM.AMERICAN" ]]} -> javax.mail.SendFailedException: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable to relay
oracle.apps.fnd.wf.mailer.SMTPMessageHandler.sendMessages(String)]:SendFailedException -> [["ADDRESS@DOMAIN.COM.AMERICAN" ]] javax.mail.SendFailedException: Invalid Addresses; nested exception is: class Javax.mail.SendFailedException: 550 5.7.1 Unable to relay

3. Confirmed the same by checking the wf_notifcations table and the mails sent to the id’s outside the clients domain failed with status “FAILED” (Testes Purchase Orders to Suppliers, Workflow Test Mail, Forgot Your Password Functionality)

4. Tried to login the user through telnet and got the same error and confirmed that this is something to do with SMTP server
[applprod@perp log]$ telnet webmail.domain.in 25
Trying 192.168.1.7...
Connected to webmail.domain.in (192.168.1.7).
Escape character is '^]'.
220 EXCHMAILSERVER1.domain.in Microsoft ESMTP MAIL Service ready at Fri, 2 Jan 2009 15:36:26 +0530
HELO
250 EXCHMAILSERVER1.domain.in Hello [192.168.1.40]
MAIL FROM: wfmailer@domain.in
250 2.1.0 Sender OK
RCPT TO: address@domain.com
550 5.7.1 Unable to relay

5. The issue has been given in the notes # 374804.1, 304582.1 and 753845.1, requested the mail administrator to set the SMTP mail server to allow relaying, that is sending mail to an outside domain from that server (192.168.1.40)

6. Restarted the “Workflow Notification Mailer” through Oracle Applications Manager

7. Once done checked the notifications from purchase orders to supplier and Forgot Your Password link with other domain’s mail-id started working fine

Issue when configuring Workflow Mailer with IMAP and POP enabled in MS-Exchange server 2008

1. While configuring the R12 workflow mailer, the following are the details given,

Inbound(IMAP) - webmail.domain.in 143

Outbound(SMTP) - webmail.domain.in 25

Inbound (POP3) - webmail.domain.in 110

2. The Outbound server has been configured successfully

3. The webmail server's IP has been added in /etc/hosts

4. While trying to configure the Inbound, stuck with the error even the details given are correct

Check the hostname, username and password

Hostname - webmail.domain.in

username - wfmailer

Password – password

5. Then came to know that for inbound they are using both IMAP and POP3

6. Changed the user settings of WFAMILER to use only IMAP

7. Even after that it errors out, but telnet to IMAP and SMTP is successful

$ telnet webmail.domain.in 143

$ telnet webmail.domain.in 25

8. Then with reference to note # 242941.1, tried the following to connect from the user WFMAILER,

$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX 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: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 LOGINDISABLED STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 BAD Command received in Invalid state.

9. After searching, came to know that the LOGIN is disabled through telnet causing the issue

10. With reference to the note # 333074.1 , with the help of network admin executed the following,

- Checked "SASL Authentication" enabled in EM Websites for the IMAP instance.

- Leave the "Allow Clear Text Login" as is, "True".

- Bounced IMAP

11. Then tried login from telnet and it worked fine,

$AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap -Ddbcfile=$INST_TOP/appl/fnd/12.0.0/secure/CRP.dbc -Dserver=webmail.domain.in -Dport=143 -Daccount=wfmailer -Dpassword=password -Dconnect_timeout=120 -Dfolder=INBOX 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: setDebug: JavaMail version 1.3.1
DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
DEBUG: mail.imap.fetchsize: 16384
* OK The Microsoft Exchange IMAP4 service is ready.
A0 CAPABILITY
* CAPABILITY IMAP4 IMAP4rev1 AUTH=NTLM AUTH=GSSAPI AUTH=PLAIN STARTTLS IDLE NAMESPACE LITERAL+
A0 OK CAPABILITY completed.
A1 LOGIN wfmailer password
A1 OK LOGIN completed.
A2 NOOP
A2 OK NOOP completed.

12. Then configured the inbound and its configured successfully without any issues