EPY: PAY124CN Fails With Unique Constraint Error (Doc ID 2129482.1)

Last updated on APRIL 21, 2016

Applies to:

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

Symptoms

On : 9.1 version, Taxes

Create ROE process pay124cn fails with uniques constraint error

Create ROE process pay124cn fails with uniques constraint error, when an employee has 2 Job data rows within the specified date range.
Both the Job data rows have same Last day worked, so the process is trying to insert same set of keys in PS_ROE record.

(SQR 5528) ORACLE OCIStmt Execute error 1 in cursor 20:
ORA-0001: Unique Constraint (SYSADM.PS_ROE) 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