PeopleSoft Archive

Creating a SQL view/record for PSQuery

Author: | Categories: PeopleSoft, Software 2 Comments
Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and then query the record in PSQuery. Instructions are below. PSQuery – View Step 1 Open up app designer

PeopleSoft – Invalid Record/Field Error

Author: | Categories: PeopleSoft, Software No comments
PeopleSoft Error Working with PeopleSoft today I encountered an error stating Invalid Record/Field error. See picture below. The fix for the error was to actually clear the app server cache. (Have your DBA do it.) That can bring your production system to a slowdown if you then have to

PS – Move/Copy a Query to a new Database

Author: | Categories: PeopleSoft, Software 2 Comments
PeopleSoft Database Queries Here are instructions for moving/copying queries back and forth between different PeopleSoft databases. This includes moving between different versions of PeopleTools. Step 1 Launch App Designer on the server you are wanting to move/copy your queries from. Step 2 Go to “File > New > Project”

PS PIA Change Default Content and Layout

Author: | Categories: PeopleSoft, Software No comments
Change PeopleSoft PIA For end users, I prefer having the 2nd menu (main menu) enabled by default. This is the one with the icons. It makes it a lot easier for people to learn their way around PIA and still have the left menu for quick navigation. Below are

PeopleSoft Fix IE9 Spacing Issue

Author: | Categories: PeopleSoft, Software 1 Comment
IE9 Spacing Issue As most of you probably noticed with the upgrade to PeopleTools 8.51 there is a spacing issue (white space between header and top of page) with IE9. To resolve this you need to tweak your PT_HNAV_TEMPLATE html file. Follow the instructions below to fix. Step 1

Relationship CI not found (14000,317)

Author: | Categories: PeopleSoft, Software No comments
Ran across this error today under Campus Community > Personal Information > Biographical > Relationships > Relationships. It said, “Relationship component interface not found (14000,317)”. Below are instructions on how to fix this. Step 1 Browse to the default permission list of your user’s profile and click on the

Disable TypeAhead Feature for Everyone

Author: | Categories: PeopleSoft, Software 3 Comments
In certain versions of PeopleTools, the TypeAhead feature simply doesn’t work very well. It causes weird behavior, such as the mouse cursor disappearing and refresh problems. Below are instructions on disabling the TypeAhead feature for everyone. Step 1 Login to PIA and browse to Main Menu > PeopleTools >

PeopleSoft Favorites – Authorization Error

Author: | Categories: PeopleSoft, Software 3 Comments
Discovered some users today that couldn’t add favorites in PIA. Whenever they would try to add one they would get the following error: Authorization Error — Contact your Security Administrator. Turned out to be a simple permissions problem, they were simply missing a delivered web library under their permission

QDM could not load query definition – PS

Author: | Categories: PeopleSoft, Software No comments
Was receiving this error this last week after changing the primary permission list on some accounts in PIA. [Open Query] [CQryStmt::Prepare] QDM could not load query definition [ PUBLIC.PT_SEC_PLIST_USERS ] I was trying to run a query to see which users belonged to a permission list. Turns out that

Exporting and Importing PS Security

Author: | Categories: PeopleSoft, Software 1 Comment
It is actually pretty easy to export and import the security from PeopleSoft. There are datamover scripts that are given to. They are located in the PS_HOME PeopleSoft installation directory. You do have to realize that this export script simply exports all of the security. You can’t really pick