Tuesday, September 26, 2006

Execute query from Lefthand Portal Navigation

You can run PeopleSoft Query from Lefthand Portal Navigation. This helps the end user to navigate to remember the query name easily.

Go to Portal -> Structure and Content

Navigate to  the folder under which you want to create the content reference.

Add a new content reference and fill following fields as follows

Check No Template check box. This will remove the portal Header and Left hand menu navigation.

URL information

Node Name : Always use Local or appropriate remote node name

URL Type : PeopleSoft Generic URL

Portal URL : q/?ICAction=ICQryNameURL=PUBLIC.YOUR_QUERY_NAME

Content Reference Attributes

Name: NAVNEWWIN

Uncheck Translate check box.

Attribute value: true

This will open the query results in a new window.

Go to Security Tab and add appropriate permission list and save the content reference.

You may have to refresh the homepage to be able to see this new portal content reference in Left hand  Navigation menu.

This is applicable for PeopleTools 8.4x only.

Wednesday, September 20, 2006

Target Operator ID has 'No Access' to Upgrade. (62,14)

when you try to copy a project from one database to anonther, you get a message Target Operator ID has 'No Access' to Upgrade. (62,14). This is despite you have correct permission list assigned to the userid in target database. This is due to bug in PeopleTools and is fixed in 8.46. Here is a workaround. Run this query in your target database.

SELECT * FROM PSAUTHITEM WHERE CLASSID IN
(SELECT OPRCLASS FROM PSOPRCLS WHERE OPRID='xxxxx') AND
MENUNAME='APPLICATION_DESIGNER' AND BARNAME='UPGRADE'

The operator class or permission list returned by very first row of query results, must have access to upgrade for that user. (AUTHORIZEDACTIONS = 4 for MENUNAME = APPLICATION_DESIGNER and BARNAME = UPGRADE).

Open Permission List, Go to PeopleTools Tab. Select Tools Permissions Link and Asign Full Access for Upgrade (at the bottom). Generally permission list PTPT1200 and Role PeopleTools has access to copy the project to target database.