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

How set HTTP Status codes in REST

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


  • Categories: PeopleCode REST Integration Broker
  • Published: Nov 8, 2019
Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping


  • Categories: PeopleCode PeopleTools Component Interface
  • Published: Oct 25, 2019
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.


  • Categories: PeopleCode REST Integration Broker
  • Published: Sep 6, 2019
JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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


  • Categories: PeopleCode Integration Broker REST
  • Published: Oct 27, 2017

Knowledge Base Content by Category

All KB articles organized by category.

Application engine

PeopleSoft Daemon Application Engine Example


  • Categories: Application Engine
  • Published: Jun 6, 2012
SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.


  • Categories: PeopleCode Application Engine
  • Published: Mar 14, 2012
How to get files to show up in the Process Monitor/Report Repository


  • Categories: SQR Application Engine Process Scheduler Most Read
  • Published: Apr 17, 2011
Some Thoughts on Application Engine Temporary Tables


  • Categories: Application Engine Design
  • Published: Oct 13, 2010

Component interface

Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping


  • Categories: PeopleCode PeopleTools Component Interface
  • Published: Oct 25, 2019
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?


  • Categories: Component Interface Design Web Services
  • Published: Jun 22, 2015
An Example of using the CI Find Method

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


  • Categories: Component Interface PeopleCode
  • Published: Jun 16, 2015
ScrollSort and Component Interface Lost Pointer

An issue with ScrollSort and Component Interface.


  • Categories: Component Interface
  • Published: May 27, 2015
Page and Component Interface: A Warning

A warning about %page and Component Interface


  • Categories: Component Interface PeopleCode
  • Published: May 19, 2015
Criteria to Use Component Interface

What Criteria should lead to the use of CI?


  • Categories: Component Interface PeopleCode
  • Published: May 29, 2013
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?


  • Categories: Design Component Interface Web Services
  • Published: Sep 6, 2012
Using ExcelTOCI to Delete a User Profile


  • Categories: Component Interface
  • Published: Jul 17, 2012
PeopleCode Events that do not fire in Component Interface


  • Categories: Component Interface PeopleCode Design
  • Published: Apr 25, 2012
Signs you should be using a Component Interface


  • Categories: Component Interface Design
  • Published: Nov 28, 2011
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.


  • Categories: Component Interface
  • Published: Sep 14, 2011
Limitations of PeopleTools Component Interfaces and Web Services

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


  • Categories: Component Interface Design Web Services
  • Published: Jun 18, 2011
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode


  • Categories: Component Interface PeopleCode Design
  • Published: May 11, 2011
Problems with Component Interface and COBOL remotecalls


  • Categories: Component Interface
  • Published: Apr 3, 2011
How to Change Search Records in Component Interface


  • Categories: Component Interface
  • Published: Mar 10, 2011
How to Press a Button in Component Interface


  • Categories: Component Interface
  • Published: Jan 4, 2011
Deleting Rows in ExcelToCI


  • Categories: Component Interface
  • Published: Oct 13, 2010
Find Missing Component Interfaces for user

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


  • Categories: Security Component Interface
  • Published: Oct 13, 2010
10 Step Component Interface Development Process

10 steps to follow when coding using a CI.


  • Categories: Component Interface
  • Published: Oct 12, 2010

Debugging

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

A quick hack to resolve 15,30 error messages.


  • Categories: PeopleCode PeopleTools Debugging Most Read
  • Published: Jun 9, 2015
The Importance of Having a Unit Test Page

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


  • Categories: Debugging PeopleCode Design
  • Published: Feb 7, 2012
DataDumper Documentation

Documentation for our datadumper application package.


  • Categories: PeopleCode Debugging
  • Published: Oct 13, 2010
Introduction to the DataDumper Logger


  • Categories: PeopleCode Debugging
  • Published: Oct 13, 2010

Design

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.


  • Categories: Security Design SAML Most Read
  • Published: Jan 26, 2017
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?


  • Categories: Component Interface Design Web Services
  • Published: Jun 22, 2015
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.


  • Categories: Design Fluid PeopleTools Most Read
  • Published: Feb 2, 2015
Understanding Local Integration Broker Routings

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


  • Categories: Design Integration Broker
  • Published: May 16, 2013
How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record


  • Categories: Design Online Development Most Read
  • Published: Oct 31, 2012
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?


  • Categories: Design Component Interface Web Services
  • Published: Sep 6, 2012
Some Options for Sending Emails in PeopleTools


  • Categories: PeopleCode Design
  • Published: Sep 1, 2012
Some Strengths And Weaknesses Of PeopleTools


  • Categories: Design PeopleTools
  • Published: Aug 23, 2012
The Pros and Cons of PeopleSoft Bolt-ons versus Customization's

Some pros and cons for bolt-ons versus customization


  • Categories: Design
  • Published: Jul 24, 2012
Should I ever use the current date in SQL?


  • Categories: Design
  • Published: Jul 10, 2012
Design Principles


  • Categories: Design
  • Published: May 3, 2012
PeopleCode Events that do not fire in Component Interface


  • Categories: Component Interface PeopleCode Design
  • Published: Apr 25, 2012
Removing MS Word Smart quotes in PeopleSoft Pages


  • Categories: PeopleCode Design
  • Published: Feb 28, 2012
The Importance of Having a Unit Test Page

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


  • Categories: Debugging PeopleCode Design
  • Published: Feb 7, 2012
Creating an Effective Audit Subrecord

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


  • Categories: Design PeopleCode
  • Published: Jan 24, 2012
File Attachment Storage Options


  • Categories: PeopleCode Design
  • Published: Jan 12, 2012
Signs you should be using a Component Interface


  • Categories: Component Interface Design
  • Published: Nov 28, 2011
A Better Run Control Page Standard

A new run control record proposal


  • Categories: Online Development Design
  • Published: Nov 14, 2011
The only Peoplecode events you should be using

Key Peoplecode events to use


  • Categories: PeopleCode Design
  • Published: Nov 7, 2011
Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts


  • Categories: PeopleCode Design
  • Published: Oct 31, 2011
Limitations of PeopleTools Component Interfaces and Web Services

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


  • Categories: Component Interface Design Web Services
  • Published: Jun 18, 2011
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode


  • Categories: Component Interface PeopleCode Design
  • Published: May 11, 2011
Avoid Global Variables with query string parameters

Global variables are evil!


  • Categories: PeopleCode Design
  • Published: Apr 25, 2011
Effectively Organizing your PeopleCode


  • Categories: PeopleCode Design
  • Published: Apr 3, 2011
Making Pretty Page Text with HTML Areas

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


  • Categories: Design Online Development
  • Published: Oct 13, 2010
Some Thoughts on Application Engine Temporary Tables


  • Categories: Application Engine Design
  • Published: Oct 13, 2010
Using Record Objects as Parameters and Returns


  • Categories: PeopleCode Design
  • Published: Oct 13, 2010

Fluid

PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.


  • Categories: Design Fluid PeopleTools Most Read
  • Published: Feb 2, 2015

Integration broker

How set HTTP Status codes in REST

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


  • Categories: PeopleCode REST Integration Broker
  • Published: Nov 8, 2019
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.


  • Categories: PeopleCode REST Integration Broker
  • Published: Sep 6, 2019
JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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


  • Categories: PeopleCode Integration Broker REST
  • Published: Oct 27, 2017
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.


  • Categories: PeopleCode Integration Broker REST Most Read
  • Published: Mar 19, 2017
A Complete PeopleSoft REST Web Service Example

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


  • Categories: PeopleCode REST Integration Broker Most Read
  • Published: Aug 2, 2016
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.


  • Categories: Integration Broker JSON REST PeopleCode
  • Published: May 31, 2016
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.


  • Categories: Integration Broker Web Services
  • Published: Aug 13, 2015
Using Chunking Rules with OnRouteSend PeopleCode

A look at using OnRouteSend Combined with PeopleCode\


  • Categories: Integration Broker
  • Published: Jul 27, 2015
