FNDLOAD and XDOLoader to Migrate XMLP reports

To migrate an XMLP report we need below 4 objects

LDT file for Concurrent Program
LDT file for XMLP Template and Data Definition
XML Data Definition
RTF or XLS layout

LDT file for Concurrent Program

To Download LDT:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_EMP_DETAILS_RPT.ldt PROGRAM APPLICATION_SHORT_NAME=XXCUST CONCURRENT_PROGRAM_NAME=XX_EMP_DETAILS_RPT

To Upload LDT:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_EMP_DETAILS_RPT.ldt

LDT file for XMLP Template and Data Definition

To Download LDT:

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_EMP_DETAILS_RPT_DT.ldt XDO_DS_DEFINITIONS DATA_SOURCE_CODE=XX_EMP_DETAILS_RPT APPLICATION_SHORT_NAME=XXCUST

To Upload LDT:

FNDLOAD apps/apps 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_EMP_DETAILS_RPT_DT.ldt

XML Data Definition

To Upload XML Data Definition:

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD appspwd \
-JDBC_CONNECTION ebsdev.host.com:1521:EBSDEV \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE XX_EMP_DETAILS_RPT \
-LANGUAGE en \
-TERRITORY 00 \
-TRANSLATE Y \
-XDO_FILE_TYPE XML \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'text/html' \
-FILE_NAME XX_EMP_DETAILS_RPT.xml \
-LOG_NAME XX_EMP_DETAILS_RPT.xml.log \
-CUSTOM_MODE FORCE

RTF or XLS layout

To Upload RTF Layout:

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD appspwd \
-JDBC_CONNECTION ebsdev.host.com:1521:EBSDEV \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE XX_EMP_DETAILS_RPT \
-LANGUAGE en \
-TERRITORY 00 \
-TRANSLATE Y \
-XDO_FILE_TYPE RTF \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'application/rtf' \
-FILE_NAME XX_EMP_DETAILS_RPT.rtf \
-LOG_NAME XX_EMP_DETAILS_RPT.rtf.log \
-CUSTOM_MODE FORCE

To Upload XLS Layout:

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD appspwd \
-JDBC_CONNECTION ebsdev.host.com:1521:EBSDEV \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE XX_EMP_DETAILS_RPT \
-LANGUAGE en \
-TERRITORY 00 \
-TRANSLATE Y \
-XDO_FILE_TYPE XLS \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'application/vnd.ms-excel' \
-FILE_NAME XX_EMP_DETAILS_RPT.xls \
-LOG_NAME XX_EMP_DETAILS_RPT.xls.log \
-CUSTOM_MODE FORCE

Verification

To verify XMLP Data Definition and Template

SELECT *
FROM apps.xdo_templates_b
WHERE template_code = 'XX_EMP_DETAILS_RPT';

To verify Layout

SELECT *
FROM apps.xdo_lobs
WHERE LOB_CODE = 'XX_EMP_DETAILS_RPT';