Tuesday 23 September 2014

EBS : Change the Oracle Forms color at back end

REM Change Java Scheme Color - Site Level
REM update fnd_profile_option_values set PROFILE_OPTION_VALUE='PURPLE' where PROFILE_OPTION_ID = 1002097 and level_id = 10001;
DECLARE
        stat boolean;
BEGIN
        dbms_output.disable;
        dbms_output.enable(100000);
        stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME', 'PURPLE', '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

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...