EGP/AM: Absence and Global Payroll Process Performance Issue Post MS SQL Server Database upgrade to 2008
Last updated on SEPTEMBER 13, 2017
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms