- OracleApps Epicenter - http://www.oracleappshub.com -

Its all about FNDLOAD

What is Data Synchronization ?

Data Synchronization is a process in which some setup data would be synchronized, and this would be more important when you are working in oracle application development/implementation project? The equally important that AOL data Migration takes place necessary to synchronize the data across databases instance during

Then… What.. FNDLOAD

Yes, that is one and only oracle solution. It can be defined as a concurrent program that can move Oracle Applications data between database and text file representations. Or this can be defined as FNDLOAD can 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 confirmation file and it is important to just pass the configuration file name and then just call the loader and leave everything .The schematic visual representation of the loader is like:

What can be done?

These are the extensive list which can be done through FNDLOAD

Then…what are advantages when using FNDLOAD are :

  1. Because downloaded data is stored in a text file, version administration is possible
  2. There is nothing to worry to go to purchase because..Investment = 0$
  3. No learning curve. this is relief for developer/dba’s
  4. Fully supported and recommended by Oracle
  5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
  6. Pin-point when something happened and where (database) easily
  7. Your AOL data migration process is now simplified and streamlined – goal attained!!

And these are some Disadvantages also :

  1. Applications patching mechanisms use FNDLOAD heavily – possibility of negative impact is not zero
  2. UPLOAD_MODE=REPLACE only for menus
  3. No validation against migrating database/instance sensitive data

The Syntax

To use FNDLOAD, the following syntax is needed.

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

As you can see, some info is needed.- First you will need to know the Apps password.

Modes of Operation

This is important because it would drive the whole flow, and it always be two mode .. Upload and Download…

Example of download:

FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_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

WHAT IS FNDLOADLoad Options:

  • Application level OR single entity level download
    • (Example) Download all the profile options of Inventory or just the INV: Default Primary UOM
  • Entire OR Partial upload of a data file
    • (Example) Upload the entire myfile.ldt or just a single enity indicated by - and mode UPLOAD or UPLOAD_PARTIAL
    • Entity name required for UPLOAD_PARTIAL mode
  • Custom mode force update
    • To override Oracle's upload algorithm and update the custom AOL data regardless, use CUSTOM_MODE= FORCE
    • UPLOAD_MODE= REPLACE (only for menus)
  • Support for NLS uploads
    • NLS data uploads for translated columns are supported, use UPLOAD_MODE= NLS

Then ..Where is Config File Located

By default Oracle delivers most of configuration files you can use to download certain entities.

and..FNDLOAD File Structures is

Take a note FNDLOAD File Structures

..Remember regarding FNDLOAD Files

Sample Script Code for these Objects :

1 - Printer Styles

FNDLOAD apps/apps@seed115 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@seed115 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/apps@seed115 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/apps@seed115 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="prod" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5 - Concurrent Programs

FNDLOAD apps/apps@seed115 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/apps@seed115 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/apps@seed115 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/apps@seed115 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/apps@seed115 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/apps@seed115 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/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility

12 - Menus

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

13 – Forms/Functions

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

14. User/Responsibilities

FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER [<USER>]

References:

37 Comments (Open | Close)

37 Comments To "Its all about FNDLOAD"

#1 Comment By siddh On January 23, 2007 @ 3:37 pm

Hi,

Is there anyway I can downlaod telesales dashboard objects like profile check variables, profile check and drilldowns using FNDLOAD?
If there is a way, can you give me one or two examples of download on cscprfbk.lct and cscprfck.lct?

Thanks.
-Siddh

#2 Pingback By Great FNDLOAD – Part -II On August 25, 2007 @ 12:03 am

[…] have already posted note on FNDLOAD utility for doing movement of application setup data from one database to the other.There are instances when we need to move some AOL and seeded data from one Environment to another […]

#3 Comment By Justin On September 19, 2007 @ 3:22 am

Hi ,
This is very informative article. Many thanks !!!

Is there any FNDLOAD command available which will download the concurrent program along with the Request Groups to which the program is been attached. So when we upload that LDT it will both upload the Concurrent Program and also attach it to respective responsibilities as well.

Awaiting for your reply.

#4 Comment By Ash On October 17, 2007 @ 12:28 pm

Is there a way to migrate flexfield definitions from Oracle Apps 11.0.3 to 11i. I believe FNDLOAD is not available in 11.0.3. Is there a work around? Can you suggest something?

#5 Comment By Raman On November 12, 2007 @ 3:54 am

