Daniel Borgström.

FNDLOAD

· updated

This post describes how to down- and upload different components using FNDLOAD.

Value set

**Download
**FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct download_file.ldt VALUE_SET FLEX_VALUE_SET_NAME="VALUE_SET_NAME"

**
Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct download_file.ldt CUSTOM_MODE=FORCE

**
Note:** Use the optional FNDLOAD parameter P_VSET_DOWNLOAD_CHILDREN set to N if you do not want the value set values to be downloaded.

Concurrent Request

**Download
**FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct download_file.ldt PROGRAM APPLICATION_SHORT_NAME=``"APPL_SHORT_NAME" CONCURRENT_PROGRAM_NAME=``"REQUEST_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct download_file.ldt CUSTOM_MODE=FORCE

Note: If value sets are used by the request parameters the set up for them will also be included in the ldt-file. If the value set is not new it is recommended to remove the creation part from the upload file.

Request set

When using FNDLOAD for a request set it includes two parts, the request set definition and the request set linkage.

**Download
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct download_file_def.ldt REQ_SET REQUEST_SET_NAME="REQUEST_SET_NAME"

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct download_file_link.ldt REQ_SET_LINKS REQUEST_SET_NAME="REQUEST_SET_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct download_file_def.ldt CUSTOM_MODE=FORCE

FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct download_file_link.ldt CUSTOM_MODE=FORCE

**
Request Group**

**Download
**FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct download_file.ldt REQUEST_GROUP REQUEST_GROUP_NAME="REQUEST_GRP_NAME" APPLICATION_SHORT_NAME="APPL_SHORT_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct download_file.ldt CUSTOM_MODE=FORCE

**
Profile option**

**Download
**FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct download_file.ldt PROFILE PROFILE_NAME="PROFILE_NAME" APPLICATION_SHORT_NAME="APPL_SHORT_NAME"

**Upload
**FNDLOAD apps/appspwd O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct download_file.ldt CUSTOM_MODE=FORCE

**
Descriptive Flexfield**

**Download
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct download_file.ldt DESC_FLEX APPLICATION_SHORT_NAME="APPL_SHORT_NAME" DESCRIPTIVE_FLEXFIELD_NAME="DESC_FLEXFIELD_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct download_file.ldt CUSTOM_MODE=FORCE

**
Form and Function**

**Download
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct download_file.ldt FUNCTION FUNCTION_NAME=="FUNCTION_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct download_file.ldt CUSTOM_MODE=FORCE

**
Menu**

**Download
**FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct download_file.ldt MENU MENU_NAME="MENU_NAME"

**Upload
**FNDLOAD apps/appspwd O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct download_file.ldt CUSTOM_MODE=FORCE

Note: When a menu is downloaded all the entries in the menu will be included in the ldt-file. It is recommended to remove all the entries that are not new.

**
Message**

Download

FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct

download_file.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="APPL_SHORT_NAME" MESSAGE_NAME="MESSAGE_NAME"

**
Upload
**

FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct download_file.ldt CUSTOM_MODE=FORCE

**
Lookup value**

**Download
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct download_file.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="APPL_SHORT_NAME" LOOKUP_TYPE="LOOKUP_TYPE_NAME"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct download_file.ldt CUSTOM_MODE=FORCE

Folder

DownloadFNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct download_file.ldt FND_FOLDERS NAME="folder name"

**Upload
**FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/fndfold.lct download_file.ldt CUSTOM_MODE=FORCE

Note: When you download a folder you need to set the language to get any data in the ldt-file (how-to is specified under Generic Notes).

Forms personalization

**Download
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct download_file.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME="FUNCTION_NAME"

**Upload
**First, run the script to remove personalizations (the script have to be customized to remove the same data as you are uploading). We need to run this script because there is a bug in the upload script.

DECLARE

CURSOR cu_functions IS

SELECT DISTINCT

form_name

, function_name

, rule_type

, rule_key

FROM fnd_form_custom_rules

WHERE form_name = FORM NAME

ORDER BY function_name;

BEGIN

FOR ru_functions IN cu_functions

