To preserve customization to the SmartClient menus, you need to run the Function Security Loader (FNDSLOAD) executable to
extract the custom menu's in a file prior to upgrade and run FNDSLOAD after upgrade to upload the individual menus or all
menus attached to all responsibilities registered under a given application. The FNDSLOAD executable is available under
$FND_TOP/$APPLBIN directory.

Run FNDSLOAD to extract the menu definitions from the database to a text file. For example:

FNDSLOAD userid/Password 0 Y LOCAL menufile DOWNLOAD CUSTOMMENU

where 'menufile' is the name of the export file and 'CUSTOMMENU' is the name of the custom menu to be extracted.

The other option is to download all the menus under particular responsibilties by running the following command:

FNDSLOAD userid/Password 0 Y LOCAL menufile DOWNLOAD CUSTOMRESP

where 'menufile' is the export filename and 'CUSTOMRESP' is the shortname for the application of the SmartClient
responsibilities under which all menus are to be extracted.

After the upgrade, run FNDSLOAD again to restore the menu definitions from the text file onto the database.For example:

FNDSLOAD Userid/Password 0 Y LOCAL menufile INSERT

where 'menufile' is the text filename.

This command will only INSERT the menus and won't be updating any existing menus.

Return to : Oracle Database, SQL, Application, Programming Tips