Knowledge Base Articles

Here is a list of all articles

%Page and Component Interface: A Warning

A warning about %page and Component Interface


10 Step Component Interface Development Process

10 steps to follow when coding using a CI.

Published on: filed in: Component Interface Related Articles

8.52 and REST support in Integration Broker

Some updated information on REST API support

Published on: filed in: Integration Broker Related Articles

A Better Run Control Page Standard

A new run control record proposal

Published on: filed in: Design Related Articles

A Complete PeopleSoft REST Web Service Example

A complete example of providing a REST web service in PeopleSoft.


A Look at Max Concurrent Process Definition Property

A look at the “Max Concurrent” process definition property

Published on: filed in: Process Scheduler Related Articles

A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table

Published on: filed in: PeopleTools Related Articles , Security Related Articles

A Simple Procedure to Compare Application Designer Projects Prior to a DB Refresh

Two methods to determine what Application Designer Projects are different between databases. This is useful prior to a refresh.

Published on: filed in: PeopleTools Related Articles

A look at the "List of Values" (SCC_GET_LOV) Web Service

This article looks at the PeopleSoft Campus Solutions “List of Values” (SCC_GET_LOV) web service which a third party can pull setup data out of PeopleSoft. It is helpful for integrations.

Published on: filed in: Integration Broker Related Articles , Web Services Related Articles

Accessing Related Fields in PeopleCode

How to programmatically access related fields in PeopleCode.

Published on: filed in: PeopleCode Related Articles

Adding Custom CREF Images to Folders

How to add custom images to a portal CREF

Published on: filed in: Portal Related Articles

An Example of using the CI "Find" Method

An example looking at CS Course Catalog Component Interface to use the Component Interface Find Method.

Published on: filed in: Component Interface Related Articles , PeopleCode Related Articles

Application Classes and Global Variables are like Oil and Water

An example of the perils of using Global Variables in your Application Classes

Published on: filed in: PeopleCode Related Articles

Avoid Global Variables with query string parameters

Global variables are evil!

Published on: filed in: PeopleCode Related Articles

Back End Role Insert

A simple script to insert roles into a user via SQL.

Published on: filed in: Security Related Articles

Can I Guarantee a Process Will Run at a Certain Time?

I schedule a process to run at 9 pm but it did not run until 2 am? Why?

Published on: filed in: Process Scheduler Related Articles

Component Interface EditHistoryItems Gotcha

When you are writing code against a Component Interface API, there is an important boolean property on the CI called EditHistoryItems.

Published on: filed in: Component Interface Related Articles

Copy Field values between different records

Copy like named fields between two diffent records.

Published on: filed in: PeopleCode Related Articles

Create Excel Files in SQR and PeopleCode

An open source project that creates Office XML files from SQR.

Published on: filed in: PeopleCode Related Articles , SQR Related Articles

Create a PDF file in PeopleCode using the Query API

An example of how to create a PDF file using PeopleCode and the Query API.

Published on: filed in: PeopleCode Related Articles

Creating an Effective Audit Subrecord

An overview of an audit subrecord you should have on all your custom records.

Published on: filed in: Design Related Articles , PeopleCode Related Articles

Criteria to Use Component Interface

What Criteria should lead to the use of CI?


Data Security and Self Service Search Records

An explaination of search records for self-service components.

Published on: filed in: PeopleTools Related Articles , Security Related Articles

DataDumper Documentation

Documentation for our datadumper application package.

Published on: filed in: Debugging Related Articles , PeopleCode Related Articles

Delay Processing in Inbound Asynchronous Subscription Handlers

A look at how the PeopleTools integration broker delay processing works.

Published on: filed in: Integration Broker Related Articles

Deleting Portal User favorites

How to delete user favorites

Published on: filed in: Portal Related Articles

Deleting Rows in ExcelToCI

A quick code fix to allow for row deletions in excelToCI.

Published on: filed in: Component Interface Related Articles

Deleting Service Operation Log Tables During Development

An alternative to appmsgpurgeall.dms for one service operation.

Published on: filed in: Integration Broker Related Articles , Web Services Related Articles

Design Principles

Some thoughts on effective design

Published on: filed in: Design Related Articles

Doing more with files with Java and PeopleCode

Some code examples of using java within PeopleCode.

