Moving Alerts Between R12 Instances

Problem:

How do I move Oracle Alerts between R12 instances?

Solution:

Use the FNDLOAD command.

This example shows how to move Oracle Alerts in between R12.1 instances on a Windows platform. In each of the six FNDLOAD commands below, the alert (for example, in the first command, the alert is “VS Employee Separation”) was previously created and tested in DEV1. The FNDLOAD command exported to an ldt file (such as “VS_Employee_Separation3.ldt).

Part 1: Download alerts from DEV1 instance

1. Load Command Prompt (run as administrator) and source DEV1 apps tier environment:

C:
cd oracleDEV1appsapps_stappl
APPSDEV1_ittl-hrmstest.cmd

2. Change directory to location to store ldt files, C:TEMP:

cd temp

3. Load sh shell (run sh):

sh

4. Execute the following commands (note that each FNDLOAD command should be executed on one line):

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_Employee_Separation3.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS Employee Separation"

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_End_Probation3.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS End Probation"

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_New_Employee3.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS New Employee"

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_Temporary_Employment_Ending3.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS Temporary Employment Ending"

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_Drug_Testing.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS Drug Testing"

FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct VS_Training_Renewal.ldt 
ALR_ALERTS APPLICATION_SHORT_NAME=PER ALERT_NAME="VS Training Renewal"

Part 2: Upload alerts to UAT2 instance

5. Source UAT2 apps tier environment

6. Change directory to C:TEMP

7. Run sh

8. Execute the following commands:

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_Employee_Separation3.ldt

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_End_Probation3.ldt

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_New_Employee3.ldt

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_Temporary_Employment_Ending3.ldt

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_Drug_Testing.ldt

FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct VS_Training_Renewal.ldt

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.