EPY: PAY124CN Fails With Unique Constraint Error
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms