Page History
...
- Log in to your Oracle database with the APPLSYS account.
- 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'); - Run the following command to correct the errors:
update FND_PROFILE_OPTION_VALUES set PROFILE_OPTION_VALUE =
'begin veritas_custom_profile; end;'
wherePROFILE_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;'
wherelast_update_date=to_date ('13-JUL-75', DD-MON-YY');
- Commit the changes.
...