Published on: filed in: PeopleCode Related Articles

Effectively Customizing Online Pages with PeopleCode

A few tips on how effectively customize a page with PeopleCode

Published on: filed in: PeopleCode Related Articles

Effectively Organizing your PeopleCode

Some tips on how to organize your PeopleCode better.

Published on: filed in: PeopleCode Related Articles

Executing System Commands from PeopleCode and Getting STDOUT

Some PeopleCode examples to run operations system commands from PeopleCode and get the output.

Published on: filed in: PeopleCode Related Articles

Explaining the PeopleCode @ operator

Have you ever seen the PeopleCode @ operator and wondered when and why you would use it?

Published on: filed in: PeopleCode Related Articles

File Attachment Storage Options

Pros and cons of different storage options.

Published on: filed in: Design Related Articles , PeopleCode Related Articles

Find Missing Component Interfaces for user

This sql should find component interfaces that a specific user does not have.

Published on: filed in: Component Interface Related Articles , Security Related Articles

Find Missing Portal Pagelets on a user’s home page

Here is query that will find those missing missing pagelets.

Published on: filed in: Portal Related Articles

Find Portal CREF in Navigation

Here is a quick way to find where a component shows up in the portal navigation for a given component.

Published on: filed in: Portal Related Articles

Find Tables with Specific Field Names

Have you ever wanted to find a table that had specific combination of fields on it?

Published on: filed in: PeopleTools Related Articles

Find Unused Permission Lists

This query should find unused permission lists that could be deleted.

Published on: filed in: Security Related Articles

Find and Audit Active Service Operations

Some SQL that will show you active service operations

Published on: filed in: Integration Broker Related Articles , Web Services Related Articles

Force a CREF Open in a New Window

Here is a quick tip to make a portal Content Reference (CREF) open in a new window.

Published on: filed in: Portal Related Articles

Getting Integration Broker Code to Run as a Different User

We will explore how to run integration broker code as another user.

Published on: filed in: Integration Broker Related Articles

HTTP Form Posts and the PeopleTools Integration Broker

When integrating with 3rd Party applications the question often comes up can the PeopleTools integration broker handle http from post data either sending or receiving. The short answer is no.

Published on: filed in: Integration Broker Related Articles , Web Services Related Articles

HTTP Post to PeopleSoft Integration Broker using Python

An example python script that posts to the PeopleSoft Integration broker HTTP connector.


High Level Overview of Integration Broker Publishing Steps

The Application Messaging / Integration Broker is a complicated PeopleSoft module and can be very confusing if you don’t know what to look for.

Published on: filed in: Integration Broker Related Articles

How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

Published on: filed in: Design Related Articles

How to Cancel a Queued Process in PeopleCode

Here is a sample PeopleCodecode snippet to cancel a process request.

Published on: filed in: PeopleCode Related Articles , Process Scheduler Related Articles

How to Change Search Records in Component Interface

There are times when coding with Component Interface that you need a different search record that the one defined on the component.

Published on: filed in: Component Interface Related Articles

How to FULLSYNC tables between PeopleSoft databases

This will show you how you can easily do a FULLSYNC of a table from one PeopleSoft database to another with mostly setup and a small amount of generic code.


How to get files to show up in the Process Monitor/Report Repository

A common problem for SQR and application engine developers is how to make files generated in SQR and Application Engine accessible to the end user(s).


Introduction to the DataDumper Logger

Introduction to the CHG_DataDumper Application Class used for logging.

Published on: filed in: Debugging Related Articles , PeopleCode Related Articles

JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.


JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11


JSONtoXML Application Class - An Alternative Method to Parse JSON in Peoplecode

A new custom solution to convert JSON to XML in PeopleSoft. It makes parsing JSON in PeopleCode easier.


Limitations of PeopleTools Component Interfaces and Web Services

We documented some limitations with Component Interface that are useful to publish.


Linking Between PeopleSoft Components in HTML

How you can link between two PeopleSoft components using an “a” HTML tag.

Published on: filed in: PeopleCode Related Articles

List URLs Accessible to a Permission List

Sample SQL to generate a list of component based URL acceccsible by a permission list.

Published on: filed in: PeopleTools Related Articles , Security Related Articles

Making Pretty Page Text with HTML Areas

