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:
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