HOW-TO: Transfer an Oracle Form Personalization to a Different Environment

Posted by in Oracle EBS
One Comment

After 2 weeks of holiday…
I finally wrote the script FormPersonalizationTransfer.sh that automate the transfer of one or more form personalization from an environment to another. This script will take in input the function names associated to each form personalization, will download the *.ldt files and will create the installation script to be executed on the server where the personalization should be installed.
The parameters that the script requires in input are:
– RFC NUMBER: is the Request For Change ID to be written in the installation script (can be blank)
– RFC TITLE: is the Request For Change Title to be written in the installation script (can be blank)
– RFC DEVELOPER: is the person in charge of the form personalization (can be blank)
– FILE VERSION: is the version of the installation script (can be blank)
– APPS PASSWORD: is required to download the for personalization
– FUNCTION NAMES: are required to identify the form personalization to be downloaded

The script should be executed by an OS user with enough privileges.
If you like it don’t forget to leave your comment :P

# # # # #

One thought

  1. Nice site, lots of very useful tit-bits, thanks for putting them online.

    You may want to consider something like this for loading the ldt files:
    ################################
    # APPLY_LDT file
    # Parameters: $1 LDT file name
    #
    ################################

    APPLY_LDT(){
    lctfile=`grep “# dbdrv:” $1 | sed ‘s/.*@([A-Z]{1,}):([A-Za-z0-9:/.]{1,}).*/2/’`
    lcttop=`grep “# dbdrv:” $1 | sed ‘s/.*@([A-Z]{1,}):([A-Za-z0-9:/.]{1,}).*/1_TOP/’`
    lctpath=`set | grep $lcttop= |cut -d’=’ -f2`/$lctfile

    # Copy and backup the file
    COPYFILE $1 $XBOL_TOP/patch/115/import
    # Run FNDLOAD and apply change
    if FNDLOAD $APPSID 0 Y UPLOAD ${lctpath} $1
    then
    echo “n$1 Changes sucessfully applied, using ${lctfile}”
    else
    echo “$1 failed”
    echo “The Login id: $APPSID or LCT file ${lctpath} may be invalid.”
    echo “Please check the FNDLOAD log file above and rerun”
    echo “Aborting……”
    ERROR_AND_EXIT
    fi;
    }

Reply