Downloading RTF Files

XDOLoader is an Oracle E-Business Suite tool you can use to upload/download RTF files in XML Publisher.

To download an RTFfile, you would use the following command:


unix>javaoracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME <username> \
-DB_PASSWORD <password> \
-JDBC_CONNECTION <jdbc_connect> \
-LOB_TYPE <lob_type> \
-APPS_SHORT_NAME <application_short_name> \
-LOB_CODE <lob_code> \
-LANGUAGE <language>


Suppose you have a custom template called BEEJARTHA in the DEVL database on the ebs.beejartha.com server. You could download it with the following command:


unix>javaoracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD appspass \
-JDBC_CONNECTION ebs.beejartha.com:1521:DEVL \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXCUS \
-LOB_CODE BEEJARTHA \
-LANGUAGE en


If you would like to get a list of all custom templatesto download you can do the following:


unix>sqlplus apps/appspass@DEVL
SQL> select lob_code
from xdo_lobs
where lob_type = 'TEMPLATE_SOURCE'
and application_short_name = 'XXCUS';


We needed to download all our custom templates so we created this script:


#!/bin/sh
#
# Find custom templates in the XXCUS application.
#
TEMPLATES=$(sqlplus -s /nolog<< SQL_BLOCK
connect apps/appspass@DEVL
set echo off feedback off heading off pagesize 0 trimspool on
select lob_code
from xdo_lobs
where lob_type = 'TEMPLATE_SOURCE'
and application_short_name = 'XXCUS';
exit;
SQL_BLOCK
)
#
# Loop through list and download template.
#
TEMPLATES=$(echo $TEMPLATES | sed s/"Connected."//)
for TEMPLATE in ${TEMPLATES[0]}
do
echo
echo "-------------------- $TEMPLATE --------------------"
echo
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD appspass \
-JDBC_CONNECTION ebs.beejartha.com:1521:DEVL \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXCUS \
-LOB_CODE $TEMPLATE \
-LANGUAGE en
done