Thursday, February 13, 2014

Changing the look and feel of Oracle EBS environment



Changing the look and feel of Oracle EBS environment:

Changing the Oracle EBS look and feel help us to change the colour of the HTML and java based form page in Oracle EBS,the advantage is,it helps us differentiate between PRODUCTION and NON-PRODUCTION environment .

We can follow the below steps to achieve it:


Step 1:Login to Oracle EBS Home page with ‘sysadmin’ user.

Step 2:Navigate to  System Administrator Responsibility =>system profile form page

Step 3:Navigate to the System Profile option Name =>Java Look and Feel
And Site =>oracle   ,Screenshot below for reference.



Step 4: :Navigate to the System Profile option Name =>Java Colour scheme
And site =>teal
This choose the teal colour   ,Screenshot below for reference



Step 5: :Navigate to the System Profile option Name ,profile to change the =>Oracle Applications Look and Feel
And site =>Base Desktop look and feel.  ,Screenshot below for reference.



Step 6:Signout and login Oracle EBS application again to see the new look and feel it.

Changing the look and feel of Oracle EBS environment from Backend:

We can do the same task from backend,where we have the requirement to do it frequently as below:

Step 1:Creat a sql file banner_colour_change.sql

banner_colour_change.sql
spool banner_colour_change.out
UPDATE fnd_profile_option_values fpv
SET fpv.PROFILE_OPTION_VALUE='TEAL'
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);
commit;
spool off
exit


Step 2:Create a shell script as Apps_DBA_Scripts.sh

Apps_DBA_Scripts.sh
[ rafidba@node1 /home/rafidba/DBA_SCRIPTS ] vi Apps_DBA_Scripts.sh
.  $HOME/.bash_profile
sqlplus apps/apps_pass @/home/rafidba/DBA_SCRIPTS/banner_colour_change.sql


Step 3:Execute the Apps_DBA_Scripts.sh with nohup

nohup sh Apps_DBA_Scripts.sh>Apps_DBA_Scripts.out &


Step 4:Monitor and Validate the logs

tail -f Apps_DBA_Scripts.out 
less  Apps_DBA_Scripts.out 


Step 5:Check the colour by login to Oracle EBS page by opening form page

Now we can login to Oracle EBS Home Page and click any form page,the colour must have changed to TEAL.

 


 

 Enjoy Apps DBA tasks,Happy Apps DBA learning...
 


Best regards,

Rafi.



6 comments:

  1. Great Work...........Thanks to share it..........

    Thanks and Regards :
    Qadir Shaikh.
    Visit at http://www.oratc.com

    ReplyDelete
  2. Admin,Your Info was very helpful.

    Oracle DBA online training by real time international experts in an easy way to learn way.

    Oracle DBA online training

    To know the info on Online Oracle DBA training contact below and get full info on Oracle DBA online training.

    Contact Us :

    India : +91 9030400777
    US : +1-347-606-2716
    Email: contact@Hyderabadsys.com

    ReplyDelete
  3. Online Cisco Training, Online Linux Training, Online Ethical Hacking Training, Online CCNP Training, Online CCNA Training, Online MCSE Training, Online CCIE Training India, MCITP Training, Online VMware Training and more offered by Zoom Technologies by highly proficient CISCO certified experts - Hyderabad, India. Visit http://zoomgroup.com

    ReplyDelete
  4. You are Oracle DBA Article is very usefull to DBA Learners. I am very impressed when reading your DBA Post. Are you Looking for Oracle DBA Online Training . We will help you achieve your dream with our Expert Trainers

    ReplyDelete
  5. Nice Post & a good info. Persuing it is very beneficial CAPM Certification Training in USA This also increases the market value.

    ReplyDelete