Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances

Posted by: Edi Yanto on: January 2, 2009

• In: Oracle
• Comment!

BI Publisher provides the FNDLOAD and XDOLoader utilities to move component across eBusiness Suite instances.

The FNDLOAD utility is used to upload and download the concurrent program, data definition and data template created via created via System Administrator and XML Publisher Administrator responsibility.

The XDOLoader utility is used to upload and download the physical files (Template files, XSD Schema, Sample XML Data , Bursting Control File)

FNDLOAD : Download Concurrent Programs

*) Download all the concurrent programs in a specific product.

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=MPI

*) Download concurrent program for a specified concurrent program name.

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=MPI CONCURRENT_PROGRAM_NAME=MPISHIPPED

FNDLOAD : Upload Concurrent Programs

*) Upload the concurrent programs to an instance.

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt – CUSTOM_MODE=FORCE

FNDLOAD : Download Data Definition and Data Template

*) Download all the data definitions and the corresponding Templates in a specific product.

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=MPI

*) Download a particular data definitions and its corresponding Templates.

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=MPI DATA_SOURCE_CODE=MPISHIPPED

FNDLOAD : Upload Data Definition and Data Template

*) Upload the data definitions and its corresponding Templates to an instance.

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

XDOLoader : Download Physical Files

*) Download all the physical files for a specified application short name

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION oradev:1522:DEV \
-APPS_SHORT_NAME MPI \
-LANGUAGE id \
-TERRITORY ID

*) Download a particular physical file for a specified XDO LOB code

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION oradev:1522:DEV \
-APPS_SHORT_NAME MPI \
-LOB_TYPE TEMPLATE_SOURCE \
-LOB_CODE MPISHIPPEDT \
-LANGUAGE id \
-TERRITORY ID

XDOLoader : Upload Physical Files

*) Upload the RTF file

java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION oradb:1521:PROD \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME MPI \
-LOB_CODE MPISHIPPEDT \
-LANGUAGE id \
-TERRITORY ID \
-XDO_FILE_TYPE RTF \
-FILE_CONTENT_TYPE ‘application/rtf’ \
-FILE_NAME /oracle/dev/appldev/devappl/MPI_MPISHIPPEDT.rtf \
-CUSTOM_MODE FORCE

-CUSTOM_MODE FORCE = FORCE the update if a data/lob already exists

Tags: development, ebiz, XML/BI Publisher