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

KB Article
SQL Generator To Delete EMPLIDs

An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.

KB Article
Compare Permissions on Two Roles

A useful SQL statement to compare to roles and see what differs

KB Article
(Opinionated) App Engine Template

This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program

KB Article
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide

A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.

KB Article
New IB Book Section - HttpTargetConnector

A new book chapter about HttpTargetConnector

Knowledge Base Content by Category

All KB articles organized by category.

Administration

KB Article - Administration
SQL Generator To Delete EMPLIDs

An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.

Admissions

KB Article - Admissions
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide

A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.

Application engine

KB Article - Application engine
(Opinionated) App Engine Template

This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program

KB Article - Application engine
PeopleSoft Daemon Application Engine Example

An example usage of a daemon Application Engine

KB Article - Application engine
SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.

KB Article - Application engine
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).

KB Article - Application engine
Some Thoughts on Application Engine Temporary Tables

Pros and cons of using temp tables.

Campus solutions

KB Article - Campus solutions
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide

A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.

Component interface

KB Article - Component interface
Strategies to Integrate with PeopleSoft

New book chapter on strategies to integration with PeopleSoft.

KB Article - Component interface
Best Practices with PeopleSoft Table Updates and Inserts

New book chapter on table update strategies in PeopleSoft.

KB Article - Component interface
Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping

KB Article - Component interface
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

KB Article - Component interface
An Example of using the CI Find Method

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

KB Article - Component interface
ScrollSort and Component Interface Lost Pointer

An issue with ScrollSort and Component Interface.

KB Article - Component interface
Page and Component Interface: A Warning

A warning about %page and Component Interface

KB Article - Component interface
Criteria to Use Component Interface

What Criteria should lead to the use of CI?

KB Article - 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?

KB Article - Component interface
Using ExcelTOCI to Delete a User Profile

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

KB Article - Component interface
PeopleCode Events that do not fire in Component Interface

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

KB Article - Component interface
Signs you should be using a Component Interface

Some indications of when you should be using CI.

KB Article - Component interface
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.

KB Article - Component interface
Limitations of PeopleTools Component Interfaces and Web Services

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

KB Article - Component interface
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode

KB Article - Component interface
Problems with Component Interface and COBOL remotecalls

Having problems with remote call and component interface?

KB Article - Component interface
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.

KB Article - Component interface
How to Press a Button in Component Interface

When developing with component interfaces you often need to mimic a user pressing a button on the page.

KB Article - Component interface
Deleting Rows in ExcelToCI

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

KB Article - Component interface
Find Missing Component Interfaces for user

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

KB Article - Component interface
10 Step Component Interface Development Process

10 steps to follow when coding using a CI.

Debugging

KB Article - Debugging
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.

KB Article - Debugging
PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.

KB Article - Debugging
The Importance of Having a Unit Test Page

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

KB Article - Debugging
DataDumper Documentation

Documentation for our datadumper application package.

KB Article - Debugging
Introduction to the DataDumper Logger

Introduction to the CHG_DataDumper Application Class used for logging.

Design

KB Article - Design
(Opinionated) App Engine Template

This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program

KB Article - Design
SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

KB Article - Design
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

KB Article - Design
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

KB Article - Design
Understanding Local Integration Broker Routings

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

KB Article - Design
How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

KB Article - Design
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?

KB Article - Design
Some Options for Sending Emails in PeopleTools

Some options and thoughts on sending email from PeopleSoft/PeopleTools

KB Article - Design
Some Strengths And Weaknesses Of PeopleTools

Some thoughts on what PeopleTools is good and bad at.

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

Some pros and cons for bolt-ons versus customization

KB Article - Design
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.

KB Article - Design
Design Principles

Some thoughts on effective design

KB Article - Design
PeopleCode Events that do not fire in Component Interface

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

KB Article - Design
Removing MS Word Smart quotes in PeopleSoft Pages

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

KB Article - Design
The Importance of Having a Unit Test Page

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

KB Article - Design
Creating an Effective Audit Subrecord

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

