Diagnostics not functioning in Oracle Applications after upgrading to 12.1.3

Issue:

After upgrading to R12, when user is following below navigation for diagnostics:

Help -> Diagnostics -> Examine

getting below error:

"Function Not Available for this responsibility. Change responsibilities or contact your system administrator"

Resolution:

Beginning with Release 12.1.3, access to the above Diagnostics submenu items can be controlled by the profile Utilities:Diagnostics or by security functions using Role-Based Access Control (RBAC). Whether or not a submenu item is available is checked on an "as-needed" basis by the system when the user selects the submenu item. If the menu item is not available to the user, the message "Function not available to this responsibility. Change responsibilities or contact your System Administrator."

To fix this error, set the following profile option to Yes at user level for the user to whom this is required.

Utilities:Diagnostics 

After setting this profile to Yes, clear the cache and bounce Apache to reflect the same.

Clear Cache in Oracle Apps R12 from backend (server).

Aim: How to clear cache in Oracle Apps R12 without logging into Applications.

Procedure:  Login to Middletier and use below commands.


$ cd $ADMIN_SCRIPTS_HOME
$ adapcctl.sh stop
$ find $LOG_HOME/ora/10.1.3 -name '*' -type f |xargs rm -f
$ adoacorectl.sh stop
$ adoacorectl.sh start
$ adapcctl.sh start

How to send mail using utl_mail from PL/SQL?

Aim: To send a mail using utl_mail from SQL.

Procedure:
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus '/as sysdba'

SQL> @utlmail.sql

Package created.

Synonym created.

SQL> @prvtmail.plb

Package created.

Package body created.

Grant succeeded.

Package body created.

No errors.
SQL> GRANT EXECUTE ON UTL_MAIL TO PUBLIC;

Grant succeeded.

Test:


SQL> BEGIN
  2    EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''mail.testhost.com''';
  3    UTL_MAIL.send(sender => 'vbadam@testhost.com',
  4                  recipients => 'veda.santosh@gmail.com',
  5                     subject => 'Test Mail',
  6                     message => 'Hello World',
  7                   mime_type => 'text; charset=us-ascii');
  8  END;
  9  /

PL/SQL procedure successfully completed.



And a test mail is received at veda.santosh@gmail.com