EPY: Payroll Calculation "PSPPYRUN" Runs to Error With a Unique Contraint
(Doc ID 2617902.1)
Last updated on DECEMBER 09, 2019
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.
User runs the payroll calculation "PSPPYRUN" and is getting an error with a unique constraint.
The user used the new functionality that was delivered in 19-D that allows the user to configure a unique special accumulator. User created a unique special accumulator to include what earnings code was subject to the gross wages.
When creating a new accumulator and/or changing the default, running PSPPYRUN runs to error:
Application Program Failed
In Pgm Section : INSERT-PAY-SPCL
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_SPCL_EARNS) violated
The issue can be reproduced at will with the following steps:
1. Created an unique special accumulator code and associated the earnings code subject to gross wages
2. Changed the "Special Use Accumulator" from "GRS" to the new special accumulator
3. Ran the payroll calculation
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