Skip to main content

FNDLOAD DOWNLOAD & UPLOAD COMMANDS

----------------------------------------------------------------
1 - Printer Styles
------------------
DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt

----------------------------------------------------------------
2 - Lookups
-------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”prod” LOOKUP_TYPE=”lookup name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

----------------------------------------------------------------
3 - Descriptive Flexfield with all of specific Contexts
-------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=:COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=”prod” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------------------
4 - Multiple Flexfields
------------

Use a combination of APPLICATION_SHORT_NAME and DESCRIPTIVE_FLEXFIELD_NAME names ie. APPLICATION_SHORT_NAME=PER >> will download all PER flexfields DESCRIPTIVE_FLEXFIELD_NAME=PER_% >> will download all flexfields that start with 'PER_'.

DOWNLOAD Command:

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME="PER_%"

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------------------
5 - Key Flexfield Structures
------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=:COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=”prod” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------------------
6 - Concurrent Programs
------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”PER” CONCURRENT_PROGRAM_NAME=”concurrent name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt

----------------------------------------------------------------
7 - Value Sets
------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------------------
8 - Value Sets with values
-------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------------------
9 - Profile Options
---------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”prod”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt

----------------------------------------------------------------
10 - Request Group
----------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”prod”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt

----------------------------------------------------------------
11 - Request Sets
----------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”prod” REQUEST_SET_NAME=”request set”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt

----------------------------------------------------------------
12 - Responsibilities
----------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility"

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt

----------------------------------------------------------------
13 - Responsibilities with all Security Groups
------------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER USER_NAME="<USER>" SECURITY_GROUP=% DATA_GROUP_NAME=%

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD FND_TOP/patch/115/import/afscursp.lct file_name.ldt

----------------------------------------------------------------
14 - Menu
------------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt

----------------------------------------------------------------
15 - Forms/Functions/Personalizations
------------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>
OR
FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION FUNCTION_NAME=<function_name>
OR
FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FORM FORM_NAME=<form_name>
OR
FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct filename.ldt
OR
FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt

----------------------------------------------------------------
16 - User/Responsibilities
-------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt

----------------------------------------------------------------
17 - Alert
--------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct my_file.ldt ALR_ALERTS APPLICATION_SHORT_NAME=FND ALERT_NAME=Alert name to download

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct my_file.ldt

----------------------------------------------------------------
18 - UPLoad an NLS Language
------------
DOWNLOAD Command:

  a. set NLS_LANG and NLS_TERITTORY and download the required using DOWNLOAD command as specified in the page.

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD <controlfile.lct> file_name.ldt -UPLOAD_MODE=NLS CUSTOM_MODE=FORCE WARNINGS=TRUE

----------------------------------------------------------------
21 - Migrate the role registration process from one instance to another
------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> O Y DOWNLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> O Y UPLOAD $FND_TOP/patch/115/import/umxrgsvc.lct umxrgsvc.ldt UMX_REG_SERVICES REG_SERVICE_CODE UMX

----------------------------------------------------------------
22 - Transfer Custom Messages to another Instance
---------------

DOWNLOAD Command:

FNDLOAD apps/<apps_password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND MESSAGE_NAME=PASSWORD-INVALID-NO-SPEC-CHAR

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD apps/<apps_password> 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND CUSTOM_MODE=FORCE

----------------------------------------------------------------
23 - Download UMX Roles and Role Assignment data from one instance and upload to another.
------------

DOWNLOAD Command:

FNDLOAD <username/pwd@sid> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afrole.lct umxroles.ldt WF_ROLE ORIG_SYSTEM=UMX%

UPLOAD Command:

Move the .ldt file to the target instance

FNDLOAD <username/pwd@sid> 0 Y UPLOAD $FND_TOP/patch/115/import/afrole.lct umxroles.ldt
----------------------------------------------------------------
Labels:

Comments

Post a Comment

Popular posts from this blog

Node id does not exist for the current application server id

Issue: After completing cloning procedure, you generally may across the following issue. "Node id does not exist for the current application server id". Solution: First stop the application. Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance. Start the application and test your issue. Location of script: 11i: $COMMON_TOP/admin/install/$CONTEXT_NAME R12: $INST_TOP/admin/install [appldev@erptest install]$ sh adgendbc.sh (Note: It will prompt you to give apps username and apps password.)
Post a Comment
Read more

How to change EBS R12 database and application port number

On Database Tier 1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME 2. Start database instance for which you want to change R12 port 3. Backup contextfile 4. Change as below in contextfile         dbport  : Change database port from 1521 to 1541         db_ons_localport : 6300 to 6320         db_ons_remoteport : 6400 to 6420         cmanport : 1521 to 1541 5. Run adautocfg.sh On Apps Tier Change Application port from 8000 to 8020 1. Logon as application manager user and source environment for R12 2. Backup contextfile 3. Run adpreclone    $ perl ./adpreclone.pl appsTier 4. Run adcfgclone and choose new port pool    $ cd $COMMON_TOP/clone/bin    $ perl ./adcfgclone.pl appsTier 5. Check new application URL SQL> select home_url from icx_parameters; HOME_URL ----------...
Post a Comment
Read more

Oracle R12 : You are trying to access a page that is no longer active

Login fails “You are trying to access a page that is no longer active.” The issue can be reproduced at will with the following steps: Issue : After cloning process the login page of Oracle E-Business Suite R12 show the above error. Solution :  For this you need to update the new hostname in the  icx_parameteres table 1.   SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- erp.local.com (This is hostname of Source Application Tier) 2. SQL>update icx_parameters set SESSION_COOKIE_DOMAIN = ‘target.local.com’; 1 row updated. SQL> commit; Commit complete. (This has changed the SESSION_COOKIE_DOMAIN of target application to target hostname.domain_name) 3. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- target.local.com
Post a Comment
Read more