KB Article - Design
File Attachment Storage Options

Pros and cons of different storage options.

KB Article - Design
Signs you should be using a Component Interface

Some indications of when you should be using CI.

KB Article - Design
A Better Run Control Page Standard

A new run control record proposal

KB Article - Design
KB Article - Design
Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts

KB Article - Design
Limitations of PeopleTools Component Interfaces and Web Services

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

KB Article - Design
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode

KB Article - Design
KB Article - Design
Effectively Organizing your PeopleCode

Some tips on how to organize your PeopleCode better.

KB Article - Design
Making Pretty Page Text with HTML Areas

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

KB Article - Design
Some Thoughts on Application Engine Temporary Tables

Pros and cons of using temp tables.

KB Article - Design
Using Record Objects as Parameters and Returns

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

Effdt

KB Article - Effdt
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.

Fluid

KB Article - Fluid
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

Integration

KB Article - Integration
Integrating Student Data into PeopleSoft Campus Solutions - A Practical Guide

A high level overview of integrating with PeopleSoft Campus Solutions for admitting students.

Integration broker

KB Article - Integration broker
New IB Book Section - HttpTargetConnector

A new book chapter about HttpTargetConnector

KB Article - Integration broker
Strategies to Integrate with PeopleSoft

New book chapter on strategies to integration with PeopleSoft.

KB Article - Integration broker
Best Practices with PeopleSoft Table Updates and Inserts

New book chapter on table update strategies in PeopleSoft.

KB Article - Integration broker
REST HTTP DELETE Example

A full REST Delete Example

KB Article - Integration broker
REST HTTP Post Example

A full REST Post Example

KB Article - Integration broker
How set HTTP Status codes in REST

Example code and documentation on controlling the HTTP status codes in REST web services.

KB Article - Integration broker
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.

KB Article - Integration broker
JSON Parsing Using PeopleTools JsonParser

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

KB Article - Integration broker
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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

KB Article - Integration broker
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.

KB Article - Integration broker
A Complete PeopleSoft REST Web Service Example

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

KB Article - Integration broker
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.

KB Article - Integration broker
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.

KB Article - Integration broker
Using Chunking Rules with OnRouteSend PeopleCode

A look at using OnRouteSend Combined with PeopleCode\

KB Article - Integration broker
What are FULLSYNC Chunking Rules?

A look at FULLSYNC chunking rules

KB Article - Integration broker
Using Apache HttpClient from PeopleCode

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

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

KB Article - Integration broker
Delay Processing in Inbound Asynchronous Subscription Handlers

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

KB Article - Integration broker
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

KB Article - Integration broker
Using SwitchUser in Integration Broker Subscriptions

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

KB Article - Integration broker
Parsing Cookies in Integration Broker Request Handler

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

KB Article - Integration broker
Deleting Service Operation Log Tables During Development

An alternative to appmsgpurgeall.dms for one service operation.

KB Article - Integration broker
Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.

KB Article - Integration broker
Find and Audit Active Service Operations

Some SQL that will show you active service operations

KB Article - Integration broker
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.

KB Article - Integration broker
Understanding Local Integration Broker Routings

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

KB Article - Integration broker
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.

KB Article - Integration broker
HTTP Post to PeopleSoft Integration Broker using Python

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

KB Article - Integration broker
Why Exclude PSFT Auth Tokens in Integration Broker?

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

KB Article - Integration broker
Understanding the difference between SYNC and FULLSYNC integrations

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

KB Article - Integration broker
Getting Integration Broker Code to Run as a Different User

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

KB Article - Integration broker
8.52 and REST support in Integration Broker

Some updated information on REST API support

KB Article - Integration broker
Understanding Integration Broker Queue Partitioning

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

KB Article - Integration broker
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.

KB Article - Integration broker
Will PeopleSoft Support REST Web Services?

For PeopleTools 8.51 and lower the answer is **No**.

KB Article - Integration broker
Understanding the Integration Broker Monitor

A look at how to use the Integration Broker Monitor page.

