How to compile forms in oracle apps R12 | To implement script to automatic compile forms(.fmb),libraries(.pll),reports(.rdf)
How to compile forms:-
We need to update the same in .bash_profile to execute it using alias.We can compile forms manually as well.
Hidden file .bash_profile located under /home/applmgr. Open .bash_profile using vi editor and write the script as given below.
$vi .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
#Source the APPS Tier enviorment
. /oracle//apps/apps_st/appl/APPS***_prodapps.env
cd $ADMIN_SCRIPTS_HOME
export LDEMULATION=elf_i386
export OPATCH_PLATFORM_ID=226
alias frmcmp=’$HOME/.frmcmp.sh’
#Create the .frmcmp.sh and write the script as given below.
[applmgr@prodapps ~]$ cat $HOME/.frmcmp.sh
. /oracle/apps/apps_st/appl/APPS***_prodapps.env
cd $AU_TOP/forms/US
echo
echo ‘Enter value for fmb and fmx file’
echo
read -p ‘Fmb_file.fmb: ‘ fmbfile
read -p ‘Fmx_file.fmx: ‘ fmxfile
echo
echo ‘Enter Username and Password’
echo
read -p ‘Username: ‘ username
##read -s -p ‘Password: ‘ password
echo
echo ‘fmx will create in $XXCUSTOM_TOP/forms/US/’
frmcmp_batch module=$fmbfile output_file=$XXCUSTOM_TOP/forms/US/$fmxfile userid=$username/pderpsusrlg