My Oracle Support Banner

EPY: Retro Pay Calculation is Causing a Unique Constraint (Doc ID 2710574.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

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

Symptoms

First time generating retro transactions in 9.2.  When running Retro pay calculation, we are getting the following error:

Application Program Failed
 In Pgm Section : INSERT-PRIOR-RETRO(INSERT)
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PRIOR_RETRO) violated
 
 
Application Program Failed
 In Pgm Section : LOAD-ERN-ARRAY(PSPRPERY)
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PRIOR_RETRO) violated
 
 
Application Program Failed
 In Pgm Section : PROCESS-RETRO-PAY(PSPRPCAL)
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PRIOR_RETRO) violated


The issue can be reproduced with the following steps:
1. Old open retro request sequence in a prior release.

2. Generate new retro sequence in 9.2

3. Run retro pay calculation



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.