My Oracle Support Banner

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

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