How to compile forms in oracle apps r12

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

 
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