Logo Background

How To Test Oracle Workflow Mailer

  • By on June 8, 2009 | No Comments

    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.
    Previous
    Next
    » CPIO Command
Leave a Comment