Sunday, October 28, 2012

Tablespace (APPS_TS_MEDIA ) is growing



step 1:  select * from
(select SEGMENT_NAME, sum(bytes)
from dba_segments where TABLESPACE_NAME='APPS_TS_MEDIA'
group by segment_name order by 2 desc)
where rownum <= 10;

Step 2:  
Use the following query to find out currently set value for PCTVERSION:
select PCTVERSION from dba_lobs where TABLE_NAME = 'FND_LOBS' and COLUMN_NAME='FILE_DATA'; 
PCTVERSION
----------
        10

Step 3: 
PCTVERSION can be changed using the following SQL (it can be run anytime in a running system):

ALTER TABLE FND_LOBS MODIFY LOB (FILE_DATA) ( PCTVERSION 0 ); 

Ref: 298698.1

Wednesday, October 24, 2012

How to replace the default Oracle Logo with a Customized Logo Company Brand logo



There are 3 ways to change the Oracle logo to a Customized logo. The logo can be replaced in two ways at site level and one way by application only.
To change the logo at the Site level.
1. Change the FNDSSCORP.gif file.
A. Make a backup copy of the FNDSSCORP.gif file. Name it FNDSSCORP.bak
B. Make the name of the custom logo FNDSSCORP.gif
C. Upload the new FNDSSCORP.gif file to the $OA_MEDIA directory
D. Log out and log back into the application
2. Leave the FNDSSCORP.gif file alone and upload a new image (test.jpg, for example) $OA_MEDIA directory.
A. Log into (N) System Administrator > Profile > System
B. Query the "Corporate Branding Image for Oracle Applications" profile
C. Type "test.jpg" (following our example image) under the Site column
D. Save
E. Log out and log back into the application
Both cases, the application will show:
Now, change the Corporate Branding (the Oracle image) in a specific application and leave it as the Oracle image for all the rest of the applications, as well as the login and home page.
3. Start the same as step 2. above: Leave the FNDSSCORP.gif file alone and upload a new image (test.jpg, for example) $OA_MEDIA directory.
A. Log into (N) System Administrator > Profile > System
B. Put a checkmark in the Application box and type "Self-Service Web Applications"
C. Type "Corporate Branding Image for Oracle Applications" in the Profile field and click Find
D. Type "test.jpg" (using the same example) under the Application column that should already say "Self-Service Web Applications"
E. Log out and log back into the application
All pages except for the iProcurement responsibility will have the Oracle logo in the Corporate Branding



Ref:421636.1