Uploading rtf,xml,ldt file through shell script in XMLBIPublisher -Oracle Apps

By using the below sh file Command one can upload concurrent program ldt, Template and data definition ldt,rtf and xml file ldt,request groups ldt files.

1) XX_AP_INVAGECCP.ldt name of the ldt file.
2) For uploading rtf and xml file.
Firts need to check the lob-code name and file name,language and territory name from the database and need to include in the below commands
select * from xdo_lobs;
xdo_lobs is the table name in which file name contains the rtf and xml file name
3) XX_AP_INVAGE_RG3.ldt - name of the request groups
4) Template definition command will upload both data definition and template definition also.
# +============================================================================+
# |
# | File name:     XX_AP_INVAGE_INSTALL.sh
# | Author:      
# | Purpose:    
# |
# |
# |
# |
# | Change history:
# |
# | Date       Author            Version             Description of change
# +============================================================================+
# | 11-NOV-13  Sathish             1.0             Changes for Tkt #200464
# |
# +============================================================================+
CURRENT_PATH=`pwd`
echo "Please Enter the Apps Schema User Name"
read P_APPS_USER
echo "Please Enter the Apps Schema User Password"
stty -echo
read P_APPS_PASSWD
stty echo
echo "   Enter jdbc address in format like(Host Ip:Port:SID):  "

echo  "# ******************************************************************* #"
read jdbc

#************************************************************************************
#      Starting of Installation Scripts from staging directory
#***********************************************************************************/
echo "---------------------------------------"
echo "--Uploading Concurrent Program definitions"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_AP_INVAGECCP.ldt

echo "--Uploading Template definitions"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_AP_INVAGE_TMP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

echo "--Uploading XML File - XX_AP_INVAGE.xml"

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD $P_APPS_PASSWD -JDBC_CONNECTION $jdbc -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME APPS SHORT NAME -LOB_CODE  XX_AP_INVAGE_REP -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_CONTENT_TYPE 'text/html' -FILE_NAME XX_AP_INVAGE.xml

echo "--Uploading RTF File - XX_AP_INVAGE.rtf"

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD $P_APPS_PASSWD -JDBC_CONNECTION $jdbc -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME APPS SHORT NAME -LOB_CODE XX_AP_INVAGE_REP -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE RTF -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME  'XX_AP_INVAGE.rtf' -CUSTOM_MODE FORCE

echo "--Uploading Request Group assignments"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_AP_INVAGE_RG.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_AP_INVAGE_RG1.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_AP_INVAGE_RG3.ldt

echo " -- Uploading profile option"

FNDLOAD apps/ O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct QL_THIRD_LEVEL_CONTRACT_APPROVER.ldt CUSTOM_MODE=FORCE

echo "End of Installation ........."