Either of the following two codes can be used for changing the EBS Login page Color to ditinguish between PROD and Non-PROD environment
Option 1.
UPDATE fnd_profile_option_values
fpv
SET fpv.PROFILE_OPTION_VALUE='RED' -----> (specifiy the color prefered by you)
WHERE fpv.PROFILE_OPTION_ID in ( SELECT t2.PROFILE_OPTION_ID
FROM FND_PROFILE_OPTIONS_TL t1,FND_PROFILE_OPTIONS t2
WHERE t1.USER_PROFILE_OPTION_NAME = 'Java Color Scheme'
AND t1.LANGUAGE = 'US' AND t2.PROFILE_OPTION_NAME = t1.PROFILE_OPTION_NAME);
Option 2.
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME','RED','SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
/
No comments:
Post a Comment