Wednesday, December 14, 2011

FNDLOAD

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

2 comments:

  1. Good article. Like your explanation of using NLS_LANG on migrating language based entities. There is 3rd party tool FNDLOAD GUI called MigrationLogiK. Makes migrations very easy and well organized.

    ReplyDelete

javascript:void(0)