Monday 4 April 2022

how to compile sql, pkb, ldt and wft file from shell script

#!/bin/bash
#* $Header:FACutomizationScript.sh  99.99 MM/DD/YYYY HH:MI:SS  *
########################################################################################################################
#
# Shell Script Name : XXX_CUSTOM.sh
#
# Purpose           : XXX_CUSTOM Custom Program Migration script
# Change History    : 04-Apr-2022 
#  
########################################################################################################################
APPS_USER='apps'
read -s -p "Enter Apps Password: " APPS_PASSWD
read -s -p "Enter SID: "  DB_SID
#APPS_PASSWD
#DB_SID=
date
who am i
cd $XXX_TOP/UPGRADE
echo "Compiling plsql" 
echo "Compiling view XXX_OE_PKG_SPEC.sql"
echo " "
sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_OE_PKG_SPEC.sql

echo "Compiling XXX_OE_PKG_BODY.sql"
echo " "
sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_OE_PKG_BODY.sql

echo "Executing file XXX_POXRQERQ.ldt"
echo " "
FNDLOAD $APPS_USER/$APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXX_POXRQERQ.ldt

echo "Compiling XXX_Lookup_Code.sql"
echo " "
sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_Lookup_Code.sql

echo "Compiling XXX_ACCT_GEN_PKG.pks"
echo " "
sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$OVT_TOP/R12UPGRADE/XXX_ACCT_GEN_PKG.pks

echo "Compiling XXX_ACCT_GEN_PKG.pkb"
echo " "
sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$OVT_TOP/R12UPGRADE/XXX_ACCT_GEN_PKG.pkb

echo "copy XXXRWMO.rdf"
echo " "
cp $XXX_TOP/R12UPGRADE/XXXRWMO.rdf $XXX_TOP/reports/US

echo "copy XXXTOPKL.rdf"
echo " "
cp $XXX_TOP/R12UPGRADE/XXXTOPKL.rdf $XXX_TOP/reports/US

echo "Upload XXX_POWFACCT_MODIFIED.wft"
echo " "
WFLOAD $APPS_USER/$APPS_PASSWD 0 Y FORCE XXX_POWFACCT_MODIFIED.wft

echo "Upload XXX_CRP_V3.wft"
echo " "
WFLOAD $APPS_USER/$APPS_PASSWD 0 Y FORCE XXX_CRP_V3.wft

date
who am i

echo "End of script"

# --------------------------------------------------------------------
#  End of Script
# --------------------------------------------------------------------

No comments:

Post a Comment