Note: 748421.

1
Test Version: v12.0
Machine: nrbvpebsas01
Date Run: Sun Sep 18 02:19:04 EDT 2022
Oracle Info: ORACLE_HOME: /u01/R122PROD/fs1/EBSapps/10.1.2; TWO_TASK: R12PROD
APPL_TOP: /u01/R122PROD/fs1/EBSapps/appl

ATTENTION - This is a web node but the "APACHE_TOP" cannot be located

Oracle Workflow ATG Support: R12 Java Mailer Setup Diagnostic Test

Note: 748421.1
Test Version: v12.0
Machine: nrbvpebsas01
Date Run: Sun Sep 18 02:20:17 EDT 2022
Oracle Info: ORACLE_HOME: /u01/R122PROD/fs1/EBSapps/10.1.2; TWO_TASK: R12PROD
APPL_TOP: /u01/R122PROD/fs1/EBSapps/appl
Apps Version: 12.2.10

Product Status

Application Name Short Installed? App Id Patchset

---------------------------------------- -------- ---------- ------ ----------
Applications DBA AD Shared 50 R12.AD.C.1
2

Application Object Library FND Yes 0 R12.FND.C.

9

System Administration SYSADMIN Yes 1

Technology Stack Requirements

-----------------------------
WARNING - Version 12.2.10 of Oracle Applications detected
ACTION - This diagnostic test was tested with 11.5.3 - 12.1, not version
12.2.10

Database Name "R12PROD" in v$database

The PRODCDB database was created on 22-NOV-21
Database version is 19.0.0.0.0.

XML Parser in APPS Account

XMLVERSION = Oracle XML Developer's Kit null

JDK Requirements
----------------
JDK Version
JDK17_TOP = /u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre
JDK_VERSION = 1.7.0.85

AF_JRE_TOP
AF_JRE_TOP = /u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre
The directory exists on the filesystem

AFJVAPRG
AFJVAPRG =
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
The file exists on the filesystem

AF_CLASSPATH
Current values in AF_CLASSPATH
/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar
/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/tools.jar
/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/rt.jar

/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar

/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/
ebsFMWManifest.jar

/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/
lib/ebsAppsborgManifest.jar

/u01/R122PROD/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar
/u01/R122PROD/fs1/FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar

/u01/R122PROD/fs1/FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-
client.jar
/u01/R122PROD/fs1/EBSapps/comn/java/classes
/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar

/u01/R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar

The following entries must be present:

[JDK17_TOP]/lib/dt.jar
[JDK17_TOP]/lib/tools.jar
[JAVA_TOP]/appsborg2.zip
[JAVA_TOP]

Validate required entries

Entry for "dt.jar" = /u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar
The file exists on the file system
Entry for "tools.jar" =
/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/tools.jar
The file exists on the file system
ERROR - The entry for "appsborg2.zip" does not exist
ACTION - Set the entry for "appsborg2.zip"
Entry for "/u01/R122PROD/fs1/EBSapps/comn/java/classes" =
/u01/R122PROD/fs1/EBSapps/comn/java/classes
The directory exists
Validate other possible entries
Entry for "rt.jar" =
/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/rt.jar
The file exists on the file system
The entry for "charsets.jar" does not exist

Generic Service Manager (GSM)

-----------------------------

FNDSM Status

USER_CONCURRENT_QUEUE_NAME #PROCS #MAXPROCS ENA RUN

-------------------------------------------------- ------ --------- --- ---
Service Manager: NRBVPEBSAS01 1 1 Y Yes
Service Manager: NRBVPDMZAS02 0 0 Y No
WARNING - One or more of the FNDSM processes is not running
ACTION - Please start up all processes / queues. Refer to note 204090.1 -
Generic Service Management and note 177250.1 - Troubleshooting
Generic Service Manager Problems for more information.

GSM Debug Service Status

USER_CONCURRENT_QUEUE_NAME #PROCS #MAXPROCS ENA RUN

-------------------------------------------------- ------ --------- --- ---
Debug Service 0 0 N No
WARNING - The GSM Debug Service is not running

Service Instance Status

USER_CONCURRENT_QUEUE_NAME #PROCS #MAXPROCS ENA RUN

-------------------------------------------------- ------ --------- --- ---
Workflow Agent Listener Service 1 1 Y Yes
Workflow Mailer Service 1 1 Y Yes
Mobile Push Notification Service 1 1 Y Yes
Workflow Document Web Services Service 1 1 Y Yes

