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

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 applicationBoth 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 applicationAll pages except for the iProcurement responsibility will have the Oracle logo in the Corporate Branding



Ref:421636.1

Custom Code to Read only for all resposibilities and able to sumbit Concurrent srequests

----(Added the Custom Code to read only the Responsiblity )-----------
    formname    VARCHAR2 (30);
   blockname   VARCHAR2 (30);
BEGIN
   IF event_name = 'WHEN-NEW-FORM-INSTANCE'
   THEN

      IF fnd_profile.VALUE ('USER_NAME') = 'XXXX'
      THEN
(CURRENT_FORM)||'..FMB NAME..'||GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME));

         IF GET_APPLICATION_PROPERTY (CURRENT_FORM_NAME) NOT IN ( 'FNDRSRUN')
         THEN
('USER_NAME'));

            BEGIN

               COPY ('Entering app_form.query_only_mode.',
                     'global.frd_debug');
               COPY ('YES', 'PARAMETER.QUERY_ONLY');
               app_menu2.set_prop ('FILE.SAVE', enabled, property_off);
               app_menu2.set_prop ('FILE.ACCEPT', enabled, property_off);
               formname := NAME_IN ('system.current_form');
               blockname := GET_FORM_PROPERTY (formname, first_block);

               WHILE (blockname IS NOT NULL)
               LOOP
                  IF (GET_BLOCK_PROPERTY (blockname, base_table) IS NOT NULL
                     )
                  THEN

                     SET_BLOCK_PROPERTY (blockname,
                                         insert_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         update_allowed,
                                         property_false
                                        );
                     SET_BLOCK_PROPERTY (blockname,
                                         delete_allowed,
                                         property_false
                                        );
                  END IF;

                  blockname := GET_BLOCK_PROPERTY (blockname, nextblock);
               END LOOP;

            END;
         END IF;
      END IF;
   END IF;
END event;
----(End Added the Custom Code to read only the Responsiblity )-----------

compile a form using frmcmp_batch.sh ORA-12154: TNS:could not resolve the connect identifier specified

When attempting to compile a form using frmcmp_batch.sh or frmcmp.sh

The following errors occurs

ORA-12154: TNS:could not resolve the connect identifier specified

Solution: 

Cause

The TNS_ADMIN set in the scrip frmcmp_batch.sh or frmcmp.sh is pointing to the wrong location.
When the script frmcmp.sh or frmcmp_batch.sh is executed it resets the TNS_ADMIN to $ORACLE_HOME/network/admin

See the following from the scripts:
...
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN...
While it should be:
...
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}
export TNS_ADMIN
...


Reference : 431324.1

How to transfer expenditure item from one project to another project

1.Create new job 12040900 with old job 12040387

2.while creating take the choose  correct customer 2308

3.update the billing

4.save ...

5.go to agrrement and funding 1204900 with customer 2308

6.go to budget and baselined.

7.run PRC: Update Project Summary Amounts now we can see in contract value in PSI

8.source projcet expenditure item window and sselect  rows

9.tools tranfer (transfer788)

10.PRC: Distribute Labor Costs

11.PRC: Distribute Supplier Cost Adjustments

12.PRC: Update Project Summary Amounts

13.now in project 12040900 the expenditure 42,348.06

14.PRC: One Step Interface Streamline Processes to GL with option XS: Interface Supplier Costs To GL

How to change the customer name for a project

1.how to change the customer name for a project;
case: once project created with a customer (wrong customer) ABC Sevices (2531) and invoice and revenues completed now client wants to change the customer to XYZ (2308)
Ans: we can do it  in two ways
Option 1:
in AR Customer-> Account Merge
with this we can merging the customers and the project which was in ABC now in XYZ and abc will be inactive
Option 2:
1. create new project with different number
2.transfer the expenditure items to new project from old(Material,Labour,Sub contract ,other overheads)
3.cancel the revenue and invoice and events from old jobs
4.create new invoice ,revenues
5.commitments has to create for new job
6.close old job

Monitor Users Monitor User Form Shows Users Who Have Already Logged Out

Issue : Monitor User Form Shows Users Who Have Already Logged Out

Solution : Please run the Concurrent Program "Purge Signon Audit Data" regularly.

Ref: 270814.1