LOOP

fnd_form_custom_rules_pkg.delete_set

( ru_functions.rule_key

, ru_functions.rule_type

, ru_functions.function_name

, ru_functions.form_name

);

COMMIT;

END LOOP;

END;

FNDLOAD apps/appspwd 0 Y UPLOAD affrmcusx.lct download_file.ldt CUSTOM_MODE=FORCE

Note: The function name is the function short name as seen in the Function Definition Screen.

XML Publisher 
To handle the down- and upload of XML Publisher templates and Data Definitions there are a few extra steps to take care of. 

**Download – Template and Data Definition
**FNDLOAD apps/appspwd 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct download_file.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="APPL_SHORT_NAME" DATA_SOURCE_CODE="DATA_SOURCE_CODE"

**Download – Template physical file
**java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION apps.server:port:sid -APPS_SHORT_NAME app_short_name -LOB_CODE template_code -LOB_TYPE TEMPLATE -LANGUAGE language -TERRITORY territory

**Example
**java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION server1.cpm.com:1521:TEST -APPS_SHORT_NAME XX -LOB_CODE XX_AR_BALANCE_REP -LOB_TYPE TEMPLATE -LANGUAGE sv -TERRITORY SE

**Download – Data template physical file
**java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION apps.server:port:sid -APPS_SHORT_NAME app_short_name -DS_CODE data_definition_code

**Example
**java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION``server1.cpm.com:1521:TEST``-APPS_SHORT_NAME XX -DS_CODE XX_AR_BALANCE_REP

**Upload – Template and Data Definition
**FNDLOAD apps/appspwd 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct download_file.ldt CUSTOM_MODE=FORCE

**Upload – Template physical file
**java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION apps.server:port:sid -APPS_SHORT_NAME app_short_name -LOB_CODE template_code -LOB_TYPE TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME template_name.rtf -CUSTOM_MODE FORCE -LANGUAGE language -TERRITORY territory

**Example
**java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION``server1.cpm.com:1521:TEST``-APPS_SHORT_NAME XX -LOB_CODE XX_AR_BALANCE_REP -LOB_TYPE TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME XX_AR_BALANCE_REP.rtf -CUSTOM_MODE FORCE -LANGUAGE sv -TERRITORY SE

**Upload – Data template physical file
**java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION apps.server:port:sid -APPS_SHORT_NAME app_short_name -LOB_CODE data_definition_code -LOB_TYPE DATA_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME data_definition_name.xml -CUSTOM_MODE FORCE

**Example
**java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD appspwd -JDBC_CONNECTION``server1.cpm.com:1521:TEST``-APPS_SHORT_NAME XX -LOB_CODE XX_AR_BALANCE_REP -LOB_TYPE DATA_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME XX_AR_BALANCE_REP.xml -CUSTOM_MODE FORCE

Note

  • The valid valid for parameter LANGUAGE is sv for Swedish and en for English.

  • The valid valid for parameter TERRITORY is SE for Sweden and US for USA.

  • When you download the data definition physical file all the template files will be downloaded. 

  • Useful tables for XML P are XDO_TEMPLATES_B, XDO_LOBS and XDO_TEMPLATES_TL.

Generic notes

  • If the information you are downloading is not the same in English and Swedish you need to run the download command twice. Name your ldt-file with the ending _S (download_file_S.ldt) and _US (download_file_US.ldt).

    To download a specific language (other then English) you have to set NLS_LANG accordingly.
    Swedish: export NLS_LANG='SWEDISH_SWEDEN.WE8ISO8859P1'

  • If the information is the same in English and Swedish you only have to download once. Then create two files and name them accordingly. You need to change the LANGUAGE setting in the ldt-file to S for the _S-file and US for the _US-file.
    To get Swedish characters correct set export NLS_LANG='SWEDISH_SWEDEN.WE8ISO8859P1' before downloading.

  • Use upload parameter CUSTOM_MODE=FORCE to be sure that the informtion you are uploading is updating the system.FNDLOAD apps/appspwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct download_file.ldt - CUSTOM_MODE=FORCE