What are FULLSYNC Chunking Rules?

A look at FULLSYNC chunking rules


  • Categories: Integration Broker
  • Published: Jul 7, 2015
Using Apache HttpClient from PeopleCode

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


  • Categories: PeopleCode REST Java Integration Broker
  • Published: Aug 12, 2014
PeopleTools REST Based Web Services Removing Response

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


  • Categories: Integration Broker REST Web Services
  • Published: Aug 5, 2014
Delay Processing in Inbound Asynchronous Subscription Handlers

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


  • Categories: Integration Broker
  • Published: Jun 2, 2014
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.


  • Categories: PeopleCode Integration Broker REST JSON
  • Published: May 27, 2014
Using SwitchUser in Integration Broker Subscriptions

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


  • Categories: Integration Broker
  • Published: May 12, 2014
Parsing Cookies in Integration Broker Request Handler

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


  • Categories: Integration Broker
  • Published: May 5, 2014
Deleting Service Operation Log Tables During Development

An alternative to appmsgpurgeall.dms for one service operation.


  • Categories: Integration Broker
  • Published: Jan 21, 2014
Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.


  • Categories: Integration Broker Security
  • Published: Oct 8, 2013
Find and Audit Active Service Operations

Some SQL that will show you active service operations


  • Categories: Web Services Integration Broker
  • Published: Sep 5, 2013
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.


  • Categories: PeopleCode Web Services Integration Broker
  • Published: Jul 10, 2013
Understanding Local Integration Broker Routings

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


  • Categories: Design Integration Broker
  • Published: May 16, 2013
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.


  • Categories: Web Services Python Integration Broker
  • Published: Apr 4, 2013
HTTP Post to PeopleSoft Integration Broker using Python

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


  • Categories: PeopleCode Python Integration Broker Web Services
  • Published: Apr 1, 2013
Why Exclude PSFT Auth Tokens in Integration Broker?

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


  • Categories: Integration Broker Security
  • Published: Mar 18, 2013
Understanding the difference between SYNC and FULLSYNC integrations

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


  • Categories: Web Services Integration Broker PeopleCode
  • Published: Nov 26, 2012
Getting Integration Broker Code to Run as a Different User

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


  • Categories: Integration Broker
  • Published: Jan 31, 2012
Study List for Learning Integration Broker

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


  • Categories: Integration Broker
  • Published: Jul 4, 2011
8.52 and REST support in Integration Broker


  • Categories: Integration Broker REST Web Services
  • Published: Jun 29, 2011
Understanding Integration Broker Queue Partitioning


  • Categories: Integration Broker
  • Published: Jun 1, 2011
HTTP Form Posts and the PeopleTools Integration Broker


  • Categories: Web Services Integration Broker
  • Published: Feb 3, 2011
Will PeopleSoft Support REST Web Services?


  • Categories: Integration Broker Web Services REST
  • Published: Feb 3, 2011
Understanding the Integration Broker Monitor


  • Categories: Integration Broker
  • Published: Oct 13, 2010
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.


  • Categories: Integration Broker
  • Published: Jan 1, 2010

J s o n

JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11


  • Categories: PeopleCode REST JSON Most Read
  • Published: Jan 10, 2017
Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response


  • Categories: Web Services JSON
  • Published: Sep 1, 2016
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.


  • Categories: Integration Broker JSON REST PeopleCode
  • Published: May 31, 2016
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.


  • Categories: PeopleCode Integration Broker REST JSON
  • Published: May 27, 2014

Java

Renaming files using PeopleCode


  • Categories: PeopleCode Java
  • Published: Jul 5, 2016
Using Apache HttpClient from PeopleCode

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


  • Categories: PeopleCode REST Java Integration Broker
  • Published: Aug 12, 2014
Doing more with files with Java and PeopleCode


  • Categories: PeopleCode Java
  • Published: Oct 13, 2010

Most read

JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
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.


  • Categories: PeopleCode Integration Broker REST Most Read
  • Published: Mar 19, 2017
SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.


  • Categories: Security Design SAML Most Read
  • Published: Jan 26, 2017
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11


  • Categories: PeopleCode REST JSON Most Read
  • Published: Jan 10, 2017
A Complete PeopleSoft REST Web Service Example

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


  • Categories: PeopleCode REST Integration Broker Most Read
  • Published: Aug 2, 2016
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.


  • Categories: PeopleCode PeopleTools Debugging Most Read
  • Published: Jun 9, 2015
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.


  • Categories: Design Fluid PeopleTools Most Read
  • Published: Feb 2, 2015
How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record


  • Categories: Design Online Development Most Read
  • Published: Oct 31, 2012
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.


  • Categories: PeopleTools Security Most Read
  • Published: Aug 7, 2012
How to get files to show up in the Process Monitor/Report Repository


  • Categories: SQR Application Engine Process Scheduler Most Read
  • Published: Apr 17, 2011

Online development

How to Bypass a PeopleSoft search record

Ways to bypass a PeopleSoft search record


  • Categories: Design Online Development Most Read
  • Published: Oct 31, 2012
A Better Run Control Page Standard

A new run control record proposal


  • Categories: Online Development Design
  • Published: Nov 14, 2011
Making Pretty Page Text with HTML Areas

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


  • Categories: Design Online Development
  • Published: Oct 13, 2010

People code

How set HTTP Status codes in REST

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


  • Categories: PeopleCode REST Integration Broker
  • Published: Nov 8, 2019
Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping


  • Categories: PeopleCode PeopleTools Component Interface
  • Published: Oct 25, 2019
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.


  • Categories: PeopleCode REST Integration Broker
  • Published: Sep 6, 2019
JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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


  • Categories: PeopleCode Integration Broker REST
  • Published: Oct 27, 2017
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.


  • Categories: PeopleCode Integration Broker REST Most Read
  • Published: Mar 19, 2017
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11


  • Categories: PeopleCode REST JSON Most Read
  • Published: Jan 10, 2017
PeopleCode Function To Validate Email


  • Categories: PeopleCode
  • Published: Nov 16, 2016
Using Sign On PeopleCode to redirect Users to Specific pages

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


  • Categories: PeopleCode Security
  • Published: Oct 31, 2016
A Complete PeopleSoft REST Web Service Example

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


  • Categories: PeopleCode REST Integration Broker Most Read
  • Published: Aug 2, 2016
Renaming files using PeopleCode


  • Categories: PeopleCode Java
  • Published: Jul 5, 2016
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.


  • Categories: Integration Broker JSON REST PeopleCode
  • Published: May 31, 2016
Executing System Commands from PeopleCode and Getting STDOUT

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


  • Categories: PeopleCode
  • Published: May 15, 2016
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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


  • Categories: PeopleTools PeopleCode
  • Published: Dec 8, 2015
An Example of using the CI Find Method

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


  • Categories: Component Interface PeopleCode
  • Published: Jun 16, 2015
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.


  • Categories: PeopleCode PeopleTools Debugging Most Read
  • Published: Jun 9, 2015
Page and Component Interface: A Warning

A warning about %page and Component Interface


  • Categories: Component Interface PeopleCode
  • Published: May 19, 2015
Using Apache HttpClient from PeopleCode

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


  • Categories: PeopleCode REST Java Integration Broker
  • Published: Aug 12, 2014
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.


  • Categories: PeopleCode Integration Broker REST JSON
  • Published: May 27, 2014
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.


  • Categories: PeopleCode Web Services Integration Broker
  • Published: Jul 10, 2013
Criteria to Use Component Interface

What Criteria should lead to the use of CI?


  • Categories: Component Interface PeopleCode
  • Published: May 29, 2013
HTTP Post to PeopleSoft Integration Broker using Python

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


  • Categories: PeopleCode Python Integration Broker Web Services
  • Published: Apr 1, 2013
Application Classes and Global Variables are like Oil and Water

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


  • Categories: PeopleCode
  • Published: Jan 3, 2013
