Discoverer invoke from EBS oracle.discoverer.applications.viewer.events.ApiConnectAppsSecureEvent

issue : An error occurred while handling the event. See the application log for more details.
oracle.discoverer.applications.viewer.events.ApiConnectAppsSecureEvent
- Empty input (or null input) is not allowed

all user are getting discoverere reports when invoking from Oracle ebs  and user able to access with other browsers as well ,at the same time few users not able to get the discoverer and getting the above error message in IE 8


Solution;

Go to internet explorer->tools->internet Options->Security-> Trusted Sites->Sites->Add

Add the discovers address

How can I activate the Totals button that is grayed out in PSI

How to active the Total button in Oracle PSI

The Totals button is activated through the set up of Project Status Columns.  After navigating to
Setup -> Project Status Columns,
 enable the Total check box for each column you want to total for column summarization and save your changes.

 NOTE: You cannot click in the Segment 1, Name, or Over Budget lines.

Concurrent Manager Status Shows 'System Hold Fix Manager

All concurrent managers status shows''System Hold Fix Manager ' and all requests  are in pending....

Solution:

1.go to OS and check any  concurrent process is running (here  only two process were running )
2.stop concurrent manager adcmctl.sh stop apps/pwd
3.kill those process whice are still running
4.start concurrent managers sh adcmctlsh start apps/pwd
5.and go applicatoin and clikc on fixed button


All process will start


Regards

Webadi Error Run-time error '1004': Method 'Vbproject' Of Object'_workbook'

ISSUE:

Run-time error '1004':

Method 'VBProject' of Object'_Workbook' Failed
this issue reproduce when downloading the excel sheet via webADI .

SOLUSTION:
In Excel 2003:
go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab.  Check the box next to "Trust access to Visual Basic Project".
(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

In Excel 2007, use the following navigation:

• Click on the Office button in the upper left corner
• Click on the Excel Options button
• On the left, click on the Trust Center
• Click on the Trust Center Settings button
• On the left, click on Macro Settings
• Click on "Trust access to the VBA project object model"

Ref: 376013.1
       406526.1     

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 )-----------