1) Download and Upload all the data definitions and corresponding templates in an instance.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt XDO_DS_DEFINITIONS
FNDLOAD apps/apps_pwd@db 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt
2) Download all the data definitions and the corresponding Templates in a module.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX
3) Download a particular data definitions and its corresponding Templates.
FNDLOAD apps/apps_pwd@db 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct targetldtfile.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XXX DATA_SOURCE_CODE=EMP_DD
XDOLOADER :
File Download Only Mode
Syntax :
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME
-DB_PASSWORD
-JDBC_CONNECTION
-LOB_TYPE
-APPS_SHORT_NAME
-LOB_CODE
-LANGUAGE
-TERRITORY
-LOG_FILE
1) Download all the physical files in the instance.
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION apsrtc:1521:SID \
-LANGUAGE en \
-TERRITORY US
2) Download all the physical files for a specified module
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION apsrtc:1521:SID \
-APPS_SHORT_NAME AR \
-LANGUAGE en \
-TERRITORY US
3) Download all the physical files for a specified module and LOB Type
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION apsrtc:1521:SID \
-LOB_TYPE BURSTING_FILE \
-LANGUAGE en \
-TERRITORY US
File Download and LDT/DRVX Generation Mode
Syntax :
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME
-DB_PASSWORD
-JDBC_CONNECTION
-APPS_SHORT_NAME
-DS_CODE (data source code> \
-LCT_FILE
-LDT_FILE
-DRVX_FILE
-LOG_FILE
1) Download all the physical files of a specified application in an instance.
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD welcome \
-JDBC_CONNECTION r12.com:1533:R124 \
-APPS_SHORT_NAME AR \
-LCT_FILE ${XDO_TOP}/patch/115/import/xdotmpl.lct
2) Download all the physical files of a specified application and in and data definition in an instance.
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD welcome \
-JDBC_CONNECTION r12.com:1533:R124 \
-APPS_SHORT_NAME AMW \
-LCT_FILE ${XDO_TOP}/patch/115/import/xdotmpl.lct \
-DS_CODE EMP_DD
Uploading Physical Files
Syntax :
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME
-DB_PASSWORD
-JDBC_CONNECTION
-LOB_TYPE
-DEBUG
-APPS_SHORT_NAME
-LOB_CODE
-LANGUAGE
-TERRITORY
-XDO_FILE_TYPE
-NLS_LANG
-FILE_CONTENT_TYPE
-FILE_NAME
-OWNER
-CUSTOM_MODE [FORCE NOFORCE] \
-LOG_FILE
_________________________________________________________________________
1) Upload the RTF file.
java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD welcome \
-JDBC_CONNECTION r12.com:1533:R124 \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME AMW \
-LOB_CODE EMP_DD \
-LANGUAGE en \
-TERRITORY US \
-NLS_LANG American_America.WE8ISO8859P1 \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE ’text/html’ \
-FILE_NAME /tmp/psomanat/TEMPLATE_SOURCE_AMW_Emp_Template_en_US.rtf
API to load Template Definition:
PROMPT Loading Template Definition
BEGIN
XDO_TEMPLATES_PKG.load_row (
X_APPLICATION_SHORT_NAME => 'XXX',
X_TEMPLATE_CODE => 'short_template_name',
X_DS_APP_SHORT_NAME => 'XXX',
X_DATA_SOURCE_CODE => 'short_data_source',
X_TEMPLATE_TYPE_CODE => 'RTF',
X_DEFAULT_LANGUAGE => 'en',
X_DEFAULT_TERRITORY => '00', -- 00 means no territory
X_MLS_LANGUAGE => NULL,
X_MLS_TERRITORY => NULL,
X_TEMPLATE_STATUS => 'E',
X_USE_ALIAS_TABLE => 'N',
X_START_DATE => TO_CHAR (SYSDATE, 'YYYY/MM/DD'),
X_END_DATE => NULL,
X_TEMPLATE_NAME => 'name of template',
X_DESCRIPTION => 'description of template',
X_OWNER => 'USERNAME', -- CUSTOM will make this non-updatable in the UI
X_LAST_UPDATE_DATE => NULL, -- should use system date here if null
X_CUSTOM_MODE => 'FORCE',
X_DEPENDENCY_FLAG => 'P', /* P for templates, C for subtemplates */
X_OBJECT_VERSION_NUMBER => 1,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL);
END;
/
COMMIT;
/
Tables to be handy:
select * from all_tables where table_name like 'XDO%DS%';
select * From xdo_lobs where lob_code like 'XX%_APXUATR_XMLP';
select * from xdo_templates_vl where template_code like '%APXUA%';
select * from xdo_templates_tl where template_code like ' %APXUA%';
select * from xdo_templates_b where template_code like '%APXUA%';
select * from xdo_ds_definitions_tl where data_source_code like '%APXUA%';
select * from xdo_ds_definitions_b where data_source_code like '%APXUA%';
select * from xdo_ds_definitions_vl where data_source_code like '%APXUA%';