Do you want to give your users readable formatted messages and instructions?

Published on: filed in: Design Related Articles

Migrate PeopleSoft Enterprise Portal Managed Content Data with DMS

A DMS script to migrate managed content data between databases.

Published on: filed in: Portal Related Articles

My Love Hate Relationship with PeopleTools Development

Some things I love and hate about PeopleTools development

Published on: filed in:

New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

A new 8.55 feature that may reduce the amount of custom PeopleCode.

Published on: filed in: PeopleCode Related Articles , PeopleTools Related Articles

Parsing Cookies in Integration Broker Request Handler

An example method of parsing cookies in an integration broker handler.

Published on: filed in: Integration Broker Related Articles

Password Extractor

This script will extract password as an update statement to be moved to another database.

Published on: filed in: Security Related Articles

PeopleCode Events that do not fire in Component Interface

A summary of the PeopleCode events that do not fire in Component Interface.

Published on: filed in: Component Interface Related Articles

PeopleCode Function To Validate Email

PeopleCode email REGEX Function

Published on: filed in: PeopleCode Related Articles

PeopleSoft Daemon Application Engine Example

An example usage of a daemon Application Engine

Published on: filed in: Application Engine Related Articles

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.


PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.

Published on: filed in: RESTful Related Articles , Web Services Related Articles

PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.

Published on: filed in: Debugging Related Articles , PeopleCode Related Articles

PeopleTools REST Based Web Services Removing Response

A look at a strange issue/bug/limitation of calling a REST based service from PeopleSoft.


PeopleTools Tables

List of Key PeopleTools Tables

Published on: filed in: PeopleTools Related Articles

Problems with Component Interface and COBOL remotecalls

Having problems with remote call and component interface?

Published on: filed in: Component Interface Related Articles

Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.

Published on: filed in: Integration Broker Related Articles , Security Related Articles

REST Web Services - Generating and Working with Error Responses

A look at sending error responses in PeopleSoft REST web services and some nuances with using them.


Removing MS Word Smart quotes in PeopleSoft Pages

How to remove MS Word smart quotes that get turned into upside down question marks.

Published on: filed in: Design Related Articles , PeopleCode Related Articles

Renaming files using PeopleCode

A simple code example to rename or move a file in PeopleCode.

Published on: filed in: PeopleCode Related Articles

Reporting Web Services: REST JSON Responses

Using the REST Reporting Web Services to get a JSON response

Published on: filed in: JSON and PeopleSoft Related Articles , Web Services Related Articles

Reporting Web Services: Using the REST Web Services to run a Query

Using the REST Reporting Web Services in PeopleSoft to run a query.

Published on: filed in: Web Services Related Articles

Reset Password from back end

Reset a user’s password via the back end.

Published on: filed in: Security Related Articles

Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.


Running Dynamic SQL with SQLEXEC

How to run Dynamic SQL in PeopleCode

Published on: filed in: PeopleCode Related Articles

Running a PeopleSoft Query using the Reporting Web Services

Using the Reporting Web Services in PeopleSoft to run a query.

Published on: filed in: Web Services Related Articles

Running a PeopleSoft Query with Ruby over HTTP

Some ruby code showing how to extract data from PeopleSoft over HTTP.

Published on: filed in: PeopleCode Related Articles , Web Services Related Articles

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

Published on: filed in: Design Related Articles , Security Related Articles

SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.

Published on: filed in: Application Engine Related Articles , PeopleCode Related Articles

ScrollSort and Component Interface Lost Pointer

An issue with ScrollSort and Component Interface.


Should I Re-use An Existing Component Interface (CI) Definition Or Create A New One?

Should you create a new CI definition if one already exists?


Should I ever use the current date in SQL?

If you are using the current date in SQL, you are probably setting yourself up for a disaster.

Published on: filed in: Design Related Articles

Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?


Signon PeopleCode and 3rd party connections

Published on: filed in: PeopleCode Related Articles

Signs you should be using a Component Interface

Some indications of when you should be using CI.

Published on: filed in: Component Interface Related Articles

Some Options for Sending Emails in PeopleTools

Some options and thoughts on sending email from PeopleSoft/PeopleTools

Published on: filed in: Design Related Articles , PeopleCode Related Articles