Understanding the difference between SYNC and FULLSYNC integrations

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


  • Categories: Web Services Integration Broker PeopleCode
  • Published: Nov 26, 2012
Linking Between PeopleSoft Components in HTML

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


  • Categories: PeopleCode
  • Published: Nov 13, 2012
Running a PeopleSoft Query with Ruby over HTTP


  • Categories: PeopleCode Ruby Web Services
  • Published: Sep 26, 2012
Some Options for Sending Emails in PeopleTools


  • Categories: PeopleCode Design
  • Published: Sep 1, 2012
How to Cancel a Queued Process in PeopleCode


  • Categories: Process Scheduler PeopleCode
  • Published: May 29, 2012
PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.


  • Categories: debugging PeopleCode
  • Published: May 15, 2012
PeopleCode Events that do not fire in Component Interface


  • Categories: Component Interface PeopleCode Design
  • Published: Apr 25, 2012
The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.


  • Categories: PeopleCode PeopleTools
  • Published: Mar 20, 2012
Understanding PeopleCode Current Context functions


  • Categories: PeopleCode
  • Published: Mar 17, 2012
SFTP Example using PeopleCode

A PeopleCode example of using sftp to transfer a file.


  • Categories: PeopleCode Application Engine
  • Published: Mar 14, 2012
Removing MS Word Smart quotes in PeopleSoft Pages


  • Categories: PeopleCode Design
  • Published: Feb 28, 2012
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.


  • Categories: PeopleCode
  • Published: Feb 14, 2012
The Importance of Having a Unit Test Page

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


  • Categories: Debugging PeopleCode Design
  • Published: Feb 7, 2012
Creating an Effective Audit Subrecord

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


  • Categories: Design PeopleCode
  • Published: Jan 24, 2012
File Attachment Storage Options


  • Categories: PeopleCode Design
  • Published: Jan 12, 2012
Word Count in PeopleCode Using Regular Expressions


  • Categories: PeopleCode
  • Published: Dec 13, 2011
The only Peoplecode events you should be using

Key Peoplecode events to use


  • Categories: PeopleCode Design
  • Published: Nov 7, 2011
Using Record Objects to perform inserts and updates

Advantages of using Record Objects to do inserts


  • Categories: PeopleCode Design
  • Published: Oct 31, 2011
Effectively Customizing Online Pages with PeopleCode

A few tips on how effectively customize a page with PeopleCode


  • Categories: PeopleCode
  • Published: Oct 24, 2011
Explaining the PeopleCode @ operator

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


  • Categories: PeopleCode
  • Published: Aug 30, 2011
Using SQLExec and Record Objects


  • Categories: PeopleCode
  • Published: Jul 11, 2011
Running Dynamic SQL with SQLEXEC

How to run Dynamic SQL in PeopleCode


  • Categories: PeopleCode
  • Published: Jun 11, 2011
Stop Using Page Activate PeopleCode

Read about the dangers of using Page Activate PeopleCode


  • Categories: Component Interface PeopleCode Design
  • Published: May 11, 2011
Avoid Global Variables with query string parameters

Global variables are evil!


  • Categories: PeopleCode Design
  • Published: Apr 25, 2011
Effectively Organizing your PeopleCode


  • Categories: PeopleCode Design
  • Published: Apr 3, 2011
DataDumper Documentation

Documentation for our datadumper application package.


  • Categories: PeopleCode Debugging
  • Published: Oct 13, 2010
Doing more with files with Java and PeopleCode


  • Categories: PeopleCode Java
  • Published: Oct 13, 2010
Introduction to the DataDumper Logger


  • Categories: PeopleCode Debugging
  • Published: Oct 13, 2010
Signon PeopleCode and 3rd party connections


  • Categories: PeopleCode Security
  • Published: Oct 13, 2010
Using Record Objects as Parameters and Returns


  • Categories: PeopleCode Design
  • Published: Oct 13, 2010
Accessing Related Fields in PeopleCode

