All Knowledge Base Articles
Here is a list of all articles
- Integration Student data into PeopleSoft Campus Solutions - A Practical Guide
A high level overview of integrating with PeopleSoft Campus Solutions for admitting students. Campus Solutions Integration Admissions
- New IB Book Section - HttpTargetConnector
A new book chapter about HttpTargetConnector Integration Broker
- Strategies to Integrate with PeopleSoft
New book chapter on strategies to integration with PeopleSoft. PeopleCode Component Interface Integration Broker
- Best Practices with PeopleSoft Table Updates and Inserts
New book chapter on table update strategies in PeopleSoft. PeopleCode Component Interface Integration Broker
- REST HTTP DELETE Example
A full REST Delete Example PeopleCode REST Integration Broker
- REST HTTP Post Example
A full REST Post Example PeopleCode REST Integration Broker
- How set HTTP Status codes in REST
Example code and documentation on controlling the HTTP status codes in REST web services. PeopleCode REST Integration Broker
- Find Component Interfaces with NO Menu Attached
SQL audit to find problematic CI's for event mapping PeopleCode PeopleTools Component Interface
- How to use the SetRestCache Method
Using REST Cache in PeopleSoft REST Web Services. PeopleCode REST Integration Broker
- JSON Parsing Using PeopleTools JsonParser
An example of using JSON parsing built into PeopleSoft starting in 8.55 with JsonParser. PeopleCode REST JSON Most Read Integration Broker
- PsoftToXML Application Class - Convert PeopleSoft Object to XML
PeopleCode Application Class that converts a Peoplesoft Object to XML for web services. PeopleCode Integration Broker 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. PeopleCode Integration Broker REST Most Read
- SAML Authentication in PeopleSoft
A summary of SAML authentication software for PeopleSoft PeopleSoft. Security Design SAML Most Read
- JSON Parsing using PeopleCode Classes Starting in PeopleTools 8.55.11
A newly discovered JSON parsing PeopleCode Class in 8.55.11 PeopleCode REST JSON Most Read
- PeopleCode Function To Validate Email
PeopleCode email REGEX Function PeopleCode
- Using Sign On PeopleCode to redirect Users to Specific pages
Some examples of how to redirect user to specific pages at login. PeopleCode Security
- Reporting Web Services :REST JSON Responses
Using the REST Reporting Web Services to get a JSON response Web Services JSON
- A Look at the PSPTLOGINAUDIT Security Table
Exploring the PSPTLOGINAUDIT PeopleTools Table PeopleTools Security
- A Complete PeopleSoft REST Web Service Example
A complete example of providing a REST web service in PeopleSoft. PeopleCode REST Integration Broker Most Read
- Renaming files using PeopleCode
A simple code example to rename or move a file in PeopleCode. PeopleCode Java
- 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. Integration Broker JSON REST PeopleCode
- Executing System Commands from PeopleCode and Getting STDOUT
Some PeopleCode examples to run operations system commands from PeopleCode and get the output. PeopleCode
- Reporting Web Services: Using the REST Web Services to run a Query
Using the REST Reporting Web Services in PeopleSoft to run a query. Web Services REST Query
- New 8.55 Feature - Assigning Application Class PeopleCode to Component Events
A new 8.55 feature that may reduce the amount of custom PeopleCode. PeopleTools PeopleCode
- 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. Integration Broker Web Services
- Using Chunking Rules with OnRouteSend PeopleCode
A look at using OnRouteSend Combined with PeopleCode\ Integration Broker
- Running a PeopleSoft Query using the Reporting Web Services
Using the Reporting Web Services in PeopleSoft to run a query. Web Services
- What are FULLSYNC Chunking Rules?
A look at FULLSYNC chunking rules Integration Broker
- Should You Expose a Component Interface as a Web Service
Should you expose a CI Definition as a web service? Component Interface Design Web Services
- An Example of using the CI Find Method
An example looking at CS Course Catalog Component Interface to use the Component Interface Find Method. Component Interface PeopleCode
- Resolving "Highlighted fields are required (15,30)" Errors
A quick hack to resolve 15,30 error messages. PeopleCode PeopleTools Debugging Most Read
- ScrollSort and Component Interface Lost Pointer
An issue with ScrollSort and Component Interface. Component Interface
- Page and Component Interface: A Warning
A warning about %page and Component Interface Component Interface PeopleCode
- PeopleSoft FluidUI Resources
Resources for Learning PeopleSoft Fluid UI. Design Fluid PeopleTools Most Read
- Using Apache HttpClient from PeopleCode
Some code examples of using Apache httpClient from PeopleCode (bypassing Integration Broker) PeopleCode REST Java 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. Integration Broker REST Web Services
- Delay Processing in Inbound Asynchronous Subscription Handlers
A look at how the PeopleTools integration broker delay processing works. Integration Broker
- JSON Parsing Limitations in 8.53
A warning in 8.53 JSON parsing limitations. PeopleCode Integration Broker REST JSON
- Using SwitchUser in Integration Broker Subscriptions
An example of using switchuser to change user context in subscription PeopleCode. Integration Broker
- Parsing Cookies in Integration Broker Request Handler
An example method of parsing cookies in an integration broker handler. Integration Broker
- Deleting Service Operation Log Tables During Development
An alternative to appmsgpurgeall.dms for one service operation. Integration Broker
- A Look at Max Concurrent Process Definition Property
A look at the "Max Concurrent" process definition property Process Scheduler
- Properly Securing the ANONYMOUS IB Node
Some notes and warnings about the Anonymous node configuration. Integration Broker Security
- Find and Audit Active Service Operations
Some SQL that will show you active service operations Web Services 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. PeopleCode Web Services Integration Broker
- PeopleSoft RESTListeningConnector Not So "RESTful"
RESTListeningConnector not returning RESTful faults. REST Web Services
- Criteria to Use Component Interface
What Criteria should lead to the use of CI? Component Interface PeopleCode
- Understanding Local Integration Broker Routings
A look into the who, what, when, where, why of local integration broker service operations. Design 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. Web Services Python Integration Broker
- HTTP Post to PeopleSoft Integration Broker using Python
An example python script that posts to the PeopleSoft Integration broker HTTP connector. PeopleCode Python Integration Broker Web Services
- Why Exclude PSFT Auth Tokens in Integration Broker?
Some thoughts on excluding PSFT Auth token to simplify security for Web Services Integration Broker Security
- How to Visually Compare Two Pages in Application Designer
We show how to visually compare a page between two databases or a file. PeopleTools
- Find and Delete Empty Portal CREF Folder Permissions
Some SQL to find and delete Portal CREF permissions where there are no children. Security Portal
- 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. PeopleTools
- Application Classes and Global Variables are like Oil and Water
An example of the perils of using Global Variables in your Application Classes PeopleCode
- Understanding the difference between SYNC and FULLSYNC integrations
An Explanation of the differences and limitations of FULLSYNC and SYNC PeopleSoft Service Operations. Web Services Integration Broker PeopleCode
- Linking Between PeopleSoft Components in HTML
How you can link between two PeopleSoft components using an "a" HTML tag. PeopleCode
- How to Bypass a PeopleSoft search record
Ways to bypass a PeopleSoft search record Design Online Development Most Read
- List URLs Accessible to a Permission List
Sample SQL to generate a list of component based URL accessible by a permission list. PeopleTools Security
- Data Security and Self Service Search Records
An explanation of search records for self-service components. Security
- Running a PeopleSoft Query with Ruby over HTTP
Some ruby code showing how to extract data from PeopleSoft over HTTP. PeopleCode Ruby Web Services
- 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? Process Scheduler
- 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? Design Component Interface Web Services
- Some Options for Sending Emails in PeopleTools
Some options and thoughts on sending email from PeopleSoft/PeopleTools PeopleCode Design
- Some Strengths And Weaknesses Of PeopleTools
Some thoughts on what PeopleTools is good and bad at. Design PeopleTools
- The PSACCESSLOG PeopleTools Table Explained
A look at the PSACCESSLOG security table. PeopleTools Security Most Read
- Migrate PeopleSoft Enterprise Portal Managed Content Data with DMS
A DMS script to migrate managed content data between databases. Portal
- The Pros and Cons of PeopleSoft Bolt-ons versus Customization's
Some pros and cons for bolt-ons versus customization Design
- Using ExcelTOCI to Delete a User Profile
A walk-thru for using excel to CI to call the DELETE_USER_PROFILE component interface. Component Interface
- 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. Design EFFDT
- PeopleSoft Daemon Application Engine Example
An example usage of a daemon Application Engine Application Engine
- How to Cancel a Queued Process in PeopleCode
Here is a sample PeopleCode snippet to cancel a process request. Process Scheduler PeopleCode
- PeopleTools Cache Clearing Guide
Some guidelines on different types of PeopleSoft Cache. debugging PeopleCode
- Design Principles
Some thoughts on effective design Design
- PeopleCode Events that do not fire in Component Interface
A summary of the PeopleCode events that do not fire in Component Interface. Component Interface PeopleCode Design
- My Love Hate Relationship with PeopleTools Development
Some things I love and hate about PeopleTools development PeopleTools
- The PeopleTools Component Object Model
An overview of the PeopleSoft Component object model. PeopleCode PeopleTools
- Understanding PeopleCode Current Context functions
Understanding the PeopleCode current context functions: getrow(), getrowset(), and getfield() PeopleCode
- SFTP Example using PeopleCode
A PeopleCode example of using sftp to transfer a file. PeopleCode Application Engine
- Removing MS Word Smart quotes in PeopleSoft Pages
How to remove MS Word smart quotes that get turned into upside down question marks. PeopleCode Design
- 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. 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. Debugging PeopleCode Design
- Getting Integration Broker Code to Run as a Different User
We will explore how to run integration broker code as another user. Integration Broker
- Creating an Effective Audit Subrecord
An overview of an audit subrecord you should have on all your custom records. Design PeopleCode
- File Attachment Storage Options
Pros and cons of different storage options. PeopleCode Design
- Word Count in PeopleCode Using Regular Expressions
PeopleCode example to get word count using java regular expressions PeopleCode
- Signs you should be using a Component Interface
Some indications of when you should be using CI. Component Interface Design
- A Better Run Control Page Standard
A new run control record proposal Online Development Design
- The only Peoplecode events you should be using
Key Peoplecode events to use PeopleCode Design
- Using Record Objects to perform inserts and updates
Advantages of using Record Objects to do inserts PeopleCode Design
- Effectively Customizing Online Pages with PeopleCode
A few tips on how effectively customize a page with PeopleCode PeopleCode
- 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. Component Interface
- Explaining the PeopleCode @ operator
Have you ever seen the PeopleCode @ operator and wondered when and why you would use it? 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. PeopleCode
- 8.52 and REST support in Integration Broker
Some updated information on REST API support Integration Broker REST Web Services
- Limitations of PeopleTools Component Interfaces and Web Services
We documented some limitations with Component Interface that are useful to publish. Component Interface Design Web Services
- Running Dynamic SQL with SQLEXEC
How to run Dynamic SQL in PeopleCode PeopleCode
- Understanding Integration Broker Queue Partitioning
This article will explain Message Queue partitioning in PeopleTools Integration Broker. Integration Broker
- Stop Using Page Activate PeopleCode
Read about the dangers of using Page Activate PeopleCode Component Interface PeopleCode Design
- Avoid Global Variables with query string parameters
Global variables are evil! PeopleCode Design
- 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). SQR Application Engine Process Scheduler Most Read
- Effectively Organizing your PeopleCode
Some tips on how to organize your PeopleCode better. PeopleCode Design
- Problems with Component Interface and COBOL remotecalls
Having problems with remote call and component interface? 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. Component Interface
- 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. Web Services Integration Broker
- Unique Constraint Error on PS_MESSAGE_LOG
ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated Process Scheduler
- Will PeopleSoft Support REST Web Services?
For PeopleTools 8.51 and lower the answer is **No**. Integration Broker Web Services REST
- Deleting Portal User favorites
How to delete user favorites Portal
- 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. Component Interface
- DataDumper Documentation
Documentation for our datadumper application package. PeopleCode Debugging
- Deleting Rows in ExcelToCI
A quick code fix to allow for row deletions in excelToCI. Component Interface
- Doing more with files with Java and PeopleCode
Some code examples of using java within PeopleCode. PeopleCode Java
- Find Missing Component Interfaces for user
This sql should find component interfaces that a specific user does not have. Security Component Interface
- Find Missing Portal Pagelets on a user’s home page
Here is query that will find those missing missing pagelets. 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. Portal
- Find Tables with Specific Field Names
Have you ever wanted to find a table that had specific combination of fields on it? PeopleTools
- Find Unused Permission Lists
This query should find unused permission lists that could be deleted. Security
- 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. Portal
- Introduction to the DataDumper Logger
Introduction to the CHG_DataDumper Application Class used for logging. PeopleCode Debugging
- Making Pretty Page Text with HTML Areas
Do you want to give your users readable formatted messages and instructions? Design Online Development
- Password Extractor
This script will extract password as an update statement to be moved to another database. Security
- PeopleTools Tables
List of Key PeopleTools Tables PeopleTools
- Reset Password from back end
Reset a user's password via the back end. Security
- Signon PeopleCode and 3rd party connections
A note about 3rd party CI connections and signon PeopleCode. PeopleCode Security
- Some Thoughts on Application Engine Temporary Tables
Pros and cons of using temp tables. Application Engine Design
- Understanding the Integration Broker Monitor
A look at how to use the Integration Broker Monitor page. Integration Broker
- Updating PS Query References in the Tools Tables
How to update query record references from the back-end. Upgrade Query PeopleTools
- Useful PIA Servlet Directives
PeopleTools Portal
- Using Record Objects as Parameters and Returns
This article contains some discussion around using record objects and function parameters. PeopleCode Design
- When you have a user that is using 'My Favorites; they often forget how to get to the real page.
Portal
- 10 Step Component Interface Development Process
10 steps to follow when coding using a CI. Component Interface
- Accessing Related Fields in PeopleCode
How to programmatically access related fields in PeopleCode. PeopleCode
- Adding Custom CREF Images to Folders
How to add custom images to a portal CREF Portal
- Back End Role Insert
A simple script to insert roles into a user via SQL. Security
- Copy Field values between different records
Copy like named fields between two different records. PeopleCode
- Create Excel Files in SQR and PeopleCode
An open source project that creates Office XML files from SQR. SQR PeopleCode
- 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. Integration Broker