Email Setup
-----------
ATTENTION - Please note that autoconfig takes the IMAP parameters from its XML
context file (located under $APPL_TOP/admin) and replaces the ones
set by OAM in the database. Please update the parameters with OAM
using note 231286.1 - Configuring the Oracle Workflow 2.6
Java-based Notification Mailer with Oracle Applications 11i (it
updates context file as well) but verify the parameters also in the
context file (section "oa_workflow_server").

Parameters in Table FND_SVC_COMPONENTS

Workflow Notification Mailer component id = '10006'
Workflow Notification Mailer status = 'RUNNING'
Templates in Table FND_SVC_COMP_PARAM_VALS
Invalid Response Notification (OPEN_INVALID) = 'WFMAIL:OPEN_INVALID'
Outbound Summary Notification (SUMMARY) = 'WFMAIL:SUMMARY'
Outbound Warning Notification (WARNING) = 'WFMAIL:WARNING'

Parameters in Table FND_SVC_COMP_PARAM_VALS

Inbound mail server (INBOUND_SERVER) = 'smtpmail.nrb.inside'
Protocol to be used for inbound response emails (INBOUND_PROTOCOL) =
'imap'
Inbound thread count (PROCESSOR_IN_THREAD_COUNT) = '0'
Inbound mail account username (ACCOUNT) = 'appsr12prod'
Password of mail account (INBOUND_PASSWORD) = '********'
Inbox folder on the inbound server (INBOX) = 'INBOX'
Discard folder on the inbound server (DISCARD) = 'DISCARD'
Process folder on the inbound server (PROCESS) = 'PROCESS'
Outbound mail server (OUTBOUND_SERVER) = 'smtpmail.nrb.inside'
Protocol to be used for outbound notifications (OUTBOUND_PROTOCOL) =
'smtp'
Outbound thread count (PROCESSOR_OUT_THREAD_COUNT) = '5'
The Java Mail (API) version being used by Workflow Mailer
(JAVA_MAIL_API_VERSION) = '1.5.4'
Reply to address for the outbound notifications (REPLYTO) =
'[email protected]'

Test Input Parameters

Inbound mail server (INBOUND_SERVER) = 'smtpmail.nrb.inside'
Inbound mail account username (ACCOUNT) = 'appsr12prod'
Password of mail account (INBOUND_PASSWORD) = '********'
Outbound mail server (OUTBOUND_SERVER) = 'smtpmail.nrb.inside'
Reply to address for the outbound notifications (REPLYTO) =
'[email protected]'

Accounts
The owner of the concurrent managers ('applR12prod') and the java mailer
account ('appsr12prod') are different which is fine

IMAP/SMTP/HTTP Connectivity
---------------------------
The following steps use the input parameters of the test and are based on the
Mailer java program from patch 3265133 (Refer to note 225947.1 - About Oracle
Workflow Mini-pack 11i.OWF.G)

IMAP Connectivity (Inbound Email Processing)

Starting INBOX test. Result of (it can take 30 seconds to finish because of the
timeout parameter):
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
-classpath
"/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar:/u01/R122PROD/fs1/EBSapps/
comn/util/jdk64/lib/tools.jar:/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/
rt.jar:/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-
fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/
shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-client.jar:/u01/R122PROD/fs1/
EBSapps/comn/java/classes:/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar:/u01/
R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar"
-Dprotocol=imap -Dserver=smtpmail.nrb.inside -Daccount=appsr12prod -Dssl=
-Dtruststore=NONE
-Ddbcfile=/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/appl/fnd/12.0.0/secure/
R12PROD.dbc
-Dconnect_timeout=30 -Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer

Starting DISCARD test. Result of (it can take 30 seconds to finish because of
the timeout parameter):
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
-classpath
"/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar:/u01/R122PROD/fs1/EBSapps/
comn/util/jdk64/lib/tools.jar:/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/
rt.jar:/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-
fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/
shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-client.jar:/u01/R122PROD/fs1/
EBSapps/comn/java/classes:/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar:/u01/
R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar"
-Dprotocol=imap -Dserver=smtpmail.nrb.inside -Daccount=appsr12prod -Dssl=
-Dtruststore=NONE
-Ddbcfile=/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/appl/fnd/12.0.0/secure/
R12PROD.dbc
-Dconnect_timeout=30 -Dfolder=DISCARD oracle.apps.fnd.wf.mailer.Mailer

