#!/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