XMLPub Templates :XDOLOADER Utility

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION dev.test.com:1521:DEV \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME IBY \
-LOB_CODE ACH_BOA \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE 'application/rtf' \
-FILE_NAME ACH_NACHA_BOA_en-GEN.rtf \
-CUSTOM_MODE FORCE


The parameters are described in the following table:

What you observe above is the parameters LOB_CODE and LCT_FILE are optional, but one must be defined as follows:

How to pass the TERRITORY in NULL while upload the RTF : 

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION dev2.test.com:1521:DEV2 \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME IBY \
-LOB_CODE ACH_NACHA_BOA \
-LANGUAGE en \
-TERRITORY 00 \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE 'application/rtf' \
-FILE_NAME ACH_NACHA_BOA_en.rtf \
-CUSTOM_MODE FORCE
===================        *****************     =====================

• LOB_CODE - use this parameter to download an individual template.
• LCT_FILE - if you do not define an LOB_CODE then this parameter is required. If you want to download multiple templates, then you must provide the LCT file. The loaded needs this file to retrieve the templates. The LCT file can be found under XDO_TOP/patch/115/import/xdotmpl.let. When you use this option you will not only get the templates, but the let file for the templates will be generated for you as well.