How to Debug WORKFLOW Mailer failures in Oracle Apps (EBS) and How can I change Workflow Notification Mailer parameters without login to OAM?

WORKFLOW Mailer Debugging for Notification Failures
==============================================

First take a look at the current Workflow mailer log which is located in the below location:

cd $APPLCSF/$APPLLOG

ls -ltr FNDCPGSC*.txt

AFJVAPRG is a utility/command which will help you debug

Issue below command on Oracle Apps Tier  to check connectivity and routing of IMAP server like port connectivity and notification delivery processing status and path where its failing and why its failing

Note: Mention the correct port number used for IMAP/SMTP server and the IMAP/SMTP server names correctly in the below commands

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=imap.gmail.com -Dport=993 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=ebusiness@gmail.com -Dpassword=welcome123 -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailImapTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer


Issue below command on Oracle Apps Tier  to check connectivity and routing of SMTP server like port connectivity and notification delivery processing status and path where its failing and why its failing

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=smtp.gmail.com -Dport=465 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=ebusiness@gmail.com -Dpassword=welcome123  -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailSmtpTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer


================================================
Additionally :
How can I change Workflow Notification Mailer parameters without login to OAM? 

sqlplus apps/apps   @$FND_TOP/sql/wfmlpcln.sql
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


PL/SQL procedure successfully completed.

Commit complete.

cd $FND_TOP/sql
@afsvcpup.sql

Enter Component Id: 10006
Enter the Comp Param Id to update : 10093

Enter a value for the parameter  : xyz@abc.com