Notification Mailer Setup with GMAIL

1038794

    Hi,

     

    I am working on Oracle Application R12.2.

     

    I have created an SMTP server on MS Windows 2008 R2. Its connected to a Gmail account and is working fine. When I am testing the Windows SMTP, its sending email to any email address.

    I have setup Oracle Notification Mailer and have given reference of my Windows Server IP in the Outbound SMTP Server Name alongwith Gmail account credentials and Inbound IMAP is having Gmail IMAP and Gmail account credentials. Notification Mailer has authenticated the settings and its in running state.

     

    When I am testing the notification mailer using a 'Test Mailer', its not sending email to a selected user. I have tried testing it multiple times but not getting email notification.

     

    Please find below the Notification Mailer log:

    *********************************************************************************************************************

    [Jul 22, 2016 4:23:33 PM AST]:1469193813012:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(): BEGIN/END [Jul 22, 2016 4:23:33 PM AST]:1469193813012:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection(null,0x1bd094b5,false,false,false): : BEGIN [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal(null,0x1bd094b5,true,false,false): : BEGIN [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.borrowConnection(null,0x1bd094b5,false): : BEGIN [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): BEGIN [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.security.AppsConnectionManager]:borrowConnection(Hashtable): END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.borrowConnection: END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: Class null with session_id 0x1bd094b5 borrowed a Connection from the pool. [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal: END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.getJDBCConnection: END: returning oracle.jdbc.driver.T4CConnection@1bd819c5 [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(): BEGIN/END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@1bd819c5): : BEGIN/END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@1bd819c5,0x1bd094b5): : BEGIN/END [Jul 22, 2016 4:23:33 PM AST]:1469193813013:-1:-1:ora2.tawail.com:10.1.1.120:-1:-1:-1:-1:ANONYMOUS(-1):-1:Thread[Cache Stats Writer,5,main]:10.1.1.120:87694:1469077425719:21:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.releaseJDBCConnection(oracle.jdbc.driver.T4CConnection@1bd819c5,0x1bd094b5): : (pConn == mConn) is true, isSplCtx is false, switchGenSol is false

    ***************************************************************************************************************************************

     

    Please help me to resolve this issue. Its a Production environment.

     

    Thanks.