EBS : Change the FORMS color from backend

How to change the java forms color from backuend?

Solution:

Connect to apps schema
sqlplus apps/apps

set serveroutput on
REM Change Java Scheme Color - Site Level
REM update fnd_profile_option_values set PROFILE_OPTION_VALUE='TEAL' 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;
/

instead of PRURPLE provide any of the below value to change the color

• BLUE
• KHAKI
• OLIVE
• PURPLE
• RED
• SWAN
• TEAL
• TITANIUM