Moving Concurrent Programs, Data Definitions and Templates Between eBusiness Suite Instances & Difference between FNDLOAD and XDOLOADER in Oracle Apps

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

Difference between  FNDLOAD and XDOLOADER in Oracle Apps

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 viacreated 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

Another way

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXMATERIAL_TMP.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

FNDLOAD : Download Forms personalization

you can either Download for a specific form or specfic function of the form. In both the case same affrmcus.lct is used.

Download -specific form< /STRONG>

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES
form_name=<form name>

Download forms personalization with function name

FNDLOAD username/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct           file_name.ldt FND_FORM_CUSTOM_RULES function_name=function name

Upload forms personalization:

FNDLOAD username/password 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct filename.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

echo "--Uploading XML File - XXMATERIAL.xml"

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD $P_APPS_PASSWD -JDBC_CONNECTION $jdbc -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME QL -LOB_CODE  XXMATERIAL_REP -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_CONTENT_TYPE 'text/html' -FILE_NAME XXMATERIAL.xml

echo "--Uploading RTF File - XXMATERIAL.rtf"

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD $P_APPS_PASSWD -JDBC_CONNECTION $jdbc -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME QL -LOB_CODE XXMATERIAL_REP -LANGUAGE en -TERRITORY 00 -XDO_FILE_TYPE RTF -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME  'XXMATERIAL.rtf' -CUSTOM_MODE FORCE

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

FNDLOAD Menu

Download  

FNDLOAD apps/psdapps  0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu name"

Upload

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD  0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct INV_NAVIGATE.ldt -CUSTOM_MODE=FORCE