All Knowledge Base Articles

Here is a list of all articles

• Compare Permissions on Two Roles

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

• (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 Application Engine Design PeopleCode

• Integrating 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