Sunday, March 13, 2016

Script to automate change EBS Login page color (i.e in Cloning Process ,etc )



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: