let's talk about FNDLOAD utility

FNDLOAD is an API provided by Oracle to download/upload Flexfields Concurrent programs Value sets Menu etc.

Using FNDLOAD, we can download data from an application and upload into another application. Example: I have created a concurrent program in DEV instance and to move that concurrent program into TEST/Production instance I can’t create that program again. So I will download it from DEV instance and upload into TEST instance by using FNDLOAD utility.

Below list of programs can be download/upload with this FNDLOAD API.

1. Concurrent Programs, Executables

2. Request Groups, Request Sets

3. Profile Options

4. Key and Descriptive Flex fields

5. Menus and Responsibilities

6. Forms and Form Functions

7. Attachments

8. Messages

9. Value Sets and Values

10. Lookup Types

11. User Responsibilities

12. Printer Definitions

13. FND Dictionary

14. Help Configuration

15. Document Sequences

16. Concurrent Manager Schedules

The Syntax

FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1.....]

The mode is either DOWNLOAD or UPLOAD.

Note: execute the below command before download/upload fndload’s

In CUSTOM APPLICATION TOP: - . APPSORA.env and then come back to /tmp folder cd /tmp

$ cd / à $ ls à $ cd apptestà $ cd oracle11ià $ cd testapplà $ . APPSORA.env

Example of download:

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="XX_TOP" CONCURRENT_PROGRAM_NAME="SHORTNAME"

Example of Upload

FNDLOAD apps/pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct filename.ldt

Sample Script Code for these Objects :

1 - Printer Styles

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE
APPLICATION_SHORT_NAME="prod" LOOKUP_TYPE="lookup name"

3 - Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/pwd 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="prod"
DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context
name"

4 - Key Flexfield Structures

FNDLOAD apps/pwd 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:SH A_ALL:CVR_ALL:SEG_ALL
? APPLICATION_SHORT_NAME="prod" ID_FLEX_CODE="key flex code"
P_STRUCTURE_CODE="structure name"

5 - Concurrent Programs

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM
APPLICATION_SHORT_NAME="prod" CONCURRENT_PROGRAM_NAME="concurrent name"

6 - Value Sets

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET
FLEX_VALUE_SET_NAME="value set name"

7 - Value Sets with values

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE
FLEX_VALUE_SET_NAME="value set name"

8 - Profile Options

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE
PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="prod"

9 - Requset Group

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP
REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="prod"

10 - Request Sets

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="prod" REQUEST_SET_NAME="request set"

11 - Responsibilities

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY
RESP_KEY="responsibility

12 - Menus

FNDLOAD apps/pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU
MENU_NAME="menu_name"

13 - Forms/Functions

-- Scripts to DOWNLOAD Form

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct /home/Aitupdev/Ganesh/ICSSFORM.ldt \
FORM FORM_APP_SHORT_NAME='ICIGS' FORM_NAME='ICSSAR%'

-- Scripts to UPLOAD Form
FNDLOAD apps/$APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $ICFND_TOP/bin/ICSSMENU.ldt

-- Scripts to DOWNLOAD Function

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct /home/Aitupdev/Ganesh/ICSSFUNC.ldt
FUNCTION FUNC_APP_SHORT_NAME='ICIGS' FUNCTION_NAME='ICSSAR%'

-- Scripts to UPLOAD Function
FNDLOAD apps/$APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $ICFND_TOP/bin/ICSSMENU.ldt

14. User/Responsibilities

FNDLOAD apps/pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility

15. Forms personalizations

Can be done thru form level or function level.

FNDLOAD apps/pw 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct xxns_poxrqerq_2.ldt FND_FORM_CUSTOM_RULES form_name=POXRQERQ

Or function level

Source:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXFPNAME.ldt FND_FORM_CUSTOM_RULES function_name="XXFPNAME"

Target:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXFPNAME.ldt

.lct files list 