FNDLOAD Download and Upload Commands For Different AOL Components
These are the extensive list which can be done through FNDLOAD
• Concurrent Programs, Executables
• Request Groups, Request Sets
• Profile Options
• Key and Descriptive Flexfields
• Menus and Responsibilities
• Forms and Form Functions
• Attachments
• Messages
• Value Sets and Values
• Lookup Types
• User Responsibilities
• Printer Definitions
• FND Dictionary
• Help Configuration
• Document Sequences
• Concurrent Manager Schedules
Syntax
To use FNDLOAD, the following syntax is needed.
FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter]
As you can see, some info is needed.- First you will need to know the Apps password.
• The mode is either DOWNLOAD or UPLOAD.
• The configfile is the file that Fndload needs to download on upload data.
• T he data file is the output file, in which the downloaded data is written
• The entity is the entity you want to download
LDT Commands for Upload and Download of Programs:
Please Change the USERNAME,PASSWORD,JDBC Connection values in the following commands as per
instance.
Download for Concurrent Program:
FNDLOAD <Database User name>/<Data Base Password> O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct <file_name>.ldt PROGRAM
APPLICATION_SHORT_NAME=<Application
_shot_name> CONCURRENT_PROGRAM_NAME=<Program_short_name>
Example :
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct TEST_CP.ldt PROGRAM
APPLICATION_SHORT_NAME="ONT" CONCURRENT_PROGRAM_NAME="XX_TEST"
Upload for Concurrent Program:
FNDLOAD USERNAME/PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
<File_Name>.ldt
Example: FNDLOAD USERNAME/PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
TEST_CP.ldt
2.Conc program assignment to Request Group
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]'
APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT
UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='P' UNIT_NAME='[Concurrent program
Short Name]’
Example :
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct TEST_RG.ldt
REQUEST_GROUP REQUEST_GROUP_NAME='Receivables All' APPLICATION_SHORT_NAME='AR'
REQUEST_GROUP_UNIT UNIT_APP='AR' UNIT_TYPE='P' UNIT_NAME='XXTEST'
Upload:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <Program_Name>.ldt
Example: FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_TEST_RG.ldt
3. To download Ldt file for a Data Definition
FNDLOAD [username]/[password] O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'
DATA_SOURCE_CODE='[Data Definition Short Name]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt
Download Data Template :
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD =DB_USERNAME apps =DB_PASSWORD apps
=JDBC_CONNECTION
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONN
ECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' =LOB_TYPE DATA_TEMPLATE =LOB_CODE
XX_TEMPLATE =APPS_SHORT_NAME XXCUST =LANGUAGE en =lct_FILE
$XDO_TOP/patch/115/import/xdotmpl.lct =LOG_FILE $LOG_FILE_NAME
Upload Data Template :
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME USERNAME \
-DB_PASSWORD PASSWORD \
-JDBC_CONNECTION "JDBC Connection " \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME ONT \
-LOB_CODE XX_INVENTORY_EXTRACT \
-LANGUAGE 00 \
-TERRITORY 00 \
-XDO_FILE_TYPE XML-DATA-TEMPLATE \
-NLS_LANG en \
-FILE_CONTENT_TYPE text/xml \
-FILE_NAME XX_INVENTORY_EXTRACT.xml \
-CUSTOM_MODE FORCE \
-LOG_FILE >> XX_INVENTORY_EXTRACT.log
RTF TEMPLATE
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD =DB_USERNAME apps =DB_PASSWORD apps
=JDBC_CONNECTION
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONN
ECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' =LOB_TYPE TEMPLATE =LOB_CODE XX_TEMPLATE
=APPS_SHORT_NAME XXCUST =LANGUAGE en =TERRITORY US =lct_FILE
$XDO_TOP/patch/115/import/xdotmpl.lct =LOG_FILE $LOG_FILE_NAME
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME USERNAME \
-DB_PASSWORD PASSWORD \
-JDBC_CONNECTION " JDBC Connection " \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME ONT\
-LOB_CODE XX_INVENTORY_EXTRACT \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE RTF \
-NLS_LANG en \
-FILE_CONTENT_TYPE 'application/rtf' \
-FILE_NAME XX_INVENTORY_EXTRACT.rtf \
-CUSTOM_MODE FORCE \
-LOG_FILE >> XX_INVENTORY_EXTRACT.log
4. To download Ldt file for a Request Set
FNDLOAD [username]/[password] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct
file_name.ldt REQ_SET REQUEST_SET_NAME='[REQUEST_SET_SHORT_NAME]'
Upload :
FNDLOAD [username]/[password] 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct
file_name.ldt
6. To download Ldt file for a Lookup Up
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct
file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'
LOOKUP_TYPE='[LOOKUP_TYPE]'
Upload :
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt
8. To download Ldt file for a request group for a Request Set
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='[REQUEST_GROUP_NAME]'
APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]' REQUEST_GROUP_UNIT
UNIT_APP='[UNIT_APPLICATION_SHORT_NAME]' UNIT_TYPE='S' UNIT_NAME='[Request Set Name]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt
9. To download Ldt file for a Value Set
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
10. To download Ldt file for a Value Set with values
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='[VALUE_SET_NAME]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
11. To download Ldt file for a DFF
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'
DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' P_CONTEXT_CODE='[Context Code]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
12. To download Ldt file for a DFF for a particular attribute column
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'
DESCRIPTIVE_FLEXFIELD_NAME='[flex field Name]' DESCRIPTIVE_FLEX_CONTEXT_CODE='[Context
Code]' END_USER_COLUMN_NAME='[Attribute Column Name]'
APPLICATION_COLUMN_NAME='[attribute column number]'
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
13. To download Ldt file for a profile Option
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct
file_name.ldt PROFILE PROFILE_NAME='[PROFILE_OPTION_NAME]'
APPLICATION_SHORT_NAME='[APPLICATION_SHORT_NAME]'
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
14. To download Ldt file for a Responsibility
FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct
file_name.ldt FND_RESPONSIBILITY RESP_KEY="[Responsibility Name]"
Upload:
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt
15.Alerts
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_BLOG_ALR.ldt
ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX = Alert Name"
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_BLOG_ALR.ldt
CUSTOM_MODE=FORCE
16.Form Personalization
Download:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"
Upload:
FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXGLJOURNALIMP.ldt
17.Forms:
Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFRMNAME.ldt FORM
APPLICATION_SHORT_NAME="PN" FORM_NAME="XXFRMNAME"
Upload:
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct XXFRMNAME.ldt
18.Functions:
Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFUNNAME.ldt
FUNCTION FUNC_APP_SHORT_NAME="PN" FUNCTION_NAME="XXFUNNAME"
Upload
FNDLOAD apps/apps O Y UPLOAD @FND:patch/115/import/afsload.lct XXFUNNAME.ldt
19. Descriptive flex field
Download:
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
XX_OA_EXP_RPT_SEG_MAP_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="FND"
DESCRIPTIVE_FLEXFIELD_NAME="FND_COMMON_LOOKUPS"
DESCRIPTIVE_FLEX_CONTEXT_CODE="XX_OA_EXP_RPT_SEG_MAP"
Upload:
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct
XX_OA_EXP_RPT_SEG_MAP_DFF.ldt
20: Key Flexfields
Download
FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct filename.ldt
KEY_FLEX APPLICATION_SHORT_NAME='short name' DESCRIPTIVE_FLEXFIELD_NAME='flexfield name'
Upload
FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct filename.ldt
