ETL8.x & 9.x: TL Load PSPLDTL1 Abend With ORA-00001: Unique Constraint (SYSADM.PS_PAY_LINE) Violated
(Doc ID 659629.1)
Last updated on JUNE 23, 2024
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 8 to 9.2 [Release 8 to 9]Information in this document applies to any platform.
SPECIFIC TO:
Enterprise Time and Labor release 8.81, 8.9, 9.0 & 9.1
This document was previously published as Customer Connection Solution 201060440
Symptoms
We are running Time and Labor payroll udpate process and it is giving unique constraint error. Ran Pre-sheet / Pre-calc no errors are showing up. It is inserting a row in Pay line with blank Emplid. Even if we run calc for the employees who got taken by payroll, Preliminary calc is also inserting a row to Pay line with a blank emplid. .
Here is the error message from the cobol Log file:
SQLRT(Warning): DB Flag is turned off
%UpdateStats (Update Statistics) ignored
SQL Statement : ANALYZE TABLE PS_PY_PYBL_TM_WRK ESTIMATE STATISTICS
Pay Update (ON-CYCLE) started for Run: TPYW071216
Company...........: TPY
Paygroup..........: YOC
Pay End Date......: 2007-12-16
The Paysheet process is
Checking for update of existing Paysheets.
Application Program Failed
In Pgm Section : INSERT-PAY-LINE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_LINE) violated
PAGE_NUM= 12,LINE_NUM= 0,EMPLID= ,EMPLRCD#=224,NAME=
Application Program Failed
In Pgm Section : PROCESS-JOB(PSPUPSHT)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_LINE) violated
Application Program Failed
In Pgm Section : PSPPYSHT
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_LINE) violated
Load Time & Labor did not finish at 15:26:23.15 !!!!!
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 |
Cause |
Solution |