Preserving Custom Menus During 10SC Upgrade

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.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.