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';