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
Nice Info
ReplyDeleteQuick question - Values passed to DEBUG argument is case sensitive?
ReplyDeleteYes,Valid values are: true / false (default)
ReplyDelete