PSQuery is an online PeopleTools functionality heavily used by business analysts and key users to gain information from the PeopleSoft application without the need of development or database SQL knowledge. The biggest con of PSQuery is that you end up with one static list of data, which is usually exported to Excel for further enhancement and analysis.

From PeopleTools 8.50, you now have the ability to create more in-depth analyses and productivity using drilling URLs.

When you build a query using Query Manager, you can define drilling URLs that are associated with this query using the expression option. These settings are saved into the database, along with prompt, criteria, and so on, as part of the metadata for this query. When you execute this query through Query Manager or Query Viewer, the query results page shows results as links, which you can click to be redirected to a different page in a new browser. You can create URLs for:

• Other PSQuery, for more in-depth information about a subject, actual drilldown functionality
• PIA Component, direct link to components where the keys for the search page of the component are extracted from the selected columns in the query
• External URL, non PeopleSoft URLs, for example Vendor sites
• Attachment URL, direct link to an attachment that is stored in the database or file system
• Free Format URL, any type of URL you want to construct, can be used for example to deep link to other non-PeopleSoft applications

So how does one create a drilling URL?

The Environment variable PS_CFG_HOME new in this version,  has been created to hold the configuration files for the application server, batch server and search server domains.

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

If you have more PS_HOMEs on the same machine, you can create a separate Windows Service for each environment with the next steps:

Step1 – Setting PS_CFG_HOME

Create a  .bat file in each PS_HOME/appserv folder, for example psadmin.bat. This file would contain the following:

In Tools 8.50 the ‘secureFileKeystorePasswd’ parameter of the integrationgateway.properties file must now be encrypted.

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

That can be done  through the application so that you do not need to restart the web server.
1. Navigate to PeopleTools -> Integration Gateway -> Configuration – Gateways.

PeopleCode compile error after a Tools-only upgrade to PeopleTools 8.50

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

Five new keywords have been introduced in PeopleTools 8.50:

• Primitive
• Compound
• Collection
• Document
• DocumentKey

Some applications released before 9.1 use the word “collection” as class name what result in a PeopleCode compiler error such as:

PeopleCode compiler error.(The create operator can only be used for application classes(2,96)) for program xxxx.yyyy.OnExecute(2,405).

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

Configuring Report Manager – List/Explorer – PeopleTools 8.50

Report Manager is a utility in PeopleSoft to view reports from another place than Process Monitor. It has fours pages: List, Explorer, Administration and Archives.

Setup of Integration Broker needs to be done and PUB/SUB App Server Processes are required to be up and running.

Configuration steps

Service Operation configuration

IB needs to be configured for four services

• PSRF_FOLDER_CREATE
• PSRF_REPORT_CREATE
• PSRF_REPORT_DATE _CHANGE
• PSRF_REPORT_DELETE

Navigate to PeopleTools -> Integration Broker -> Integration Setup -> Service Operations

Open Service Operation  PSRF_FOLDER_CREATE

In the General tab:

• Be sure that  the Service Operation  active
• If the Routing status from Local-to-local is “Does not exist”, check “Generate Local- to-Local” and click the Save button.

In the Routings tab, verify if there is only one routing definition active.

Repeat this step for the other  three services.

Clean cache and restart the application server.