Query to Excel Client PC recommended settings

ISSUE:
What is PeopleSofts recommended Query to Excel Desktop settings for a Client PC?

SOLUTION:
Please verify that the Client PC is setup as recommended for downloading Query results to Excel:

1)  Right-mouse click on the Start button and open the Windows Explorer
2)  Go to Tools > Folder Options > File Types > and scroll down until you see XLS > highlight XLS and then hit the Advanced button
3)  Make sure the only check-box that is checked is the one titled, "Confirm open after download"

Next, check the following:

1)  Open a new browser session
2)  Tools > Internet Options > Advanced > and scroll down until you see the Security section
3)  Uncheck (if checked) the box titled, "Do not save encrypted pages to disk"

If the User is still having problems, please try clearing the PCs browser cache.

If using Windows Vista, try the following:
Start Internet Explorer > Select the menu Tools and the sub-menu Internet Options and there the second Tab: Security.  Make sure that the first icon of the world: Internet is selected.  Then choose Custom level > Scroll down to: Downloads > Make sure that 'automatic prompting for file download' is checked.

Internet Explorer cannot download Query to Excel

ISSUE: When running a query through the web and selecting Run to Excel the users are receiving
the following error:

Internet Explorer cannot download q/ from < domain name >
Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

SOLUTION:

1. Check the settings on the WebProfile for the Profile Name used.
 Navigation:
Peopletools-->Web Profile-->Web Profile Configuration.
On the "Caching" tab set the "Cache Generated HTML" and "Cache Homepage" flags to "On" if those are unchecked.

2. Restart the webserver.

Run to Excel in Query Manager window opens then closes

This is due to one of 2 browser settings:

1)  Pop up blocker is enabled.  Need to disable pop up blocker.  On browser go to: Tools > Popup blocker and select disable.  This could be set in your Internet Security settings page.

2)  Browser Security set too high.  To resolve this navigate to:  Tools > Internet options > (Security tab) and on the Security tab select Trusted sites.  Next, add the PeopleSoft domain to Trusted sites.  Then, change the Security setting for Trusted sites from CUSTOM, MEDIUM or HIGH to MEDIUM LOW or LOW.

Or as alternative Workaround :

2b) you could Click on the Security tab. Then for both Internet and Trusted sites. Click on custom level and scroll down to Downloads and set the 'Automatic Prompting for file Downloads' to enabled.

Oracle - createview.dms - Creating Views never error's and taking long time

1. Add _optimizer_cost_based_transformation=off to the init.ora file
2  Make sure that the posted recommended init.ora parameters for Oracle 11g are in place:

_gby_hash_aggregation_enabled=false

_unnest_subquery = false

3. Stop and then restart the database.
4. Rerun createview.dms and report the total time. 

For Windows XP users to login to New Peopletools 8.51

For Windows XP users to login to New Peopletools 8.51.02

 <PS_HOME>\setup\psvccrt>psvccrt_retail.msi

Next

Next

 Next

Close