KB Article - Integration broker
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

KB Article - Java
Renaming files using PeopleCode

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

KB Article - Java
Using Apache HttpClient from PeopleCode

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

KB Article - Java
Doing more with files with Java and PeopleCode

Some code examples of using java within PeopleCode.

JSON

KB Article - JSON
JSON Parsing Using PeopleTools JsonParser

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

KB Article - JSON
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

KB Article - JSON
Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response

KB Article - JSON
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.

KB Article - JSON
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

Most read

KB Article - Most read
JSON Parsing Using PeopleTools JsonParser

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

KB Article - Most read
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.

KB Article - Most read
SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

KB Article - Most read
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

KB Article - Most read
A Complete PeopleSoft REST Web Service Example

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

KB Article - Most read
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.

KB Article - Most read
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

KB Article - Most read
How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

KB Article - Most read
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

KB Article - Most read
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).

Online development

KB Article - Online development
How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record

KB Article - Online development
A Better Run Control Page Standard

A new run control record proposal

KB Article - Online development
Making Pretty Page Text with HTML Areas

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

Peoplecode

KB Article - Peoplecode
(Opinionated) App Engine Template

This article shows a template application engine that you can use which is entirely PeopleCode and NO SQL objects. It will help you have more simple and maintainable application engine program

KB Article - Peoplecode
Strategies to Integrate with PeopleSoft

New book chapter on strategies to integration with PeopleSoft.

KB Article - Peoplecode
Best Practices with PeopleSoft Table Updates and Inserts

New book chapter on table update strategies in PeopleSoft.

KB Article - Peoplecode
REST HTTP DELETE Example

A full REST Delete Example

KB Article - Peoplecode
REST HTTP Post Example

A full REST Post Example

KB Article - Peoplecode
How set HTTP Status codes in REST

Example code and documentation on controlling the HTTP status codes in REST web services.

KB Article - Peoplecode
Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping

KB Article - Peoplecode
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.

KB Article - Peoplecode
JSON Parsing Using PeopleTools JsonParser

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

KB Article - Peoplecode
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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

KB Article - Peoplecode
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.

KB Article - Peoplecode
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

KB Article - Peoplecode
PeopleCode Function To Validate Email

PeopleCode email REGEX Function

KB Article - Peoplecode
Using Sign On PeopleCode to redirect Users to Specific pages

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

KB Article - Peoplecode
A Complete PeopleSoft REST Web Service Example

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

KB Article - Peoplecode
Renaming files using PeopleCode

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

KB Article - Peoplecode
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.

KB Article - Peoplecode
Executing System Commands from PeopleCode and Getting STDOUT

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

KB Article - Peoplecode
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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

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

KB Article - Peoplecode
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.

KB Article - Peoplecode
Page and Component Interface: A Warning

A warning about %page and Component Interface

KB Article - Peoplecode
Using Apache HttpClient from PeopleCode

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

KB Article - Peoplecode
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

KB Article - Peoplecode
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.

KB Article - Peoplecode
Criteria to Use Component Interface

What Criteria should lead to the use of CI?

KB Article - Peoplecode
HTTP Post to PeopleSoft Integration Broker using Python

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

KB Article - Peoplecode
Application Classes and Global Variables are like Oil and Water

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

KB Article - Peoplecode
Understanding the difference between SYNC and FULLSYNC integrations

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

KB Article - Peoplecode
Linking Between PeopleSoft Components in HTML

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

KB Article - Peoplecode
Running a PeopleSoft Query with Ruby over HTTP

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

KB Article - Peoplecode
Some Options for Sending Emails in PeopleTools

Some options and thoughts on sending email from PeopleSoft/PeopleTools

KB Article - Peoplecode
How to Cancel a Queued Process in PeopleCode

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

KB Article - Peoplecode
PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.

KB Article - Peoplecode
PeopleCode Events that do not fire in Component Interface

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

KB Article - Peoplecode
The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.

KB Article - Peoplecode
Understanding PeopleCode Current Context functions

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