it is good information.

#6 Comment By Niel On December 18, 2007 @ 5:52 am

Hi,

Can we add the concurrent program to the already existing (standard) request group (offcourse using FNDLOAD…or something automated)?

Awaiting reply

#7 Comment By Sanjit Anand On December 18, 2007 @ 6:28 am

Niel,

you can add it with existing requset group, by either options, directly from front end or FNDLOAD.

use afcprset.lct to download and upload.

#8 Comment By Narasimha On January 7, 2008 @ 3:59 am

Hi,
Good information.

We have a requirement to pass the password to the FNDLOAD command and keep it hidden so the password is not revealed when checking the process status via “ps -aex |grep -i FNDLOAD”.

Any inputs on how we could achieve this please?

Thanks,
Narasimha

#9 Comment By Ganesh On February 14, 2008 @ 2:35 am

Is it possible to rename the existing concurrent program through FND_LOAD?

#10 Comment By Sanjit Anand On February 14, 2008 @ 3:14 am

ganesh,

Oracle does not have provided any capability to rename the existing concurrent program name.
The idea of FNDLOAD is to migration, renaming of concurrent program can be treating brand new name defination.

The best options is that you can rename either Pre-migration in source instance or post migration in Target instance.

Hope you understand.
sanjit

#11 Comment By Phani B Reddy On February 27, 2008 @ 2:14 am

Its very nice having all information @ one place.
But its better if we add FNDLOAD information for DATA DEFINITIONS and TEMPLATES.

Hope my request will be considered

#12 Comment By Deepa Tiwari On March 5, 2008 @ 8:52 am

Phani,

Here is the script for download and upload of Data definitions and template
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

Hope this helps.
Deepa

#13 Comment By Deepa Tiwari On March 5, 2008 @ 11:28 am

Please refer the user guide for XDOLoader command to upload and download Template files.

Deepa

#14 Comment By Deepa Tiwari On March 6, 2008 @ 8:30 am

Sanjit,

is afcprset.lct to be used to download and upload request groups specific program or is is afcpreqg.lct with the REQUEST_GROUP_UNIT parameters

Deepa

#15 Comment By Sanjit Anand On March 6, 2008 @ 9:47 pm

deepa, check the corresponding lct file from this extended list.
[1]

sanjit

#16 Comment By KjartanMS On March 12, 2008 @ 10:23 am

Hi
Is there any documentation on how the P_LEVEL argument is to be structured when downloading Key Flexfields etc?

#17 Comment By sreekanth On April 9, 2008 @ 12:31 am

Hi friends.
I need to migrate concurrent programs from one instance to another.
I have tried FND_LOAD and it is working fine.
The problem is i am able to migrate only one concurrent program at a time.
Is there a way to migrate all the concurrent programs of an application at once by creating a request group?
what are the changes to be made in DOWNLOAD and UPLOAD commands?

#18 Comment By Barbara On May 9, 2008 @ 10:32 am

To migrate Request Sets I thought you need 2 scripts one for the set and one for the links. However none is working

#19 Comment By Sanjit Anand On May 9, 2008 @ 10:59 am

hey Barbara,

I donot think you will really requited to program. i did sometime till 11.5.7 but after than afcprset.lct was greatly enhanced.

simply use this script: and uploading change the mode from download to upload.

FNDLOAD apps/@hoststring 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct custom_request_set.ldt REQ_SET REQUEST_SET_NAME=””

#20 Comment By Sanjit Anand On May 9, 2008 @ 11:01 am

There is one note in metalink , which is bit older did mention two step process.

This is what metalink suggested:

1. Download Request Set definitions (Using Entity ‘REQ_SET’)

$FNDLOAD sqllogon 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct
.ldt REQ_SET REQUEST_SET_NAME=’ ‘

Usage of entity ‘REQ_SET’with FNDLOAD will download request
definitions of into .ldt using
information in afcprset.lct.
Check the version of afcprset.lct it needs to be the same on source and target.
2. Download Request Set Stage links information. (Using Entity ‘REQ_SET_LINKS’)

$FNDLOAD sqllogon 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct
ldt REQ_SET_LINKS REQUEST_SET_NAME=”

Usage of entity ‘REQ_SET_LINKS’ with FNDLOAD will download request
stage linkage information of into .ldt
using information in afcprset.lct.
Check the version of afcprset.lct it needs to be the same on source and target.
Now,use the resultant files .ldt and .ldt for uploading the Request Set data in another Instance,

