How to Display a detailed SQL error (Online)

Sometimes when you navigate to a PeopleSoft page or while doing some work online you might come up with this error. "A sql error occurred. Please consult log for Administrator." As developers when we build and test it is handy if we can see detailed error so that we can rectify it quickly. Sometimes...

Read More»

How to Test Delivered PeopleSoft Web Service using SoapUI

Prerequisites Download SoapUI from http://www.soapui.org/ SoapUI is an open-source web service testing application for service-oriented architectures (SOA) and representational state transfers (REST). It's simplicity and easy to use interface allows developers and testers to quickly test PeopleSoft...

Read More»

How to Access PeopleSoft Browser-Based Shortcuts and App Designer Shortcuts

PeopleSoft applications offer set of keyboard shortcuts to interact with your PeopleSoft application more quickly and easily. These shortcuts are classified into two categories: hot keys and access keys. To get these shortcuts, Navigate to any PeopleSoft online page and press Shift+Ctrl+K key combo. You...

Read More»

How to dynamically populate data in a grid using SQL views

PeopleSoft Grids are powerful page controls in PeopleSoft. It can display information in a spreadsheet format and you can embed other page controls such as buttons, drop-down lists, html areas, etc.. to the grid. You use grids depending your table structure and how your page will display to the users...

Read More»

How to Generate and Assign Unique Sequence Number in PeopleCode

Assigning a unique number to the Sequence Number field (or simply a number field) is something we have to do in some point as a PeopleSoft developer. The typical scenario is, you have a record which store multiple set of details and you need to identify each row uniquely. So adding a Sequence Number...

Read More»

How to use .Bat File to clear PeopleSoft App Designer Cache in Local Machine

Have you ever noticed a folder in your local system which created by PeopleSoft App Designer to Cache your PeopleSoft database object information? To give bit of a background, in users local machine PeopleSoft Configuration Manager automatically store database objects in cache files the first time...

Read More»

Can we Add Attachments That user to files with names longer than 64 characters in PeopleSoft?

I have seen that some forums developers ask above question often. As delivered by PeopleSoft there are no way (not that I know of) we can add attachments with file name longer than 64 characters. This is a limitation which is coming from AddAttachement peoplesoft built-in function. If you...

Read More»

How to use MsgGet and MsgGetExplainText in a MessageBox via PeopleCode

Most often when we want to show a message we use MsgGet function in PeopleCode and use Message Catalog to substitutes the values of the parameters into the text message. MsgGet(message_set, message_num, default_msg_txt [, paramlist]) where paramlist is an arbitrary-length list of parameters...

Read More»

Message cannot be changed. Message referenced in runtime tables

FYI, instead of writing whole post of how to fix the problem, I will redirect you to the correct location so that you know next time where to go; http://peoplesoft.wikidot.com/message-referenced-in-runtime-tables http://www.compshack.com/peoplesoft/integration-broker/message-cannot-be-changed-message-referenced-runtime-tables-doc-id-660 Another...

Read More»

How to show a list of restricted file types to the user (based on File Extension List)

In my previous two posts I mentioned that we can use File Extension List to created (or store) a list of file extensions. This File Extension List can be used to reject or accept list of file types for users when uploading files to the PeopleSoft system. To refresh, please read following Posts if you...

Read More»

How to sort Grid Columns using PeopleCode

PeopleSoft Grids are most common form of data display control and they display fields in spreadsheet like format. Often, we need to provide custom sort for grid columns in various situations. This can be achieved easily by using Sort Method in Rowset PeopleCode class. However, there are few things...

Read More»

How to know Scrum in 10 minutes

If you are a wondering about knowing of bits and pieces of Agile based development methodologies you may have already heard these buzz words such as Agile, Scrum, Kanban, Burndown charts, Sprints etc.. Then you will be amazed about this little video I used to watch and quickly learn about Scrum concepts...

Read More»

Software Testing: A Culture of Quality

One of the leading tenets of Agile software development is to always maintain a shippable product. Doing so allows a steady flow of code from the development team out to the user base.  Regular releases out to your customer base gives users the ability to provide feedback on the software to drive...

Read More»

How to find PeopleSoft Project Item (PSPROJECTITEM) Object type list

When I was searching to find out what are all the distinct OBJECTTYPE values for the PSPROJECTITEM table, I found out there are heaps of excellent posts written in many places. one particular post from https://garrettdieckmann.wordpress.com/2013/12/11/object-types/ has mentioned...

Read More»

How to use Message Catalog pop-up in PeopleSoft Pages

Popups are common in web pages and they are handy to display additional information about a field or information for a subset of users. For example, you can create a popup to display information about a types of files which are accepting for a file upload process. Another example would be to show...

Read More»

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...

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...

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...

Read More»

How to restrict FileTypes (extensions) from URL Object Properties When Adding Attachments Part II

So, as I mentioned in  How to restrict File Types (extensions) from URL Object Properties When Adding Attachments Part I post, I have tested this particular configuration when adding attachments. The good news is it worked :-) So, how did it exactly work? Well, assuming that you have...

Read More»