ebs R11/R12 Install BI Publisher Templates

To upload the XML and RTF (see also other install scripts) you can use the following. Note that you can set language and territory as necessary (us/nl for example).

Init

INSTALLATION_DIR=$XXX_TOP
CURRENTDIR=`pwd`
LOGFILE=$CURRENTDIR/MODULE_${INSTALL_DATE}.log

 PORT_NR=$(tnsping ${TWO_TASK} | grep PORT \
   | sed 's/^.*PORT=//g' | sed 's/).*//g')
 DB_NAME=$(tnsping ${TWO_TASK} | grep HOST \
   | sed 's/^.*HOST=//g' | sed 's/).*//g')

echo "Database machine "$DB_NAME":"$PORT_NR

Upload XML

#2 UPLOAD XML
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME $APPS_USER \
-DB_PASSWORD $APPS_PASS \
-JDBC_CONNECTION $DB_NAME:$PORT_NR:$TWO_TASK \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME XXX \
-LOB_CODE MYFILE \
-LANGUAGE nl \
-TERRITORY 00 \
-NLS_LANG American_America.WE8ISO8859P1 \
-XDO_FILE_TYPE XML-DATA-TEMPLATE \
-FILE_CONTENT_TYPE 'text/html' \
-FILE_NAME $INSTALLATION_DIR/install/rtf/MYFILE.xml  >> $LOGFILE

Upload RTF

#3 UPLOAD RTF
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME $APPS_USER \
-DB_PASSWORD $APPS_PASS \
-JDBC_CONNECTION $DB_NAME:$PORT_NR:$TWO_TASK \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME XXX \
-LOB_CODE MYFILE \
-LANGUAGE nl \
-TERRITORY 00 \
-NLS_LANG American_America.WE8ISO8859P1 \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE 'text/html' \
-FILE_NAME $INSTALLATION_DIR/install/rtf/MYFILE.rtf  >> $LOGFILE