This post explores an Off-Cycle design pattern for scenarios where automatic resolution of selected “downstream” Elements is required. To facilitate automatic processing it is necessary to use the Off-Cycle, Element Selection “ALL” option. However, using the “ALL” setting may result in resolution of unwanted elements. This post describes a solution using Generation Controls to govern… Read More »
Sometimes it is necessary to know the Table and Field name associated with a text box or control on displayed on a PeopleSoft Page. Here’s a few ways to identify the table/field: “Inspect Element” Right click the control for which you want to know the table/field name. Select “Inspect” In the “Elements” tab of the… Read More »
I frequently get requests to report absences. Most Absences are administered using Absence Management. However, extended leave requests/absences are typically administered via Job Data, which is more difficult to extract. This is a relatively simple to extract Global Payroll absence events using the “PS_GP_ABS_EVENT” record. For example the following SQL Script: SELECT c.EMPLID, c.EMPL_RCD, c.NAME,… Read More »
This post covers options for dealing with the following PeopleSoft, Global Payroll process (GPPDPRUN) error: User %1 has started or scheduled a run for all groups using Run Control %2. This error is caused by another process that is running or blocked/locked/stuck. The following scenarios will cause this error: If the payroll process is in… Read More »
Assigning a Deduction Recipient to an Earning or Deduction at Employee level using the “Payee Data > Net Pay / Recipient Elections > Add Deduction Recipients” Component works, but there’s an easier way that improves usability for payroll administrators. Here’s how to configure a solution that allows Deduction Recipients to be selected from Element Assignment, using… Read More »
I have worked at a number of PeopleSoft, Global Payroll sites that customized the Self Service Component/s to prevent Employees and/or Managers from submitting an Ineligible Absence Request. Here’s how to present an Error if an Ineligible Absence Request is submitted via Self Service, without customization: Use the “Maintain Text Catalog” Component to create an… Read More »
The Global Payroll process is a Cobol program. It is not unusual for the payroll process to take a number of hours to complete, depending on factors such as: The number of payees The complexity of the payroll element configuration Infrastructure capability The type of database used The amount of performance tuning employed It is… Read More »
One of the fundamentals of relational database design is the use of unique identifiers. So it’s a reasonable assumption that Payroll Elements can be easily identified by a unique ID of some sort. However nothing is that simple in PeopleSoft Global Payroll. Each Element is assigned a numerical value called a Pin Number (PIN_NUM). Pin… Read More »
As any auditor will tell you: controls, processes and procedures are the secret to mitigating risk and ensuring regulatory compliance. Organisations are like a garden shed, they start off clean and tidy, but have a tendency to accumulate clutter as successive projects, reorganisation and management changes add layer upon layer of controls and processes. Controls,… Read More »
It is sometimes very useful to be able to un-finalize a pay period/Calendar Group while testing and/or debugging. However, there is no online functionality to enable this. The following SQL Script can be used to reset a Calendar Group. After running the script it is important that you run the “Cancel” process using the online… Read More »