Site Name profile option Update from backend

SQL> select profile_option_value from apps.FND_PROFILE_OPTION_VALUES where profile_option_id = 125;

PROFILE_OPTION_VALUE

--------------------------------------------------------------------------------

Production Instance

SQL> update apps.FND_PROFILE_OPTION_VALUES set profile_option_value='TEST Refreshed from Production on : 15-MAY-2010 ' where profile_option_id = 125;


1 row updated.

SQL> select profile_option_value from apps.FND_PROFILE_OPTION_VALUES where profile_option_id = 125;



PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------

TEST Refreshed from Production on : 15-MAY-2010
SQL> commit;

Commit complete.


SQL>


Direct you can update using below update statement too.

=======================================


UPDATE apps.FND_PROFILE_OPTION_VALUES SET
profile_option_value = 'TEST'
' Refreshed from '
'Production: '

SYSDATE

WHERE profile_option_id = 125 AND EXISTS

(select 'x'

FROM v$database

WHERE name NOT IN ('PROD'));



commit;