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

spool banner_colour_change.out
UPDATE fnd_profile_option_values fpv
spool off

Step 2:Create a shell script as
[ rafidba@node1 /home/rafidba/DBA_SCRIPTS ] vi
.  $HOME/.bash_profile
sqlplus apps/apps_pass @/home/rafidba/DBA_SCRIPTS/banner_colour_change.sql

Step 3:Execute the with nohup

nohup 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,



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

    Thanks and Regards :
    Qadir Shaikh.
    Visit at

  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

  3. Really Amazing Sir. It is useful information for us thanks for the sharing..........

    Thanks and Regards :
    Mr. Qadir Shaikh.
    Visit at

  4. 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

  5. Remote DBA Support
    No matter what database platform you’re running, dbaDIRECT is your answer for 24×7 monitoring and expert skill, at a lower cost than what’s possible with internal administration. We offer each of our core remote management services for all major database platforms, including Oracle, Sybase, MySQL, SQLServer, and IBM DB2. Our team of DBAs is here ’round the clock for your database needs, capable of servicing any size organization at any time of the day. Period.
    Database serives

    Oracle - Oracle RAC, Data Guard, Grid Control (Oracle Enterprise Manager) - Backup & Recovery, monitoring, Proactive tuning and maintenance - MS Sql server - IBM DB2 - Postgres -

    ORACLE :

    dbaDIRECT’s 24×7 Oracle Team has the advanced skills and resources required to service Oracle’s rich features for your business, no matter the version your company is using. Our DBAs are experienced with all Oracle technologies, including Oracle Real Application Clusters (RAC), Recovery Manager (RMAN), Cluster Ready Services (CRS), Grid, Oracle Enterprise Manager (OEM), Data Guard, and we offer comprehensive Upgrade Services for all versions.

    MYSQL :

    You can worry less knowing dbaDIRECT’s MySQL DBA teams are dedicated to administering MySQL Server databases. We are knowledgeable in all versions of MySQL and offer comprehensive MySQL services, including Upgrade Services, MySQL Cluster, Replication, Master-to-Master Replication, and Performance and Tuning

    SYBASE :

    dbaDIRECT’s team of experts realizes the importance of maintaining high-performance Sybase databases that are capable of running mission critical applications. Our Sybase services apply to all versions and include, but are not limited to, Upgrade Services, Sybase Semantic Partitioning, Sybase ASE 15 Partitioning, Sybase DirectIO, and Sybase MDA Performance Tuning

    DB2 :

    Clients rely on dbaDIRECT to provide unparalleled DB2 operational excellence through 24×7 global coverage, including our 15-minute SLA. dbaDIRECT offers a single DB2 database administration solution, regardless of your version or platform (z/OS, Unix, or Linux). dbaDIRECT’s DB2 services include Upgrades, HADR (High Availability Disaster Recovery), DB2 Backup, DB2 Health Check, and DB2 Maintenance Scripts, among others.

    dbaDIRECT is your single source for SQL Server expertise and DBA operations. Turn to us for all of your SQL Server DBA needs and let dbaDIRECT manage your database infrastructure. dbaDIRECT offers a wide variety of SQL Server services, including Failover Clustering, Database Mirroring, Database Partitioning, and SQL Server Auditing.- Employees to learn at their own pace and maintain control of learning “where, when and how” with boundless access 24/7by 21st Century Software Solutions.

  6. 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

  7. interesting piece of information, I had come to know about your web-page from my friend pramod, jaipur,i have read atleast eight posts of yours by now, and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a million once again, Regards, obiee training in hyderabad , informatica training in hyderabad

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

  9. A smallish campaign with a homemade list would not be likely to yield much of a result. To achieve anything worthwhile, a much more aggressive effort is needed. Then, the age-old value analysis applies: projected earnings = margin on total projected sales - cost of campaign.