Starting PROCESS test. Result of (it can take 30 seconds to finish because of
the timeout parameter):
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
-classpath
"/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar:/u01/R122PROD/fs1/EBSapps/
comn/util/jdk64/lib/tools.jar:/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/
rt.jar:/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-
fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/
shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-client.jar:/u01/R122PROD/fs1/
EBSapps/comn/java/classes:/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar:/u01/
R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar"
-Dprotocol=imap -Dserver=smtpmail.nrb.inside -Daccount=appsr12prod -Dssl=
-Dtruststore=NONE
-Ddbcfile=/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/appl/fnd/12.0.0/secure/
R12PROD.dbc
-Dconnect_timeout=30 -Dfolder=PROCESS oracle.apps.fnd.wf.mailer.Mailer

[Sep 18, 2022 2:20:21 AM

EDT]:1663482021495:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:93587:1663482021499:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been
successfully started -> Logger{mLog=[$Header: AppsLog.java 120.5.12020000.5
2017/08/08 21:13:07 rsantis ship $ @1487083906
{oracle.apps.fnd.profiles.ExtendedProfileStore@3bdfd344}],mUniqueId=MLRTST,mLevel=1
}
[Sep 18, 2022 2:20:22 AM
EDT]:1663482022507:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:93587:1663482021499:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.MailerUtils.hostConnectionTest(WorkflowContext,
Logger, Properties)]:Server {smtpmail.nrb.inside} at port {143} is reachable
[Sep 18, 2022 2:20:22 AM
EDT]:1663482022514:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:93587:1663482021499:0:STATEMENT:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:The IMAP SECURE protocol property -> {NONE}
[Sep 18, 2022 2:20:22 AM
EDT]:1663482022514:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:93587:1663482021499:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Debug property -> {true}
[Sep 18, 2022 2:20:22 AM
EDT]:1663482022557:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:93587:1663482021499:0:ERROR:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Test did not complete successfully ->
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
Stack Trace
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:729)
at javax.mail.Service.connect(Service.java:386)
at javax.mail.Service.connect(Service.java:245)
at javax.mail.Service.connect(Service.java:194)
at oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(IMAPUtils.java:514)
at oracle.apps.fnd.wf.mailer.Mailer.main(Mailer.java:2062)
Caused by: com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.login(IMAPStore.java:826)
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:703)
... 5 more

[Sep 18, 2022 2:20:24 AM

EDT]:1663482024329:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:55707:1663482024332:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been
successfully started -> Logger{mLog=[$Header: AppsLog.java 120.5.12020000.5
2017/08/08 21:13:07 rsantis ship $ @1487083906
{oracle.apps.fnd.profiles.ExtendedProfileStore@3bdfd344}],mUniqueId=MLRTST,mLevel=1
}
[Sep 18, 2022 2:20:25 AM
EDT]:1663482025340:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:55707:1663482024332:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.MailerUtils.hostConnectionTest(WorkflowContext,
Logger, Properties)]:Server {smtpmail.nrb.inside} at port {143} is reachable
[Sep 18, 2022 2:20:25 AM
EDT]:1663482025347:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:55707:1663482024332:0:STATEMENT:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:The IMAP SECURE protocol property -> {NONE}
[Sep 18, 2022 2:20:25 AM
EDT]:1663482025347:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:55707:1663482024332:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Debug property -> {true}
[Sep 18, 2022 2:20:25 AM
EDT]:1663482025389:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:55707:1663482024332:0:ERROR:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Test did not complete successfully ->
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
Stack Trace
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:729)
at javax.mail.Service.connect(Service.java:386)
at javax.mail.Service.connect(Service.java:245)
at javax.mail.Service.connect(Service.java:194)
at oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(IMAPUtils.java:514)
at oracle.apps.fnd.wf.mailer.Mailer.main(Mailer.java:2062)
Caused by: com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.login(IMAPStore.java:826)
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:703)
... 5 more

