How to compile forms in R12 using automated shell script

by

In this post we will compile forms in oracle apps R12 after implementing shell script to automatic compile forms(.fmb), libraries(.pll), reports(.rdf)

Compile forms using shell script: –

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

 
Note:- Fmx file will generate the under $XXCUSTOM_TOP. If you want to store it another place, pls update the location accordingly.
 

Leave a Comment