Some Strengths And Weaknesses Of PeopleTools

Some thoughts on what PeopleTools is good and bad at.

Published on: filed in:

Some Thoughts on Application Engine Temporary Tables

Pros and cons of using temp tables.

Published on: filed in: Application Engine Related Articles , Design Related Articles

Stop Using Page Activate PeopleCode

I think the Page Activate PeopleCode event is evil.


Study List for Learning Integration Broker

We have been getting a lot of requests for an Integration Broker training video targeted at developers.

Published on: filed in: Integration Broker Related Articles

Synchronous HTTP Post to PeopleSoft Integration Broker using Python

An example python script that post a syncronous message to the PeopleSoft Integration broker HTTP connector and gets a response.


The Importance of Having a Unit Test Page

An example of my simple Unit Test page that has saved me hours of development time.

Published on: filed in: Debugging Related Articles , PeopleCode Related Articles

The PSACCESSLOG PeopleTools table Explained

A look at the PSACCESSLOG security table.

Published on: filed in: PeopleTools Related Articles , Security Related Articles

The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.

Published on: filed in: PeopleCode Related Articles

The Pros and Cons of PeopleSoft Bolt-ons versus Customizations

Some pros and cons for bolt-ons versus customization

Published on: filed in: Design Related Articles

The only Peoplecode events you should be using

Key Peoplecode events to use

Published on: filed in: PeopleCode Related Articles

Understanding Integration Broker Queue Partitioning

This article will explain Message Queue partitioning in PeopleTools Integration Broker.

Published on: filed in: Integration Broker Related Articles

Understanding Local Integration Broker Routings

A look into the who, what, when, where, why of local integration broker service operations.

Published on: filed in: Design Related Articles , Integration Broker Related Articles

Understanding PeopleCode Current Context functions

Understanding the PeopleCode current context functions: getrow(), getrowset(), and getfield()

Published on: filed in: PeopleCode Related Articles

Understanding the Integration Broker Monitor

Published on: filed in: Integration Broker Related Articles

Understanding the difference between SYNC and FULLSYNC integrations

An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations.


Unique Constraint Error on PS_MESSAGE_LOG

ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated

Published on: filed in: Process Scheduler Related Articles

Updating PS Query References in the Tools Tables

How to update query record references from the back-end.

Published on: filed in:

Useful PIA Servlet Directives

Published on: filed in: Portal Related Articles

Using Apache HttpClient from PeopleCode

Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker)


Using Chunking Rules with OnRouteSend PeopleCode

A look at using OnRouteSend Combined with PeopleCode

Published on: filed in: Integration Broker Related Articles

Using ExcelTOCI to Delete a User Profile

A walk-thru for using excel to CI to call the DELETE_USER_PROFILE component interface.

Published on: filed in: Component Interface Related Articles

Using Record Objects as Parameters and Returns

This article contains some discussion around using record objects and function parameters.

Published on: filed in: Design Related Articles , PeopleCode Related Articles

Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts

Published on: filed in: PeopleCode Related Articles

Using SQLExec and Record Objects

Here is a quick code snippet to show how to use SQLExec to pull data into a record object not using the key fields of the record.

Published on: filed in: PeopleCode Related Articles

Using Sign On PeopleCode to redirect Users to Specific pages

Some examples of how to redirect user to specific pages at login.

Published on: filed in: PeopleCode Related Articles , Security Related Articles

Using SwitchUser in Integration Broker Subscriptions

An example of using “switchuser” to change user context in subscription PeopleCode.

Published on: filed in: Integration Broker Related Articles

What are FULLSYNC "Chunking" Rules?

A look at FULLSYNC chunking rules

Published on: filed in: Integration Broker Related Articles

When you have a user that is using "My Favorites" they often forget how to get to the real page.

Published on: filed in: Portal Related Articles

Why Exclude PSFT Auth Tokens in Integration Broker?

Some thoughts on excluding PSFT Auth token to simplify security for Web Services

Published on: filed in: Integration Broker Related Articles , Security Related Articles

Will PeopleSoft Support REST Web Services?

For PeopleTools 8.51 and lower the answer is No.


Word Count in PeopleCode Using Regular Expressions

PeopleCode example to get word count using java regular expressions

Published on: filed in: PeopleCode Related Articles