PeopleSoft Archive
Creating a SQL view/record for PSQuery
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. Step 1 Open up app designer and create a
PeopleSoft – Invalid Record/Field 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 rebuild your
PS – Move/Copy a Query to a new Database
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” and hit “Ok.”
PS PIA Change Default Content and Layout
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 instructions on how
PeopleSoft Fix 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 Launch App Designer
Relationship CI not found (14000,317)
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
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
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
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
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
- 1
- 2