Using Set Override Address in Worklow Notification Mailer [ATG_PF.H/R12]

What is "Set Override Address"?

"Set Override Address" option is available in ATG_PF.H.Rollup 3 OR Above / R12

As pre Note: 377416.1,

" After ATG.H RU3 , the override address replaces the 'test address'. The purpose of this setting is to provide a test address which will receive ALL outbound notifications from the notification mailer.

The mailer will redirect or 'override' all outbound mail to this address, regardless of the original recipient.

This is useful for testing purposes where the mailer functionality must be confirmed yet where the mass mailing of pending test notifications to a user community is not wanted. "

When "Set Override Address" is set, Workflow Notification Mailer sents all Workflow Notifications / Oracle Alerts related mails to the address that you specified in "Set Override Address" instead of the actual recipients.

We can use this in the following occasions,

1. After cloning, don't want Mailer to sent the Notifications / Alerts to production users
   
2. In Test instance want all Notifications / Alerts to particular Mail address
   

How to set "Set Override Address"?

1. Log into Oracle Applications Manager [OAM]
   
2. Navigate: Site Map / Administration tab / Workflow section / Notification Mailer / View Details / Set Override Address Button
   
3. Give a valid Email Address / Submit
   

[OR]

1. System Administration Responsibility
   
2. Navigate: Workflow Manager / Notification Mailer / View Details / Set Override Address Button
   
3. Give a valid Email Address / Submit
   

Mailer will send an email to the new Override Address that has been entered in OAM, just to verify the email Address is valid.

The email includes a Verification Code, that must be entered in OAM to confirm the new Override Address

How to clear "Set Override Address"?

1. Log into OAM.
   
2. Navigate: Site Map / Administration tab / Workflow section / Notification Mailer / View Details / Set Override Address Button
   
3. Click on button "Clear Override Address"
   

References:

740110.1 How To Clear the Test / Override Address Used By Java Mailer On Post-ATG_PF.H.Rollup 3 Instance?

415721.1 Which tables stores the NEW test address 'set override address' ?

743282.1 Email Notifications are not Sent to Users after Configuring the Workflow Mailer

377416.1 Can Not Set Test Override Email Address In Notification Mailer After Atg.H Rup3

OCM with Oracle Applications R12 in Disconnected Mode

Software Configuration Manager (SCM) now known as Oracle Configuration Manager(OCM) came across dramatic changes from its introduction.

During intial release of Oracle Applications R12.0 OCM is incorprated with Autoconfig and introduced some new autoconfig variables.

Now accroding to Note:727157.1, no more OCM Configuration or OCM management via Autoconfig.

Most of the customers are worried to configure OCM in connected mode, due to security calls.
It requires internet connectivity (with or without proxy) to the OCM installed node.
Connected mode uploads the collected data to metalink via https protocol.

Below are the steps to configure OCM With Oracle Applications R12 in disconnected mode.
In Disconnected mode the Apps DBA or Applications Administrator, has to manually upload the collected data(ocmconfig.jar) by OCM to metalink.

Refer 763142.1 to know the procedure of manually uploading collected data (ocmconfig.jar)

What we are going to do is, remove existing OCM setup/stage files, and install the newly downloaded OCM version

1. Remove Metalink, CSI related information from Context XML file
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

abc@abc.com
IN


16144040
[to]







Verify the same in DB Tier Nodes
++++++++++++++++++++++++
cat $ORACLE_HOME/appsutil/$TWO_TASK.xml | grep -i proxy
cat $ORACLE_HOME/appsutil/$TWO_TASK.xml | grep -i metalink
cat $ORACLE_HOME/appsutil/$TWO_TASK.xml | grep -i country
cat $ORACLE_HOME/appsutil/$TWO_TASK.xml | grep -i systemcsi


Verify the same in Apps Tier Nodes
+++++++++++++++++++++++++
cat $INST_TOP/appl/admin/$TWO_TASK.xml | grep -i proxy
cat $INST_TOP/appl/admin/$TWO_TASK.xml | grep -i metalink
cat $INST_TOP/appl/admin/$TWO_TASK.xml | grep -i country
cat $INST_TOP/appl/admin/$TWO_TASK.xml | grep -i systemcsi

Database Oracle Home OCM Installation
+++++++++++++++++++++++++++++++++++++
echo $ORACLE_HOME
$ORACLE_HOME/ccr/bin/emCCR stop
rm -Rf $ORACLE_HOME/ccr_stage
rm -Rf $ORACLE_HOME/ccr

unzip ocm-Production-AIX-ppc.zip -d $ORACLE_HOME

ls -rlt $ORACLE_HOME/ccr
ls -rlt $ORACLE_HOME/ccr/bin
$ORACLE_HOME/ccr/bin/setupCCR -s -d 123456 abc@abc.com IN

Database Post-Install Steps
+++++++++++++++++++++++++++
$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s $ORACLE_SID -r sys

If using EBusiness Suite
++++++++++++++++++++++++
$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig -u apps -w apps

If using Enterprise Manager 10g
+++++++++++++++++++++++++++++++
$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectemrep -e

$ORACLE_HOME/ccr/bin/emCCR status
$ORACLE_HOME/ccr/bin/emCCR collect

ls -rlt $ORACLE_HOME/ccr/hosts/`hostname`/state/upload/ocmconfig.jar

Applications 10.1.2 Oracle Home OCM Installation
+++++++++++++++++++++++++++++++++++++++++++++++++

echo $ORACLE_HOME
rm -Rf $ORACLE_HOME/ccr_stage

ls -lrt $INST_TOP/ocm
rm -Rf $INST_TOP/ocm

unzip ocm-Production-AIX-ppc.zip -d $ORACLE_HOME

ls -rlt $ORACLE_HOME/ccr
ls -rlt $ORACLE_HOME/ccr/bin
$ORACLE_HOME/ccr/bin/setupCCR -s -d 12345 abc@abc.com IN

$ORACLE_HOME/ccr/bin/emCCR status
$ORACLE_HOME/ccr/bin/emCCR collect

ls -rlt $INST_TOP/ora/10.1.2/ccr/state/upload/ocmconfig.jar



Applications 10.1.3 IAS Home OCM Installation
+++++++++++++++++++++++++++++++++++++++++++++

ORACLE_CONFIG_HOME=$IAS_ORACLE_HOME
export ORACLE_CONFIG_HOME

echo $IAS_ORACLE_HOME
rm -Rf $IAS_ORACLE_HOME/ccr_stage

unzip ocm-Production-AIX-ppc.zip -d $IAS_ORACLE_HOME

ls -rlt $IAS_ORACLE_HOME/ccr
ls -rlt $IAS_ORACLE_HOME/ccr/bin
$IAS_ORACLE_HOME/ccr/bin/setupCCR -s -d 12345 abc@abc.com IN

$IAS_ORACLE_HOME/ccr/bin/emCCR status
$IAS_ORACLE_HOME/ccr/bin/emCCR collect

ls -rlt $IAS_ORACLE_HOME/ccr/state/upload



References:
++++++++
727157.1 Upgrading OCM and Switching to Native Integration with Oracle E-Business Suite Release 12
763142.1 How to upload the collection file ocmconfig.jar to My Oracle Support for Oracle Configuration Manager (OCM) running in Disconnected Mode.
250434.1 BULLETIN: Learn More About My Oracle Support Configuration Manager