Below given are the important records used in the tree manager.
PSTREEDEFN - Tree Definition and Properties
PSTREEDEFNLEVELS -- Tree Levels
PSTREEBRANCH -- branches of the tree
PSTREENODE -- Contains the nodes of the tree
SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.
Click here -> Compare Report in HTML format to see how you can generate compare reports in HTML or CSV format.
The education presentations from COLLABORATE 08 will be available on questdirect.org website until May 15th.
Filter on PeopleSoft sessions and download the ones you are interested in. Here is the link.
This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel free to add to or correct the list, this is a wiki page, so jump in!
PSPROJECTDEFN table stores information about projects created in Application Designer.
Try it out:
An SQL that goes against a specific component and bring back ALL related records.
In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file.
Navigate to the process definition of the application engine that you would like to trace (PeopleTools > Process Scheduler > Processes). Go to the Overrride Options tab, and from the Parameter List drop down select Append, and in the edit box next to it add the following line:
A quick function that will allow you to verify if a specific vendor has any pending transaction(s).
PeopleSoft Pages, grids, and scrolls related posts.
The SendMail function in PeopleSoft uses the SMTP server to send emails. The first thing to do when troubleshooting problems with emails not being sent is to make sure your SMTP server is up and running. In this post, I will show you how to verify if you can connect to the SMTP server as well as manually sending an email!
Note: I’m using Unix Telnet to connect to the SMTP sever.
Let’s get started by trying to connect to the server:
Open a telnet session and login to the server box you would like to test sending emails from. I will be logging in to a DEV environment.
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|