Thursday, February 25, 2016

EBS 12.2 -- Java Color Scheme, Changing the color

This is a very basic subject and almost any APPS dba knows it.
That is, we change the color of the EBS using Java Color Scheme profile option.
We change the color in the events such as cloning to let the distinguish the environments by their colors.

The reason that makes me write  this blog post is however a new requirement on this process.
In EBS 12.2, after changing the Java Color Scheme profile option , we need to restart the oacore managed server (just in case restart the Oracle HTTP Server as well). Unless restarting, the color of form screens will not be changed.
Also, the profile option Java Look and Feel must be null or set to the value "oracle" to let the EBS regard the Java Color Scheme profile option value.

The Java color profile option value can be updated from backed as follow;

UPDATE fnd_profile_option_values erm
SET erm.PROFILE_OPTION_VALUE='PURPLE'
WHERE erm.PROFILE_OPTION_ID in ( SELECT erm2.PROFILE_OPTION_ID
FROM FND_PROFILE_OPTIONS_TL erm1,FND_PROFILE_OPTIONS erm2
WHERE erm1.USER_PROFILE_OPTION_NAME = 'Java Color Scheme' and
erm2.PROFILE_OPTION_NAME = erm1.PROFILE_OPTION_NAME);

1 comment :

  1. This comment has been removed by a blog administrator.

    ReplyDelete