EGP/AM: Absence and Global Payroll Process Performance Issue Post MS SQL Server Database upgrade to 2008
(Doc ID 1469028.1)
Last updated on MAY 11, 2023
Applies to:
PeopleSoft Enterprise HCM Global Payroll Core - Version 8.9 to 9.2 [Release 8.9 to 9]Microsoft SQLServer - Version 2008 SP1 to 2008 SP1
Information in this document applies to any platform.
Symptoms
PeopleSoft version 8.9 or higher, Absence & Payroll Processing GPPDPRUN
Process is not completing even after running for longer hours of more than 3 to 4 hours after upgrade of database from MS SQL Server 2005 to 2008 version.
Process used to normally finish in 40 minutes of average time.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Go to Global Payroll Absence and Payroll processing
- Open the calculate Absence & Payroll Processing page
- Give the appropriate Calendar group, choose Identify and Calculate now
- Run the process.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |