Page History

...

1. Log in to your Oracle database with the APPLSYS account.
2. Run the following command to view erroneous text: Select * from FND_PROFILE_OPTION_VALUES where PROFILE_OPTION_VALUE like '%veritas%';
   You may search for any expression by replacing '%veritas%' in the where clause with the string you are looking for. For example, to search for the profiles that were entered on July 13, 1975, execute the following command:
   Select * from FND_PROFILE_OPTION_VALUES where last_update_date=
to_date ('13-JUL-75', 'DD-MON-YY');
3. Run the following command to correct the errors:
   update FND_PROFILE_OPTION_VALUES set PROFILE_OPTION_VALUE =
'begin veritas_custom_profile; end;'
   where PROFILE_OPTION_VALUE like '%veritas%';
   You may update any expression by replacing '%veritas%' in the where clause with the string you are looking for. For example, to update all profiles that were entered on July 13, 1975, execute the following command:
   update FND_PROFILE_OPTION_VALUES set PROFILE_OPTION_VALUE='begin veritas_custom_profile;end;' where last_update_date=to_date ('13-JUL-75', DD-MON-YY');
4. Commit the changes.

Precise. Performance intelligence from click to storage. Learn more > >

IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal