My Oracle Support Banner

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:

  1. Go to Global Payroll Absence and Payroll processing
  2. Open the calculate Absence & Payroll Processing page
  3. Give the appropriate Calendar group, choose Identify and Calculate now
  4. 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.