PeopleSoft

PeopleSoft related articles.

Records used in Tree Manager in HCM

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
PSTREELEAF
PSTREELEVEL

Permission Lists Assigned to a User

SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.

SELECT   d.oprid, d.oprdefndesc, c.roleuser, a.rolename, a.classid,
         b.classdefndesc
    FROM psroleclass a, psclassdefn b, psroleuser c, psoprdefn d
   WHERE a.classid = b.classid
     AND c.rolename = a.rolename
     AND d.oprid = c.roleuser
     AND d.oprid = :userid
GROUP BY d.oprid,
         d.oprdefndesc,
         c.roleuser,
         a.rolename,
         a.classid,
         b.classdefndesc;

Compare Report in CSV or HTML format

Click here -> Compare Report in HTML format to see how you can generate compare reports in HTML or CSV format.

Download Collaborate 08 Education Sessions

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.

PeopleSoft PeopleTools Meta-Tables

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!

PeopleSoft Projects

PSPROJECTDEFN table stores information about projects created in Application Designer.
Try it out:

SELECT * FROM PSPROJECTDEFN
WHERE PROJECTNAME = 'Your_Project_name';

Get Records on a Component

An SQL that goes against a specific component and bring back ALL related records.

SELECT   recname
    FROM pspnlgroup a, pspnlfield b
   WHERE (a.pnlname = b.pnlname OR a.pnlname = b.subpnlname)
     AND a.pnlgrpname = :component_name
GROUP BY recname

Trace Application Engine Processes Using Process Definitions

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:

-TRACE 7 -TOOLSTRACEPC 4044

TRACE application engine using process definition

Vendor Pending Transactions

A quick function that will allow you to verify if a specific vendor has any pending transaction(s).

Function vendor_pnding_transactions();

      &VENDOR = VENDOR_ID;
      SQLExec("select 'X' from ps_voucher a, ps_pymnt_vchr_xref b where a.voucher_id = b.voucher_id and a.business_unit = b.business_unit and a.vendor_id = :1 and a.entry_status in ('P', 'R')and a.close_status = 'O' and b.pymnt_selct_status in ('N', 'D', 'R')", &VENDOR, &EXISTS);
      If All(&EXISTS) Then
         Error Messagebox(0,"",0,0,("Vendor has pending transaction(s).");
      End-If;

Pages, Grids, & Scrolls

PeopleSoft Pages, grids, and scrolls related posts.

Troubleshoot the SMTP Server

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.