by using the commands given below in the following sequence:

3. Upload Request Set definitions.

$FNDLOAD apps/ 0 Y UPLOAD @FND:patch/115/import/afcprset.lct
.ldt

4.Upload Request Set Stage links information.

$FNDLOAD apps/ 0 Y UPLOAD @FND:patch/115/import/afcprset.lct
.ldt

All the required Concurrent Program definitions should exist before loading the Request Set on the Target Instance.

#21 Comment By Sanjit Anand On May 9, 2008 @ 11:05 am

i have checked the .lct file , it should not be in 2 steps.

see items #11, from list updated one.

#22 Comment By Gianni Nieri On May 26, 2008 @ 8:08 am

Hi!

I have problems when I use the FNDLOAD because I do all my downloads from ESA language but FNDLOAD always makes from US language, there are any tip for this?

#23 Comment By sreekanth nunagala On June 12, 2008 @ 9:19 pm

Hi friends,
I have used FNDLOAD to migrate concurrent programs.Till now i am able to migrate only one concurrent program at a time.
How to migrate more than 1 concurrent program at a time?

#24 Pingback By Migration of XMLPub Templates :XDOLOADER Utility On June 14, 2008 @ 12:57 am

[…] to upload this metadata to another instance. The FNDLOAD program requires a control file (lct) as discussed earlier that XML Publisher provides for use with its objects. The file which is used called xdotmpl.lct and […]

#25 Pingback By FNDLOAD for AME’s On June 14, 2008 @ 3:49 am

[…] groups etc. from one instance to another instance, you can use some of them by mean of FNDLOAD utility. The process is similar to what we are regularly using for other AOL […]

#26 Comment By Phanupong On July 24, 2008 @ 2:29 am

Anyone can help me pass this situation…. i’ve been setup DFF before uploaded by FND_LOAD to other instance. but the Qualifier doesn’t appear
[Menupath] -> Setup-Financials-Flexfields-Validations-Values-(Tab)Values,Hierarchy,Qualifiers -(Field)-Qualifiers-(Click)-Allow Posting,Account Type are Null…..

So i have to manual setup its..

Please help me and Thanks for informations

Phanupong

#27 Comment By Nicole On December 18, 2008 @ 1:54 pm

Hello,

Can FNDLOAD be used to download/upload a custom payment program. We are currently using EBS 11.5.10.2.

#28 Pingback By FNDLOAD: ….exporting Oracle Alert | OracleApps Epicenter On May 7, 2009 @ 9:30 pm

[…] Its all about FNDLOAD […]

#29 Comment By Michael On July 19, 2009 @ 4:13 am

Hi,

I have uploaded a value set and it merge the contents of destination child values with source child values. please help he solve this problem, I want only the source value not the destination.

Regards,
Michael

#30 Comment By Michel Orsel On January 25, 2010 @ 3:58 am

To download in other language then default you van change NLS_LANG before using FNDLOAD.

for downloading the defenitions in dutch I use:

export NLS_LANG=Dutch_America.WE8ISO8859P1

#31 Comment By Nick On February 18, 2010 @ 5:44 pm

Time to move from command mode FNDLOAD to GUI FNDLOAD. Much more convenient and efficient. All your objects are packed into a project. Try free for 30 days or more from [2]

New features coming weekly.

#32 Comment By Panggih On June 22, 2010 @ 8:06 am

What a great site/page….
A lot of info about FNDLOAD/XDOLOAD in one place.

Just Great!!

cheers

#33 Comment By Rahul On October 7, 2010 @ 10:39 pm

Very good article….it helped me alot .Thanks

#34 Comment By Mark On December 5, 2010 @ 10:23 am

GUI support Oracle EBS Migrations. Unique abilities and minimal learning curve. migrationLogik – GUI for FNDLOAD, XDOLOADER and DB objects.

#35 Comment By MArk On December 15, 2010 @ 9:28 pm

MigrationLogiK GUI tool provides very efficient and intuitive way to migrate Oracle EBS custom objects.

#36 Comment By Mohan On September 9, 2011 @ 2:43 am

Hi All,
Thanks for the article,but still i wants to know about the meaning for 0 and Y.

Thanks
Mohan

#37 Comment By fredy On January 15, 2013 @ 4:54 am

can xml publisher be migrated from UAT to production??