How to programmatically access related fields in PeopleCode.


  • Categories: PeopleCode
  • Published: Oct 12, 2010
Copy Field values between different records

Copy like named fields between two different records.


  • Categories: PeopleCode
  • Published: Oct 12, 2010
Create Excel Files in SQR and PeopleCode

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


  • Categories: SQR PeopleCode
  • Published: Oct 12, 2010

People tools

Find Component Interfaces with NO Menu Attached

SQL audit to find problematic CI's for event mapping


  • Categories: PeopleCode PeopleTools Component Interface
  • Published: Oct 25, 2019
A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table


  • Categories: PeopleTools Security
  • Published: Aug 15, 2016
New 8.55 Feature - Assigning Application Class PeopleCode to Component Events

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


  • Categories: PeopleTools PeopleCode
  • Published: Dec 8, 2015
Resolving "Highlighted fields are required (15,30)" Errors

A quick hack to resolve 15,30 error messages.


  • Categories: PeopleCode PeopleTools Debugging Most Read
  • Published: Jun 9, 2015
PeopleSoft FluidUI Resources

Resources for Learning PeopleSoft Fluid UI.


  • Categories: Design Fluid PeopleTools Most Read
  • Published: Feb 2, 2015
How to Visually Compare Two Pages in Application Designer

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


  • Categories: PeopleTools
  • Published: Feb 26, 2013
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.


  • Categories: PeopleTools
  • Published: Jan 17, 2013
List URLs Accessible to a Permission List

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


  • Categories: PeopleTools Security
  • Published: Oct 10, 2012
Some Strengths And Weaknesses Of PeopleTools


  • Categories: Design PeopleTools
  • Published: Aug 23, 2012
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.


  • Categories: PeopleTools Security Most Read
  • Published: Aug 7, 2012
My Love Hate Relationship with PeopleTools Development


  • Categories: PeopleTools
  • Published: Mar 28, 2012
The PeopleTools Component Object Model

An overview of the PeopleSoft Component object model.


  • Categories: PeopleCode PeopleTools
  • Published: Mar 20, 2012
Find Tables with Specific Field Names


  • Categories: PeopleTools
  • Published: Oct 13, 2010
PeopleTools Tables

List of Key PeopleTools Tables


  • Categories: PeopleTools
  • Published: Oct 13, 2010
Updating PS Query References in the Tools Tables

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


  • Categories: Upgrade Query PeopleTools
  • Published: Oct 13, 2010
Useful PIA Servlet Directives


  • Categories: PeopleTools Portal
  • Published: Oct 13, 2010

Portal

Find and Delete Empty Portal CREF Folder Permissions

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


  • Categories: Security Portal
  • Published: Jan 23, 2013
Deleting Portal User favorites

How to delete user favorites


  • Categories: Portal
  • Published: Jan 4, 2011
Find Missing Portal Pagelets on a user’s home page


  • Categories: Portal
  • Published: Oct 13, 2010
Find Portal CREF in Navigation


  • Categories: Portal
  • Published: Oct 13, 2010
Force a CREF Open in a New Window


  • Categories: Portal
  • Published: Oct 13, 2010
Useful PIA Servlet Directives


  • Categories: PeopleTools Portal
  • Published: Oct 13, 2010
Adding Custom CREF Images to Folders


  • Categories: Portal
  • Published: Oct 12, 2010

Process scheduler

A Look at Max Concurrent Process Definition Property

A look at the "Max Concurrent" process definition property


  • Categories: Process Scheduler
  • Published: Oct 29, 2013
Can I Guarantee a Process Will Run at a Certain Time?


  • Categories: Process Scheduler
  • Published: Sep 12, 2012
How to Cancel a Queued Process in PeopleCode


  • Categories: Process Scheduler PeopleCode
  • Published: May 29, 2012
How to get files to show up in the Process Monitor/Report Repository


  • Categories: SQR Application Engine Process Scheduler Most Read
  • Published: Apr 17, 2011
Unique Constraint Error on PS_MESSAGE_LOG


  • Categories: Process Scheduler
  • Published: Feb 3, 2011

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.


  • Categories: Web Services Python Integration Broker
  • Published: Apr 4, 2013
