How to Know Your PeopleSoft PeopleTools Version (for Beginners)

There are few ways you can check PeopleTools version of your PeopleSoft Application. In this post we will look at most common ways to check the PeopleTools version.

Method 1: Via App Designer

You can check PeopleTools version using app designer, by Clicking Help > About PeopleTools... 

Method 2: Pressing (Ctrl +  J) or (Ctrl + Shift + J) Key combination from brower

The famous (Ctrl +  J) or (Ctrl + Shift + J) Key combination will work for most browsers such as Chrome, FireFox and Internet Explorer

Method 3: Installing Browser Plugging (PSChrome) for Chrome and FireFox.

PSChrome is a Chrome and FireFox Plugin (or Extension) which 

offers some basic features for use by developers and users enabling a simplified user experience in PeopleSoft environments. It is really handy for Analysts and Beginners for PeopleSoft where you can find information about Components, Pages, Field values etc.. Once installed, it shows you a Toolbar at the top of the page which you can drill down and find many useful information.

PS: When you upgrade Firefox to version 36.0.1 PSChrome for Firefox will not work.

Method 4: Using PSPCMPROG record

Last but not least, you can query the delivered record PSPCMPROG record which store all PeopleCode programs. Simply issue this Query;

SELECT PTTOOLSREL FROM PSPCMPROG;

Read More»

How to Compile your PeopleCode Program

In PeopleTools App Designer there is an option to compile all PeopleCode programs which are stored in the database or in a project to check for errors. When you do that it compile every PeopleCode program. Apart from finding errors in the program, one advantage of compiling the program through App Designer is after an upgrade to verify that all the programs were upgraded correctly.

To access this option in App Designer, go to Tools menu and select Compile All PeopleCode option.

To compile all PeopleCode programs

Open Application Designer while accessing the database that contains the PeopleCode that you want to check, then Select Tools, Compile All PeopleCode. Select which PeopleCode to compile. Click Compile in the Compile All PeopleCode dialog box. If there are any errors they will appear in the PeopleCode log display window.

Read More»

Important PeopleSoft Queries Part I

Some of the PeopleSoft PeopleTools Queries that someone might find useful;

How to find database tables (i.e SQL records) attached to a page?

SELECT A.LBLTEXT, A.RECNAME, A.FIELDNAME, A.PNLNAME
FROM PSPNLFIELD A
WHERE A,PNLNAME = :1 --Page Name
AND A.RECNAME NOT LIKE '%XLAT%'
AND A.RECNAME NOT LIKE '%WRK%'
AND A.RECNAME NOT LIKE '%DERIVED%'
AND A.FIELDNAME <> ' '
ORDER BY 2;

How to find objectownerid of a record definition?

SELECT A.RECNAME, A.RECDESCR, A.OBJECTOWNERID, A.DESCRLONG
FROM PSRECDEFN A
WHERE A.RECNAME = :1 --Record Name

How to find list of record definitions (tables) the belong to a particular object owner ?

SELECT A.RECNAME, A.RECDESCR, A.OBJECTOWNERID, A.DESCRLONG
FROM PSRECDEFN A
WHERE A.OBJECTOWNERID= :1 --Object owner id

How to find PS Queries that select data from specific table

SELECT A.OPRID, A.QRYNAME, A.RECNAME, A.FIELDNAME
FROM PSQRYFIELD A
WHERE A.RECNAME LIKE :1 -- Record Name

How to find PS Queries that use specific field

SELECT A.OPRID, A.QRYNAME, A.RECNAME, A.FIELDNAME
FROM PSQRYFIELD A
WHERE A.FIELDNAME LIKE :1 -- Field Name

How to find Queries that were not delivered by PeopleSoft

SELECT A.OPRID, A.QRYNAME, A.DESCR
FROM PSQRYDEFN A
WHERE A.LASTUPDOPRID <> 'PPLSOFT'

Read More»

PeopleSoft Fluid User Interface

Next big thing of Oracle PeopleSoft is Fluid User Interface which comes with PeopleTools 8.54. In fact, PeopleBooks for 8.54 has an entire section named as Fluid User Interface Developer’s Guide which goes through how to setup a Fluid Applications;

Some of key benefits of Fluid Interface are

• Mobility and portability Between multiple devices
• Intuitive User Experience
• Personalisation
• Unified User Experience Across Oracle Applications

Key components for implementing Fluid interfaces are;

• PeopleSoft Application Designer
• PeopleCode
• PeopleSoft PIA
• HTML 5.0
• CSS 3.0
• Java Script

Here are couple of videos who are interesting about Fluid User Interface

Read More»

How to change Translate values Online

Most of the time, In PeopleSoft translate values for a field is maintained by developers via Application Designer. However, there is a way to maintain the values in the translate table via online as well. Thus, security administrators, power users can now add their own translate values to an application.

To maintain translate values Navigate to PeopleTools > Utilities > Administration > Translate Values

Read More»