Digital beach
My little place on the web
Digital beach Blog / Articles Categories Tech Tips Using FNDLOAD from within Ebs
Using FNDLOAD from within Ebs
Written by Patrick van Zweden   

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.

Example

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

Field Value
Program XX FNDLOAD Concurrent Program
Short Name XXFNDLOADCONC
Application Application Object Library
Description Concurrent program to use FNDLOAD
Executable
Name FNDLOAD
Method Spawned

Now click the Parameters button.

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

Parameter
Description                                       
Mode

Operation mode of FNDLoad

Loader Configuration File
Configuration file FNDLoad needs to use
Data file
The data file
Entity
Which entity to load or download
Function
Extra function parameter

In screenshots this looks like:

Concurrent program window
Concurrent program window

Parameter Screen
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

Links:

Systems Administrator Guide
http://download.oracle.com/docs/cd/B25516_18/current/acrobat/115sacg.zip