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 JULY 13, 2016

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

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