How to compile the forms(.fmb),libraries(.pll),reports(.rdf) automatically using script alias in Oracle Apps R12.2

To implement script to automatic compile forms(.fmb),libraries(.pll),reports(.rdf) using script in Oracle Apps R12.2. Follow the below steps to know 'how to compile forms in r12.2'


We need to update the same in .bash_profile to execute it using alias.

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.

No comments:

Post a Comment

Thanks for reading till end. I hope this will help you more to improve your knowledge.

Now it's your turn!

What do you think? Share your experience in the comments box and subscribe for more interesting post.