Knowledge Base

Welcome to the Knowledge Base. Here you will find an ever expanding list of technical knowledge mostly around PeopleTools technology. However, other areas are covered here as well.

Recent Articles

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

PsoftToXML Application Class - Convert PeopleSoft Object to XML

PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.

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.

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

Knowledge Base Content by Category

All KB articles organized by category.

Application engine

SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.

Component interface

Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

An Example of using the CI Find Method

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

ScrollSort and Component Interface Lost Pointer

An issue with ScrollSort and Component Interface.

Page and Component Interface: A Warning

A warning about %page and Component Interface

Criteria to Use Component Interface

What Criteria should lead to the use of CI?

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?

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.

Limitations of PeopleTools Component Interfaces and Web Services

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

Find Missing Component Interfaces for user

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

10 Step Component Interface Development Process

10 steps to follow when coding using a CI.

Debugging

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

A quick hack to resolve 15,30 error messages.

PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.

The Importance of Having a Unit Test Page

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

DataDumper Documentation

Documentation for our datadumper application package.

Design

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

Understanding Local Integration Broker Routings

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

How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

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?

The Pros and Cons of PeopleSoft Bolt-ons versus Customization's

Some pros and cons for bolt-ons versus customization

The Importance of Having a Unit Test Page

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

Creating an Effective Audit Subrecord

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

A Better Run Control Page Standard

A new run control record proposal

Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts

Limitations of PeopleTools Component Interfaces and Web Services

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

Making Pretty Page Text with HTML Areas

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

Fluid

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

Integration broker

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

PsoftToXML Application Class - Convert PeopleSoft Object to XML

PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.

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.

A Complete PeopleSoft REST Web Service Example

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

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.

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.

Using Chunking Rules with OnRouteSend PeopleCode

A look at using OnRouteSend Combined with PeopleCode\

What are FULLSYNC Chunking Rules?

A look at FULLSYNC chunking rules

Using Apache HttpClient from PeopleCode

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

PeopleTools REST Based Web Services Removing Response

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

Delay Processing in Inbound Asynchronous Subscription Handlers

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

JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

Using SwitchUser in Integration Broker Subscriptions

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

Parsing Cookies in Integration Broker Request Handler

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

Deleting Service Operation Log Tables During Development

An alternative to appmsgpurgeall.dms for one service operation.

Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.

Find and Audit Active Service Operations

Some SQL that will show you active service operations

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.

Understanding Local Integration Broker Routings

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

Synchronous HTTP Post to PeopleSoft Integration Broker using Python

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

HTTP Post to PeopleSoft Integration Broker using Python

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

Why Exclude PSFT Auth Tokens in Integration Broker?

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

Understanding the difference between SYNC and FULLSYNC integrations

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

Getting Integration Broker Code to Run as a Different User

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

Study List for Learning Integration Broker

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

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.

Java

Using Apache HttpClient from PeopleCode

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

Json

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response

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.

JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

Most read

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

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.

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

A Complete PeopleSoft REST Web Service Example

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

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

A quick hack to resolve 15,30 error messages.

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

Online development

How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

A Better Run Control Page Standard

A new run control record proposal

Making Pretty Page Text with HTML Areas

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

Peoplecode

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

PsoftToXML Application Class - Convert PeopleSoft Object to XML

PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.

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.

JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

Using Sign On PeopleCode to redirect Users to Specific pages

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

A Complete PeopleSoft REST Web Service Example

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

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.

Executing System Commands from PeopleCode and Getting STDOUT

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

New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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

An Example of using the CI Find Method

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

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

A quick hack to resolve 15,30 error messages.

Page and Component Interface: A Warning

A warning about %page and Component Interface

Using Apache HttpClient from PeopleCode

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

JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

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.

Criteria to Use Component Interface

What Criteria should lead to the use of CI?

HTTP Post to PeopleSoft Integration Broker using Python

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

Application Classes and Global Variables are like Oil and Water

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

Understanding the difference between SYNC and FULLSYNC integrations

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

Linking Between PeopleSoft Components in HTML

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

PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.

The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.

SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.

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.

The Importance of Having a Unit Test Page

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

Creating an Effective Audit Subrecord

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

Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts

Effectively Customizing Online Pages with PeopleCode

A few tips on how effectively customize a page with PeopleCode

Explaining the PeopleCode @ operator

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

Running Dynamic SQL with SQLEXEC

How to run Dynamic SQL in PeopleCode

DataDumper Documentation

Documentation for our datadumper application package.

Accessing Related Fields in PeopleCode

How to programmatically access related fields in PeopleCode.

Copy Field values between different records

Copy like named fields between two different records.

Create Excel Files in SQR and PeopleCode

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

Peopletools

A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table

New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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

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

A quick hack to resolve 15,30 error messages.

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

How to Visually Compare Two Pages in Application Designer

We show how to visually compare a page between two databases or a file.

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.

List URLs Accessible to a Permission List

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

The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.

PeopleTools Tables

List of Key PeopleTools Tables

Updating PS Query References in the Tools Tables

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

Portal

Find and Delete Empty Portal CREF Folder Permissions

Some SQL to find and delete Portal CREF permissions where there are no children.

Deleting Portal User favorites

How to delete user favorites

Process scheduler

A Look at Max Concurrent Process Definition Property

A look at the "Max Concurrent" process definition property

Python

Synchronous HTTP Post to PeopleSoft Integration Broker using Python

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

HTTP Post to PeopleSoft Integration Broker using Python

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

Query

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

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

Updating PS Query References in the Tools Tables

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

Rest

JSON Parsing Using PeopleTools JsonParser

An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser.

PsoftToXML Application Class - Convert PeopleSoft Object to XML

PeopleCode Application Class that converts a Peoplesoft Object to XML for web services.

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.

JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

A Complete PeopleSoft REST Web Service Example

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

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.

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

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

Using Apache HttpClient from PeopleCode

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

PeopleTools REST Based Web Services Removing Response

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

JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.

Ruby

Saml

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

Security

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

Using Sign On PeopleCode to redirect Users to Specific pages

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

A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table

Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.

Why Exclude PSFT Auth Tokens in Integration Broker?

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

Find and Delete Empty Portal CREF Folder Permissions

Some SQL to find and delete Portal CREF permissions where there are no children.

List URLs Accessible to a Permission List

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

Data Security and Self Service Search Records

An explanation of search records for self-service components.

The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

Find Missing Component Interfaces for user

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

Reset Password from back end

Reset a user's password via the back end.

Back End Role Insert

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

Sqr

Create Excel Files in SQR and PeopleCode

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

Upgrade

Updating PS Query References in the Tools Tables

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

Web services

Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response

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

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

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.

Running a PeopleSoft Query using the Reporting Web Services

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

Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

PeopleTools REST Based Web Services Removing Response

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

Find and Audit Active Service Operations

Some SQL that will show you active service operations

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.

PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.

Synchronous HTTP Post to PeopleSoft Integration Broker using Python

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

HTTP Post to PeopleSoft Integration Broker using Python

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

Understanding the difference between SYNC and FULLSYNC integrations

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

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?

Limitations of PeopleTools Component Interfaces and Web Services

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