My Oracle Support Banner

EPY: Unable To Process Payroll for a Prior Pay Period (Doc ID 2712792.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Unable to process payroll for the prior pay period.

We were trying to process the payroll either off-cycle/on-cycle for the pay begin and end date of  July 3, 2020 with a check date in July.

When running the confirmation process, it throws the following error message:


Off-Cycle Confirmation started for Run: 09/12/2020
 at 06:02:56.29.
Checking PaySheet Update ended at 06:02:56.36.
Confirmation started for Company: XXX
  Pay Group: XXX
  Pay End Date: 2020-09-12
  PAGE_NUM: 100
 at 06:02:56.39.
  1 check(s) calculated.
Start employee processing at 06:02:56.55.
 
Application Program Failed
 In Pgm Section : INSERT-BALANCE
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
 
PAGE_NUM= 100,LINE_NUM= 1,SEPCHK= 0,EMPLID=10000XXXXX ,NAME=
 
Application Program Failed
 In Pgm Section : PROCESS-CHECK(PSPCBUPD)
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
 
 
Application Program Failed
 In Pgm Section : MAIN(PSPPYUPD)
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated


The issue can be reproduced with the following steps:
1. Confirm a payroll that has the last period as August
2. Process an off-cycle for the following period with a check date of July
3. Verify the payroll error message and the payroll confirm log file.


Changes

 

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
Changes
Cause
Solution


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