There are a number of scenarios where it is necessary to identify changes in specific fields in Effective Dated data sets. For example: identifying changes to Full/Part Time Status in Job Data. The following screenshot shows the results of a PS Query that uses the Oracle SQL “LAG” function to identify changes to the FULL_PART_TIME… 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 »
I was recently involved in the design and development of a very useful new piece of functionality for PeopleSoft Global Payroll. The “Self Service Payment Add-On” (SSP) enables employees to submit payment requests directly into PeopleSoft. Requests are then routed for a approval before being posted directly to Positive Input or Element Assignment. SSP is… Read More »
The performance of the Global Payroll configuration Components can be very slow, particularly when working in an environment with a large amount of payroll results. I was recently unable to create a new Accumulator in a client’s environment. Everytime I tried to change the Accumulator to “Use Corrective” checkbox the Component timed out! Here’s some… Read More »
I had the pleasure of attending the PeopleSoft Partner Summit last week. One of the topics covered was “Selective Adoption”. Selective Adoption represents a major shift in the way the PeopleSoft is “kept current”. No more major upgrades! Version 9.2 will be the last “versioned” release of PeopleSoft. The version number will be redundant within… 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 »
The “PS_SCH_CLND_VW” view shows Schedule Details by calendar day, including Shift ID, Workday day and Scheduled Hours. This is very useful for Arrays that require schedule details. It is equally useful for analysis of payroll/absence results (e.g. Forecasting validation) The following SQL shows an example of its use: SELECT DUR, SCHED_HRS FROM PS_SCH_CLND_VW WHERE SCHEDULE_ID… Read More »
One of the best ways to document GP Configuration is to put an explanation into the “Comments” of the Elements. This makes it easier for those who follow in your foot sets to understand the configuration without looking in archives and searching through documents formatted by Project Managers who think paper grows on trees :-P. However, I… Read More »