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.



Sunday, February 2, 2014

Using Data mover psdmt utility to refresh table data or move data from one evironment to other

 Hi DBAs,

PSDMT (Data mover) utility is very useful to refresh table data from one environment to other.In the below example DEVDB(Source) and TESTDB(Target).



We can prefer this utility when we have huge amount of tables data to move from one environment to other.
.
Step 1:Go to Peoplesoft Datamover client utility psdmt.
We have to go to People Tools Home and navigate to psdmt.exe


Step 2:Login to Datamover with DEVDB(source) as below:
Login to DEVDB(Source):

user:ADM1
pass:Welcome123

Note:Remove files from temp directory  before performing below steps.
=====


Step 3: Copy the below script in Datamover

Set log c:\temp\log_exp.log;
Set output c:\temp\data.dat;
Export SGA_BVN_MAPPING;
Export SRVC_GROUP_AREA;


Step 4: Import into TESTDB database using datamover(psdmt)

Login to TESTDB(Target):

User:ADM1
pass:welcome123

Step 5:Copy the below script in Datamover

Set log c:\temp\log_imp.log;
Set input c:\temp\data.dat;
import SGA_BVN_MAPPING;
import SRVC_GROUP_AREA;

Step 6:Verify the COUNT OF ROWS in tables on source(DEVDB) and target(TESTDB):
SOURCE:DEVDB

CONN USER1 and give below:

SQL> select name from v$database;

NAME
---------
DEVDB

SQL> select count(*) from USER1.SGA_BVN_MAPPING;

  COUNT(*)
----------
    262742

SQL> select count(*) from USER1.SRVC_GROUP_AREA;

  COUNT(*)
----------
   9864049

TARGET:(TESTDB)

CONN USER1 and give below:

SQL> select name from v$database;

NAME
---------
TESTDB

SQL> select count(*) from USER1.SGA_BVN_MAPPING;

  COUNT(*)
----------
    262742

SQL> select count(*) from USER1.SRVC_GROUP_AREA;

  COUNT(*)
----------
   9864049

Step 7:Send mail
Completed refresh of tables SGA_BVN_MAPPING and SRVC_GROUP_AREA in TESTDB.


Enjoy PeopleSoft DBA tasks.



Best regards,
Rafi