Search Results

The Case-When-Exists expression in Oracle is really handy. Here's an example of how to use it in ...

While setting up the PIA for Oracle WebLogic, I was getting the following message (this is on Win...

While working with dynamic roles, I came across a problem where users were not being assigned a d...

While copying application designer projects, if you receive an error like this: Definition Name ...

%TextIn is a Meta-SQL construct which is used for inserting data into PeopleSoft Long Character t...

While performing an alter on a table, I received the following error in the SQL Build log (PSBUIL...

This is a time saving tip for application designer. If you are creating a new record definition a...

The following error occurs when you attemp to view a report either through report manager, proces...

There are two parts to migrating a COBOL DMS (data mover script): Migrate the data mover script...

The following SQL identifies custom queries created in your system from the PSQRYDEFN PeopleTools...

During development you may come across the following error: Page data is inconsistent with datab...

You can use the SearchClear() method which is part of the Field class to clear search values on a...

A blunt, but useful method for debugging PeopleCode is to use the inbuilt Error function to stop ...

PeopleCode includes a class library for working with XML documents called XMLDoc. There are a nu...

If you need to retrieve the web server URI for rending images in HTML emails try this method Get...

You can use the commands string, by, and into in SQR to string together text by a particular char...

If you ever want to conditionally count the number of times a particular condition occurs in SQL,...

To trace the status of cursors being executed, append the -S flag to your parameter list. You can...

The following SQL is an example of how to enumerate (number) rows in SQL. This SQL will only work...

Certain organization defaults can be set on permission lists in HRMS/Campus Solutions under: S...