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 »
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 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 »
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 »
Warning: This is an advanced trick. It is not for the faint hearted and I would definitely not do this in a production environment (i.e. “don’t try this at home…”). The Element Resolution Chain is an invaluable tool for debugging Global Payroll rules. However, it is not possible to generate an Element Resolution Chain when… Read More »
Mass Triggers are new to version 8.9 and are useful in triggering retrospective calculation when setup tables are changed. For example, if an allowance rate is changed retrospectively Mass Triggers can be used create Iterative and Retro triggers for Employees who have the Earning assigned via EDAP. Unfortunately, the process of creating Mass Triggers is… Read More »
It looks like the Software as a Service (SaaS) model is gaining popularity. PeopleSoft’s founder, David Duffield has signed some major customers for his new “Workday” solution. See this “Information Week” article for more info…
Testing if a Date Element is null within a Formula Element is simple, right? It is not as obvious as you may think. If you attempt to do this by comparing the date to a numeric value of zero you receive the following error when validating the formula “Mixed datatypes used as operands. (17000,1768) The… Read More »