Using FNDLOAD from within Ebs

When you want to copy developed (functional) items from one instance to another, for example from the acceptance environment to production, FNDLOAD is a great tool to use. Everything is copied in an instant and you’re quite sure that it is exactly as the set-up you had in the other environment.

The only thing is….. you normally need access to the applications tier to execute the FDNLOAD command. 

It is possible to start FNDLOAD from within the e-Business Suite. Just create a concurrent program and make sure you can specify the parameters you want. The following example creates a concurrent program with which you can execute FNDLOAD to your wishes.


Using the System Administrator responsibility navigate to the Concurrent Programs form (Concurrent → Program → Define) and fill it in according to the following table:

ProgramXX FNDLOAD Concurrent Program
ApplicationApplication Object Library
DescriptionConcurrent program to use FNDLOAD

Now click the Parameters button.

We need to specifiy a few parameters to make FNDLoad work.

ModeOperation mode of FNDLoad
Loader Configuration FileConfiguration file FNDLoad needs to use
Data fileThe data file
EntityWhich entity to load or download
FunctionExtra function parameter

In screenshots this looks like:

Concurrent program windown
Parameters window

We can now use the created program to execute FNDLoad. As you’ve probably noticed there is no need to specify the apps user and password. The only thing you need is a folder from where you can read your data or write your data to.
On Windows platforms this is quite easy. Just give a UNC as parameter for the loader configuration file and/or the data file. On *NIX platform you need access to a folder on the server (or a mounted network path).

For more info about using the FNDLoad utility, look in the Oracle Application Systems Administrator Guide (B13925-06), Appendix B


Systems Administrator Guide