Processes stuck at Queued

There are a number of reasons why a process might be stuck at queued. The most obvious is that the process scheduler is down (check the Servers tab in the process monitor). Beyond this, there are some useful troubleshooting that apply: Check the following tables: PSPRCSRQST PSPRCSQUE PSPRCSPARMS The...

Read More»

How to create a PeopleSoft Popup menu?

First up a popup menu needs to be created. Next comes providing the page control for user which when clicked upon will pop up this menu.Part A - Creation of a Popup menu:1) To create a new Popup menu in PeopleSoft, create a New menu definition. When the Application designer prompts to chose...

Read More»

How to change default SETIDs for a Business Unit?

First up, how to associate a SETID with a Business Unit in PeopleSoft?It's a one time activity done while creating a Business Unit. However SETIDs cannot be changed as easily as one would think after the creation of a Business UnitBusiness Units(BU) are created and maintained in the navigation: Set...

Read More»

How to find which users have permission and do not have access to a PeopleSoft Component Interface?

Many a times we create number of batch processes based on Component Interfaces. No matter how much carefully we try to take care of the security settings we often overlook on CI permissions. Here are couple of SQL queries that could assist finding the Users and Permission List having permission and not...

Read More»

Changing Size of a Crystal Report to custom sizes beyond the size allowed in the local configured printer

Changing Size of a Crystal Report to custom sizes beyond the size allowed in the local configured printer Often in Crystal Reports, the width of the page needs to be set to varying and custom sizes. By default, the sizes available for any Crystal Report is dependent upon the size of papers...

Read More»