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
Other Posts
« Form Personalization: Restrict the Responsibilities LoV without Disabling the End-Date Field on the form FNDSCAUS
HOW-TO: Setup the Self Service Password Request Workflow »
Comments
This entry was posted on Friday, May 8th, 2009 at 6:00 am and is filed under Oracle EBS. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Feed RSS 
My Youtube
My Linkedin
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;
}