HTTP Post to PeopleSoft Integration Broker using Python

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


  • Categories: PeopleCode Python Integration Broker Web Services
  • Published: Apr 1, 2013

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.


  • Categories: Web Services REST Query
  • Published: May 3, 2016
Updating PS Query References in the Tools Tables

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


  • Categories: Upgrade Query PeopleTools
  • Published: Oct 13, 2010

R e s t

How set HTTP Status codes in REST

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


  • Categories: PeopleCode REST Integration Broker
  • Published: Nov 8, 2019
How to use the SetRestCache Method

Using REST Cache in PeopleSoft REST Web Services.


  • Categories: PeopleCode REST Integration Broker
  • Published: Sep 6, 2019
JSON Parsing Using PeopleTools JsonParser

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


  • Categories: PeopleCode REST JSON Most Read Integration Broker
  • Published: Jul 17, 2018
PsoftToXML Application Class - Convert PeopleSoft Object to XML

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


  • Categories: PeopleCode Integration Broker REST
  • Published: Oct 27, 2017
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.


  • Categories: PeopleCode Integration Broker REST Most Read
  • Published: Mar 19, 2017
JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11

A newly discovered JSON parsing PeopleCode Class in 8.55.11


  • Categories: PeopleCode REST JSON Most Read
  • Published: Jan 10, 2017
A Complete PeopleSoft REST Web Service Example

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


  • Categories: PeopleCode REST Integration Broker Most Read
  • Published: Aug 2, 2016
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.


  • Categories: Integration Broker JSON REST PeopleCode
  • Published: May 31, 2016
Reporting Web Services: Using the REST Web Services to run a Query

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


  • Categories: Web Services REST Query
  • Published: May 3, 2016
Using Apache HttpClient from PeopleCode

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


  • Categories: PeopleCode REST Java Integration Broker
  • Published: Aug 12, 2014
PeopleTools REST Based Web Services Removing Response

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


  • Categories: Integration Broker REST Web Services
  • Published: Aug 5, 2014
JSON Parsing Limitations in 8.53

A warning in 8.53 JSON parsing limitations.


  • Categories: PeopleCode Integration Broker REST JSON
  • Published: May 27, 2014
PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.


  • Categories: REST Web Services
  • Published: Jun 12, 2013
8.52 and REST support in Integration Broker


  • Categories: Integration Broker REST Web Services
  • Published: Jun 29, 2011
Will PeopleSoft Support REST Web Services?


  • Categories: Integration Broker Web Services REST
  • Published: Feb 3, 2011

Ruby

Running a PeopleSoft Query with Ruby over HTTP


  • Categories: PeopleCode Ruby Web Services
  • Published: Sep 26, 2012

S a m l

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.


  • Categories: Security Design SAML Most Read
  • Published: Jan 26, 2017

S q r

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


  • Categories: SQR Application Engine Process Scheduler Most Read
  • Published: Apr 17, 2011
Create Excel Files in SQR and PeopleCode

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


  • Categories: SQR PeopleCode
  • Published: Oct 12, 2010

Security

SAML Authentication in PeopleSoft

A summary of SAML authentication software for PeopleSoft PeopleSoft.


  • Categories: Security Design SAML Most Read
  • Published: Jan 26, 2017
Using Sign On PeopleCode to redirect Users to Specific pages

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


  • Categories: PeopleCode Security
  • Published: Oct 31, 2016
A Look at the PSPTLOGINAUDIT Security Table

Exploring the PSPTLOGINAUDIT PeopleTools Table


  • Categories: PeopleTools Security
  • Published: Aug 15, 2016
Properly Securing the ANONYMOUS IB Node

Some notes and warnings about the Anonymous node configuration.


  • Categories: Integration Broker Security
  • Published: Oct 8, 2013
Why Exclude PSFT Auth Tokens in Integration Broker?

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


  • Categories: Integration Broker Security
  • Published: Mar 18, 2013
