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. Really Amazing Sir. It is useful information for us thanks for the sharing..........

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

    ReplyDelete
  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 http://zoomgroup.com

    ReplyDelete
  5. Remote DBA Support
    http://www.21cssindia.com/support.html
    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.

    SQL SERVER :
    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. contact@21cssindia.com
    http://www.21cssindia.com

    ReplyDelete
  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

    ReplyDelete