KB Article - Peoplecode
SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.

KB Article - Peoplecode
Removing MS Word Smart quotes in PeopleSoft Pages

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

KB Article - Peoplecode
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.

KB Article - Peoplecode
The Importance of Having a Unit Test Page

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

KB Article - Peoplecode
Creating an Effective Audit Subrecord

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

KB Article - Peoplecode
File Attachment Storage Options

Pros and cons of different storage options.

KB Article - Peoplecode
Word Count in PeopleCode Using Regular Expressions

PeopleCode example to get word count using java regular expressions

KB Article - Peoplecode
KB Article - Peoplecode
Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts

KB Article - Peoplecode
Effectively Customizing Online Pages with PeopleCode

A few tips on how effectively customize a page with PeopleCode

KB Article - Peoplecode
Explaining the PeopleCode @ operator

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

KB Article - Peoplecode
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.

KB Article - Peoplecode
Running Dynamic SQL with SQLEXEC

How to run Dynamic SQL in PeopleCode

KB Article - Peoplecode
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode

KB Article - Peoplecode
KB Article - Peoplecode
Effectively Organizing your PeopleCode

Some tips on how to organize your PeopleCode better.

KB Article - Peoplecode
DataDumper Documentation

Documentation for our datadumper application package.

KB Article - Peoplecode
Doing more with files with Java and PeopleCode

Some code examples of using java within PeopleCode.

KB Article - Peoplecode
Introduction to the DataDumper Logger

Introduction to the CHG_DataDumper Application Class used for logging.

KB Article - Peoplecode
Signon PeopleCode and 3rd party connections

A note about 3rd party CI connections and signon PeopleCode.

KB Article - Peoplecode
Using Record Objects as Parameters and Returns

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

KB Article - Peoplecode
Accessing Related Fields in PeopleCode

How to programmatically access related fields in PeopleCode.

KB Article - Peoplecode
Copy Field values between different records

Copy like named fields between two different records.

KB Article - Peoplecode
Create Excel Files in SQR and PeopleCode

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

Peopletools

KB Article - Peopletools
Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping

KB Article - Peopletools
A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table

KB Article - Peopletools
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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

KB Article - Peopletools
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.

KB Article - Peopletools
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.

KB Article - Peopletools
How to Visually Compare Two Pages in Application Designer

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

KB Article - Peopletools
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.

KB Article - Peopletools
List URLs Accessible to a Permission List

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

KB Article - Peopletools
Some Strengths And Weaknesses Of PeopleTools

Some thoughts on what PeopleTools is good and bad at.

KB Article - Peopletools
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

KB Article - Peopletools
My Love Hate Relationship with PeopleTools Development

Some things I love and hate about PeopleTools development

KB Article - Peopletools
The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.

KB Article - Peopletools
Find Tables with Specific Field Names

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

KB Article - Peopletools
PeopleTools Tables - The Important Ones

List of Key PeopleTools Tables

KB Article - Peopletools
Updating PS Query References in the Tools Tables

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

KB Article - Peopletools

Portal

KB Article - Portal
Find and Delete Empty Portal CREF Folder Permissions

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

KB Article - Portal
Migrate PeopleSoft Enterprise Portal Managed Content Data with DMS

A DMS script to migrate managed content data between databases.

KB Article - Portal
Deleting Portal User favorites

How to delete user favorites

KB Article - Portal
Find Missing Portal Pagelets on a user’s home page

Here is query that will find those missing missing pagelets.

KB Article - Portal
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.

KB Article - Portal
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.

KB Article - Portal
KB Article - Portal
Adding Custom CREF Images to Folders

How to add custom images to a portal CREF

Process scheduler

KB Article - Process scheduler
A Look at Max Concurrent Process Definition Property

A look at the "Max Concurrent" process definition property

KB Article - Process scheduler
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 2am? Why?

KB Article - Process scheduler
How to Cancel a Queued Process in PeopleCode

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

KB Article - Process scheduler
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).

KB Article - Process scheduler
Unique Constraint Error on PS_MESSAGE_LOG

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