Find and Delete Empty Portal CREF Folder Permissions

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


  • Categories: Security Portal
  • Published: Jan 23, 2013
List URLs Accessible to a Permission List

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


  • Categories: PeopleTools Security
  • Published: Oct 10, 2012
Data Security and Self Service Search Records

An explanation of search records for self-service components.


  • Categories: Security
  • Published: Oct 4, 2012
The PSACCESSLOG PeopleTools Table Explained

A look at the PSACCESSLOG security table.


  • Categories: PeopleTools Security Most Read
  • Published: Aug 7, 2012
Find Missing Component Interfaces for user

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


  • Categories: Security Component Interface
  • Published: Oct 13, 2010
Find Unused Permission Lists


  • Categories: Security
  • Published: Oct 13, 2010
Password Extractor


  • Categories: Security
  • Published: Oct 13, 2010
Reset Password from back end

Reset a user's password via the back end.


  • Categories: Security
  • Published: Oct 13, 2010
Signon PeopleCode and 3rd party connections


  • Categories: PeopleCode Security
  • Published: Oct 13, 2010
Back End Role Insert

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


  • Categories: Security
  • Published: Oct 12, 2010

Upgrade

Updating PS Query References in the Tools Tables

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


  • Categories: Upgrade Query PeopleTools
  • Published: Oct 13, 2010

Web services

Reporting Web Services :REST JSON Responses

Using the REST Reporting Web Services to get a JSON response


  • Categories: Web Services JSON
  • Published: Sep 1, 2016
Reporting Web Services: Using the REST Web Services to run a Query

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


  • Categories: Web Services REST Query
  • Published: May 3, 2016
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.


  • Categories: Integration Broker Web Services
  • Published: Aug 13, 2015
Running a PeopleSoft Query using the Reporting Web Services

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


  • Categories: Web Services
  • Published: Jul 14, 2015
Should You Expose a Component Interface as a Web Service

Should you expose a CI Definition as a web service?


  • Categories: Component Interface Design Web Services
  • Published: Jun 22, 2015
PeopleTools REST Based Web Services Removing Response

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


  • Categories: Integration Broker REST Web Services
  • Published: Aug 5, 2014
Find and Audit Active Service Operations

Some SQL that will show you active service operations


  • Categories: Web Services Integration Broker
  • Published: Sep 5, 2013
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.


  • Categories: PeopleCode Web Services Integration Broker
  • Published: Jul 10, 2013
PeopleSoft RESTListeningConnector Not So "RESTful"

RESTListeningConnector not returning RESTful faults.


  • Categories: REST Web Services
  • Published: Jun 12, 2013
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.


  • Categories: Web Services Python Integration Broker
  • Published: Apr 4, 2013
HTTP Post to PeopleSoft Integration Broker using Python

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


  • Categories: PeopleCode Python Integration Broker Web Services
  • Published: Apr 1, 2013
Understanding the difference between SYNC and FULLSYNC integrations

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


  • Categories: Web Services Integration Broker PeopleCode
  • Published: Nov 26, 2012
Running a PeopleSoft Query with Ruby over HTTP


  • Categories: PeopleCode Ruby Web Services
  • Published: Sep 26, 2012
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?


  • Categories: Design Component Interface Web Services
  • Published: Sep 6, 2012
8.52 and REST support in Integration Broker


  • Categories: Integration Broker REST Web Services
  • Published: Jun 29, 2011
Limitations of PeopleTools Component Interfaces and Web Services

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


  • Categories: Component Interface Design Web Services
  • Published: Jun 18, 2011
HTTP Form Posts and the PeopleTools Integration Broker


  • Categories: Web Services Integration Broker
  • Published: Feb 3, 2011
Will PeopleSoft Support REST Web Services?


  • Categories: Integration Broker Web Services REST
  • Published: Feb 3, 2011

Debugging

PeopleTools Cache Clearing Guide

Some guidelines on different types of PeopleSoft Cache.


  • Categories: debugging PeopleCode
  • Published: May 15, 2012