FNDLOAD FNDLOAD Executable Reference: 274667.1 / 287417.1 Definition: The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file. The loader reads a configuration file to determine which entity to access. This can be defined as FNDLOAD can be download data from an application entity into an editable text file, which can be uploaded to another database. How it works Conversion between database format and text file format is specified by a configuration file. Oracle does provide configuration file and it is important to just pass the configuration file name and then call the loader and leave everything. What can be done by FNDLOAD? There are the extensive lists which can be done through FNDLOAD. • • • • • • • • • • • • • • • • • • •
Concurrent Programs, executables Request Group, Request Sets Profile Options Key and Descriptive FlexFields Menu and Responsibilities Forms and Form Functions Value Sets and Values Lookup Types User Responsibilities Users (FND_USERS) Printer Definitions FND Directory Help Configuration Document Sequences Concurrent Manager Schedules Form Personalization Attachments Messages WEB ADI
The Syntax FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameters …] • The mode is either DOWNLOAD or UPLOAD • The configfile is the file that FNDLOAD needs to download or upload data. • The datafile is the output file, in which the downloaded data is written. • The entity is the entity you want to download • Parameters value is passed to download a certain Alert Where is configfile located Usually in $FND_TOP/patch/115/import File Extension Configfile extension is .lct And Datafile extension is .ldt Example of download FNDLOAD apps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=
Example of upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt CUSTOM_MODE=FORCE undocumented parameter
Sample Scripts: 1 - Printer Styles FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name" 2 – Lookups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"
3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps O 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="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name" $ FNDLOAD apps/password 0 Y DOWNLOAD @FND:admin/import/afffload.lct output.ldt DESC_FLEX APPLICATION_SHORT_NAME="JG" DESCRIPTIVE_FLEXFIELD_NAME="JG%" P_LEVEL="COL_ALL:REF_ALL:CTX_ONE" P_CONTEXT_CODE="JA%" 4 - Key Flexfield Structures FNDLOAD apps/apps O 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="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name" 5 - Concurrent Programs FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name" 6 - Value Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name" 7 - Value Sets with values FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name" 8 - Profile Options FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND" 8 - Request Groups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"
10 - Request Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"
11 - Responsibilities FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility" 12 – Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name" 13 – Data Definitions and Templates (XML Reports) FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_MY_DATA_DEF_NAME.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=”XXASN” DATA_SOURCE_CODE=”XX_MY_DATA_DEF_NAME”
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_MY_DATA_DEF_NAME.ldt 14 – Form Personalization FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name=”FUNCTION_NAME”
Customization Possibilities: select "FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME='FND' CONCURRENT_PROGRAM_NAME=""||concurrent_program_name||"" from FND_CONCURRENT_PROGRAMS WHERE CONCURRENT_PROGRAM_NAME LIKE ‘MLS%’;
Quick Reference
SL# 1 2 3 4 5 6 7 8 9
Object Name
LCT file
Entity
afscursp.lct afscprof.lct $BNE_TOP/admin/import/bneint.lct afcppstl.lct
FND_USER PROFILE BNE_INTEGRATORS
USER_NAME=’MLS’ PROFILE_NAME=
aflvmlu.lct
FND_LOOKUP_TYPE
Flexfield data Concurrent Program Definitions Security data Function Security Data
afffload.lct afcpprog.lct
VALUE_SET PROGRAM
VIEW_APPSNAME LOOKUP_TYPE FLEX_VALUE_SET_NAME
afscursp.lct afsload.lct
FORM
FUNCTION
10 11
Parameters
Move user definition Profile option WEB ADI Concurrent Program Printer Styles Lookup types and codes
Forms Personalization Data Definition & Template
affrmcus.lct $XDO_TOP/patch/115/import/xdotmpl.lct
MENU MENU_ENTRY OBJECT OBJECT_INSTANCE_SET GRANT FND_FORM_CUSTOM_RULES XDO_DS_DEFINITIONS
Metalink References: 274667.1 - FNDLOAD Commands to Download Deferent Seeded Data Types 287417.1 – Parameters of Different Configuration Files to Download and Upload Seed Data Types.
APPLICATION_SHORT_NAME FORM_NAME UPLOAD_MODE: NLS FUNC_APP_SHORT_NAME FUNCTION_NAME MENU_NAME
function_name DATA_SOURCE_CODE