Saturday 19 January 2013

XDOLoader to Upload XML RTF & Data Template dynamically


Like fndload to download and upload concurrent programs,
We can use below scripts to Upload/download XML/BI Publisher Data Definition and Template Creation.

Download

FNDLOAD apps/$L_APPSPASS O Y DOWNLOAD
$XDO_TOP/patch/115/import/xdotmpl.lct
XXAHDR_DD.ldt XDO_DS_DEFINITIONS
APPLICATION_SHORT_NAME='PER' DATA_SOURCE_CODE='XXAHDR'

Upload
FNDLOAD apps/$L_APPSPASS O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXAHDR_DD.ldt

The upload ldt will creates the Program Structure only in XML Responsibility,by using below util.XDOLoader we can attach RTF and Data Template dynamically.

----------------------
 DATA_TEMPLATE
----------------------
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
 -DB_USERNAME       apps \
 -DB_PASSWORD       $L_APPSPASS \
 -JDBC_CONNECTION   $JDBC_CONN \
 -LOB_TYPE          DATA_TEMPLATE \
 -APPS_SHORT_NAME   CSOAP \
 -LOB_CODE          XXCAID \
 -XDO_FILE_TYPE     XML \
 -FILE_CONTENT_TYPE text/xml \
 -FILE_NAME         XXCAID.xml \
 -CUSTOM_MODE       FORCE \
 -DEBUG             true

----------------------
RTF
----------------------
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
 -DB_USERNAME       apps \
 -DB_PASSWORD       $L_APPSPASS \
 -JDBC_CONNECTION   $JDBC_CONN \
 -LOB_TYPE          TEMPLATE \
 -APPS_SHORT_NAME   CSOAP \
 -LOB_CODE          XXCAID \
 -LANGUAGE          en \
 -XDO_FILE_TYPE     RTF \
 -NLS_LANG          American_America.UTF8 \
 -FILE_CONTENT_TYPE 'text/xml' \
 -FILE_NAME         XXCAID.rtf \
 -CUSTOM_MODE       FORCE \
 -DEBUG             true



3 comments: