GP_PAYAFTER Performance Issues - Especially On Group Lists (Doc ID 2192224.1)

Last updated on OCTOBER 12, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On: 9.2 PeopleSoft Enterprise HCM Global Payroll Core, Performance

For a Group List three processes in the JOB take the following time
GP_PAYBEFORE = 15 seconds
GPPDPRUN = 45 seconds
GP_PAYAFTER = 15+ minutes

The Group List where the most concern lies as this needs to be a quick process, and would be really quick if not for GP_PAYAFTER
Why is it working with a huge data set every time a group list for one employee is done?

STEPS TO REPLICATE:
===============
The issue can be reproduced at will with the following steps:
1. Go to Main Menu > Global Payroll & Absence Mgmt > Absence and Payroll Processing > Calculate Absence and Payroll
2. Run Group List Process
3. GP_PAYAFTER Process consuming more time than required time.

EXPECTED AND ACTUAL BEHAVIOR:
=========================
Actual: GP PAYAFTER Application Engine
Compile Execute Fetch Total
SQL Statement Count Time Count Time Count Time Time
------------------------------ ------- -------- ------- -------- ------- -------- --------
AE Program: GP_RPT_DATA
EXECUTE.Step10.S 78 0.010 78 458.350 0 0.000 458.360 = 7.6mins
EXECUTE.Step10.S 78 0.010 78 458.350 0 0.000 458.360 = 7.6mins

Expected:
GP_PAYAFTER process need to complete below 1min for group list process

Cause

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