Place this script file in temporary location with the reports and *.ldt file under same temp directory.
Step1:-Code for Login in Database and java base for DD & RTF File
*******************************************
# +===================================================================+
TMPDIR=`'pwd'`
# +===================================================================+
# Function to Check the validity of loginids and password.
# +===================================================================+
CHKLOGIN(){
if sqlplus -s /nolog <<! >/dev/null 2>&1
WHENEVER SQLERROR EXIT 1;
CONNECT $1 ;
COLUMN tbl NEW_VALUE tbl_name NOPRINT;
SELECT table_name tbl
FROM all_tables
WHERE table_name = '$2'
AND ROWNUM = 1;
EXIT;
!
then
echo OK
else
echo NOK
fi
}
APPSID="$XX_APPS_LOGIN_PASS"
# +===================================================================+
# Check if APPS Login Id is entered else prompt to get it
# +===================================================================+
while [ "$APPSID" = "" -o `CHKLOGIN "$APPSID" "DUAL"` = "NOK" ]
do
if [ "$APPSID" = "" ];then
echo -e "Enter APPS Login Userid/Passwd : \c"
read APPSID
else
echo "APPS Login Userid and Password entered is not CORRECT"
APPSID=""
fi
done
APPS_LOGIN=`echo $APPSID | cut -d"/" -f1`
APPS_PWD=`echo $APPSID | cut -d"/" -f2`
echo "Enter JDBC Connection String e.g 10.22.16.38:1543:IMDU: "
read APPSJDBC
#
:: eg jaorddu1.dpa.co.ae:1533:DWCD
*********************************************************************
Step 2:Copy all the files You need to deploy in temp folder:
->shell script file name: cp $TMPDIR/SCRIPT.install $XXHR_TOP/bin/SCRIPT.install
->Any Packages/SQL/Views: cp $TMPDIR/XXHR_PACKAGE.sql $XXHR_TOP/admin/sql/XXHR_PACKAGE.sql
->Concureent program *.ldt file cp $TMPDIR/XXHRXMLRPT.ldt $XXHR_TOP/admin/import/XXHRXMLRPT.ldt
->template file related to the report : cp $TMPDIR/XXHRXMLRPT.rtf $XXHR_TOP/admin/import/XXHRXMLRPT.rtf
->rdf file related to the report cp $TMPDIR/XXHRXMLRPT.rdf $XXHR_TOP/reports/US/XXHRXMLRPT.rdf
**********************************************************************
Step3:Upload Valusets,Concurrent Program And Data Definition:
->$FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct valueset.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
->Concurrent Program
if $FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXHRXMLRPT.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
then
echo "Successfully uploaded Concurrent Program - XXHR:Employee Report"
else
echo "Error uploading in Concurrent Program - XXHR:Employee Report"
fi
#TEMPLATE of the Report
if java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $APPS_LOGIN -DB_PASSWORD $APPS_PWD -JDBC_CONNECTION $APPSJDBC -LOB_TYPE TEMPLATE -APPS_SHORT_NAME XXHR -CUSTOM_MODE FORCE -XDO_FILE_TYPE RTF -LANGUAGE en -LOB_CODE XXHRXMLRPT -FILE_NAME XXHRXMLRPT.rtf
then
echo "Successfully uploaded xsl template - XXHR:Employee Report"
else
echo "Error uploading in xsl template - XXHR:Employee Report"
fi
#
##Data Definition Of the Report+
if $FND_TOP/bin/FNDLOAD $APPSID O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXHR_EMP_PROB_PRD_REP_DD.ldt
then
echo "Successfully uploaded DD - XXHR_EMP_PROB_PRD_REP_DD"
else
echo "Error uploading in DD - XXHR_EMP_PROB_PRD_REP_DD"
fi
#
****************************************************EOF*************************