Python

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

KB Article - Python
HTTP Post to PeopleSoft Integration Broker using Python

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

Query

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

KB Article - Query
Updating PS Query References in the Tools Tables

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

Rest

KB Article - Rest
REST HTTP DELETE Example

A full REST Delete Example

KB Article - Rest
REST HTTP Post Example

A full REST Post Example

KB Article - Rest
How set HTTP Status codes in REST

Example code and documentation on controlling the HTTP status codes in REST web services.

KB Article - Rest
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.

KB Article - Rest
JSON Parsing Using PeopleTools JsonParser

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

KB Article - Rest
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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

KB Article - Rest
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.

KB Article - Rest
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11

KB Article - Rest
A Complete PeopleSoft REST Web Service Example

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

KB Article - Rest
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.

KB Article - Rest
Reporting Web Services: Using the REST Web Services to run a Query

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

KB Article - Rest
Using Apache HttpClient from PeopleCode

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

KB Article - Rest
PeopleTools REST Based Web Services Removing Response

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

KB Article - Rest
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.

KB Article - Rest
PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.

KB Article - Rest
8.52 and REST support in Integration Broker

Some updated information on REST API support

KB Article - Rest
Will PeopleSoft Support REST Web Services?

For PeopleTools 8.51 and lower the answer is **No**.

Ruby

KB Article - Ruby
Running a PeopleSoft Query with Ruby over HTTP

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

Saml

KB Article - Saml
SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

Security

KB Article - Security
Compare Permissions on Two Roles

A useful SQL statement to compare to roles and see what differs

KB Article - Security
SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.

KB Article - Security
Using Sign On PeopleCode to redirect Users to Specific pages

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

KB Article - Security
A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table

KB Article - Security
Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.

KB Article - Security
Why Exclude PSFT Auth Tokens in Integration Broker?

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

KB Article - Security
Find and Delete Empty Portal CREF Folder Permissions

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

KB Article - Security
List URLs Accessible to a Permission List

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

KB Article - Security
Data Security and Self Service Search Records

An explanation of search records for self-service components.

KB Article - Security
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.

KB Article - Security
Find Missing Component Interfaces for user

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

KB Article - Security
Find Unused Permission Lists

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

KB Article - Security
Password Extractor

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

KB Article - Security
Reset Password from back end

Reset a user's password via the back end.

KB Article - Security
Signon PeopleCode and 3rd party connections

A note about 3rd party CI connections and signon PeopleCode.

KB Article - Security
Back End Role Insert

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

SQL

KB Article - SQL
SQL Generator To Delete EMPLIDs

An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.

Sqr

KB Article - Sqr
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).

KB Article - Sqr
Create Excel Files in SQR and PeopleCode

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

Upgrade

KB Article - Upgrade
Updating PS Query References in the Tools Tables

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

Web services

KB Article - Web services
Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response

KB Article - Web services
Reporting Web Services: Using the REST Web Services to run a Query

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

KB Article - Web services
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.

KB Article - Web services
Running a PeopleSoft Query using the Reporting Web Services

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

KB Article - Web services
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?

KB Article - Web services
PeopleTools REST Based Web Services Removing Response

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

KB Article - Web services
Find and Audit Active Service Operations

Some SQL that will show you active service operations

KB Article - Web services
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.

KB Article - Web services
PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.

KB Article - Web services
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.

KB Article - Web services
HTTP Post to PeopleSoft Integration Broker using Python

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

KB Article - Web services
Understanding the difference between SYNC and FULLSYNC integrations

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

KB Article - Web services
Running a PeopleSoft Query with Ruby over HTTP

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

KB Article - Web services
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?

KB Article - Web services
8.52 and REST support in Integration Broker

Some updated information on REST API support

KB Article - Web services
Limitations of PeopleTools Component Interfaces and Web Services

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

KB Article - Web services
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.

KB Article - Web services
Will PeopleSoft Support REST Web Services?

For PeopleTools 8.51 and lower the answer is **No**.