FNDLOAD XDO Objects

Data Definition and Data Template

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 \      -- db2197.oracle.com:43501:orcl
-LOB_TYPE \                                    --TEMPLATE_SOURCE
-DEBUG \ 
-APPS_SHORT_NAME \  -- XXX
-LOB_CODE \
-LANGUAGE \                                         -- en
-TERRITORY \                                          --00
-XDO_FILE_TYPE \                        -- RTF
-NLS_LANG \
-FILE_CONTENT_TYPE \         -- application/rtf
-FILE_NAME \                                       -- myfilename.rtf
-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%';