GP Pay After Process Fails When Recalculate All Box Is Not Checked (Doc ID 2217116.1)

Last updated on DECEMBER 22, 2016

Applies to:

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

Symptoms

STATEMENT:
=========
GP Pay after process fails when Recalculate All box is not checked

STEPS TO REPLICATE:
===============
The issue can be reproduced with the following steps:
1.Navigate to Setup HCM > Product Related > Global Payroll and Absence management > System Settings, enable Pivot Grid checkbox is checked
2.Apply absence in Main Menu > Global Payroll & Absence Management > Payee Data > Maintain Absences > Absence Event
3.Run the payroll, process completes successfully.
4.Run below sql: select * from PS_GP_ABS_ANLYTICS where cal_run_id='KG 2016M01'; Number of rows should be > 0
5.Run the payroll again with only Calculate checkbox checked. The "Pay after" process goes to No Success

ERROR:
=====
File: e:\pt85509c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723
Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GP_ABS_ANLYTICS) violated

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