[Sep 18, 2022 2:20:27 AM

EDT]:1663482027181:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:57926:1663482027184:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been
successfully started -> Logger{mLog=[$Header: AppsLog.java 120.5.12020000.5
2017/08/08 21:13:07 rsantis ship $ @1487083906
{oracle.apps.fnd.profiles.ExtendedProfileStore@3bdfd344}],mUniqueId=MLRTST,mLevel=1
}
[Sep 18, 2022 2:20:28 AM
EDT]:1663482028193:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:57926:1663482027184:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.MailerUtils.hostConnectionTest(WorkflowContext,
Logger, Properties)]:Server {smtpmail.nrb.inside} at port {143} is reachable
[Sep 18, 2022 2:20:28 AM
EDT]:1663482028201:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:57926:1663482027184:0:STATEMENT:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:The IMAP SECURE protocol property -> {NONE}
[Sep 18, 2022 2:20:28 AM
EDT]:1663482028201:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:57926:1663482027184:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Debug property -> {true}
[Sep 18, 2022 2:20:28 AM
EDT]:1663482028245:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:57926:1663482027184:0:ERROR:[MLRTST
: oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(WorkflowContext, Logger,
Properties)]:Test did not complete successfully ->
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
Stack Trace
javax.mail.MessagingException: No login methods supported!;
nested exception is:
com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:729)
at javax.mail.Service.connect(Service.java:386)
at javax.mail.Service.connect(Service.java:245)
at javax.mail.Service.connect(Service.java:194)
at oracle.apps.fnd.wf.mailer.IMAPUtils.storeTest(IMAPUtils.java:514)
at oracle.apps.fnd.wf.mailer.Mailer.main(Mailer.java:2062)
Caused by: com.sun.mail.iap.ProtocolException: No login methods supported!
at com.sun.mail.imap.IMAPStore.login(IMAPStore.java:826)
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:703)
... 5 more
WARNING - Expected string "folders defined" not found in output
ACTION - Review ATGSuppJavaMailerSetup12_241037_folderlist.txt to see if
folders are listed.

SMTP Connectivity (Outbound Email Processing)

Result of (it can take 30s to finish because of the timeout parameter):
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
-classpath
"/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar:/u01/R122PROD/fs1/EBSapps/
comn/util/jdk64/lib/tools.jar:/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/
rt.jar:/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-
fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/
shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-client.jar:/u01/R122PROD/fs1/
EBSapps/comn/java/classes:/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar:/u01/
R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar"
-Dprotocol=smtp -Dserver=smtpmail.nrb.inside [email protected]
-Ddbcfile=/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/appl/fnd/12.0.0/secure/
R12PROD.dbc-Dconnect_timeout=30
oracle.apps.fnd.wf.mailer.Mailer

[Sep 18, 2022 2:20:30 AM

EDT]:1663482030040:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:44580:1663482030044:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.cp.gsc.Logger.start(WorkflowContext, int)]:Logger has been
successfully started -> Logger{mLog=[$Header: AppsLog.java 120.5.12020000.5
2017/08/08 21:13:07 rsantis ship $ @1940068501
{oracle.apps.fnd.profiles.ExtendedProfileStore@58a31982}],mUniqueId=MLRTST,mLevel=1
}
[Sep 18, 2022 2:20:31 AM
EDT]:1663482031052:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:44580:1663482030044:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.MailerUtils.hostConnectionTest(WorkflowContext,
Logger, Properties)]:Server {smtpmail.nrb.inside} at port {25} is reachable
[Sep 18, 2022 2:20:31 AM
EDT]:1663482031057:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:44580:1663482030044:0:STATEMENT:[MLRTST
: oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger,
Properties)]:The OUTBOUND SECURE protocol property -> {NONE}
[Sep 18, 2022 2:20:31 AM
EDT]:1663482031057:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:44580:1663482030044:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger,
Properties)]:Debug property -> {true}
[Sep 18, 2022 2:20:32 AM
EDT]:1663482032081:-1:-1:nrbvpebsas01.nrb.inside:10.180.101.50:-1:-
1:1:20420:SYSADMIN(0):-
1:Thread[main,5,main]:10.180.101.50:44580:1663482030044:0:EXCEPTION:[MLRTST
: oracle.apps.fnd.wf.mailer.SMTPUtils.transportTest(WorkflowContext, Logger,
Properties)]:Successfully connected to the SMTP account
ATTENTION - If using outbound notifications please ensure that reply to address
(REPLYTO) '[email protected]' is valid. The SMTP connectivity
test does not guarantee that this address is valid.

HTTP(S) Connectivity (Outbound Email Processing)

Result of (it can take 30s to finish because of the timeout parameter):
/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/admin/scripts/java.sh
-classpath
"/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/lib/dt.jar:/u01/R122PROD/fs1/EBSapps/
comn/util/jdk64/lib/tools.jar:/u01/R122PROD/fs1/EBSapps/comn/util/jdk64/jre/lib/
rt.jar:/u01/R122PROD/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/
ebs3rdpartyManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-
fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/R122PROD/fs1/FMW_Home/Oracle_EBS-app1/
shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/R122PROD/fs1/
FMW_Home/oracle_common/modules/oracle.jrf_11.1.1/jrf-client.jar:/u01/R122PROD/fs1/
EBSapps/comn/java/classes:/u01/R122PROD/fs1/EBSapps/comn/java/lib/cplex.jar:/u01/
R122PROD/fs1/EBSapps/comn/java/classes/IDAutomation_JavaFontEncoder_QRCode.jar"
-Dnid=70117325 -Dhtp=https -DAFLOG_LEVEL=STATEMENT -DAFLOG_ENABLED=true
-Dappuser=0 -Dappresp=20420 -Dappid=1
-Ddbcfile=/u01/R122PROD/fs1/inst/apps/R12PROD_nrbvpebsas01/appl/fnd/12.0.0/secure/
R12PROD.dbc
-Durltimeout=30 oracle.apps.fnd.wf.mailer.Mailer
Profile Options
Concurrent:GSM Enabled = "Y"
Application Framework Agent profile (APPS_FRAMEWORK_AGENT) =
"http://nrbvpebsas01.nrb.inside:8000"
WF: Workflow Mailer Framework Web Agent (WF_MAIL_WEB_AGENT) = ""

Logfiles
--------
Running wfver.sql (it can take few minutes to finish)

Result of SQL File '/u01/R122PROD/fs1/EBSapps/appl/fnd/12.0.0/sql/wfver.sql'

Saved output to

'/home/applR12prod/OEBS1/WF_mailer/out/ATGSuppJavaMailerSetup12_241037_wfver_sql.tx
t'

Running wfmlrdbg.sql for a test notification_id

Result of SQL File '/u01/R122PROD/fs1/EBSapps/appl/fnd/12.0.0/sql/wfmlrdbg.sql'

With Parameters: 70117325
Copied the last 1000000 lines of the file to
ATGSuppJavaMailerSetup12_241037_wfmlrdbg70117325.html
Running atg_supp_wf_email_notifications.sql to list all email notification
events

Result of SQL File 'atg_supp_wf_email_notifications.sql'

Copied the last 1000000 lines of the file to
ATGSuppJavaMailerSetup12_241037_wf_email_notifications.html

Internal Manager
Internal Manager is active
Logfile name =
"/u01/R122PROD/fs_ne/inst/R12PROD_nrbvpebsas01/logs/appl/conc/log/
R12PROD_0917.mg
r"
Copied the last 200 lines of the file to
ATGSuppJavaMailerSetup12_241037_R12PROD_0917.mg r

Service Manager
File "FNDSM813728.mgr" copied to
"ATGSuppJavaMailerSetup12_241037_FNDSM813728.mgr"
File "FNDSM813080.mgr" copied to
"ATGSuppJavaMailerSetup12_241037_FNDSM813080.mgr"

Workflow Mailer and Agent Listener Services

File "FNDCPGSC813753.txt" copied to

"ATGSuppJavaMailerSetup12_241037_FNDCPGSC813753.txt"
File "FNDCPGSC813920.txt" copied to
"ATGSuppJavaMailerSetup12_241037_FNDCPGSC813920.txt"
Debug Service
WARNING - No files found starting with "DebugSvc" in directory
"$APPLCSF/$APPLLOG"
(/u01/R122PROD/fs_ne/inst/R12PROD_nrbvpebsas01/logs/appl/conc/log)
ACTION - Ensure the debug service is enabled and this test is running on the
concurrent manager node if this file is required
Mailer component IDs:
10006

Mailer(s) Data
--------------

Component_id 10006

COMP_ID COMPONENT_NAME STATUS

ACCOUNT
------- -------------------------------------------------- ------------------
--------------------------------------------------
10006 Workflow Notification Mailer RUNNING
appsr12prod

COMP_ID OPEN_INVALID SUMMARY WARNING

------- -------------------- --------------- ---------------
10006 WFMAIL:OPEN_INVALID WFMAIL:SUMMARY WFMAIL:WARNING

COMP_ID INBOUND_SERVER IN_PROTO INBOX DISCARD PROCESS

------- ------------------------------ -------- ------------ ------------
------------
10006 smtpmail.nrb.inside IMAP INBOX DISCARD PROCESS

COMP_ID OUTBOUND_SERVER OUT_PROT REPLY_TO

------- ----------------------------------- -------- ------------------------------
10006 smtpmail.nrb.inside SMTP

COMP_ID PROCESSOR_IN_THREAD_COUNT PROCESSOR_OUT_THREAD_COUNT

------- -------------------------- --------------------------
10006 0 5