My Oracle Support Banner

ETL92: DAEMON Loader Process Failing On "UNIQUE CONSTRAINT" (Doc ID 2537272.1)

Last updated on MAY 01, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

I t appears TL_ST_LOADER failing with unique constraint error as indicated below:

Error:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_APP_HDR) violated
Failed SQL stmt: INSERT INTO PS_TL_APP_HDR (TRANSACTIONID, EOAWDEFN_ID, EMPLID, EMPL_RCD, PUNCH_TYPE) SELECT DISTINCT A.TRANSACTIONID, A.TL_APPR_RPT_DEFN, A.EMPLID, A.EMPL_RCD, A.PUNCH_TYPE FROM PS_TL_APP_TMP6 A WHERE PROCESS_INSTANCE = 4524575

Process 4524575 ABENDED at Step TL_ST_LIB.MA000.Step060 (SQL) -- RC = 805
Process ABENDED at Step TL_ST_LIB.MA000.Step060 (SQL) – RC 805

Steps to Recreate:
1. Run tl_st_loader process


Changes

 

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
Changes
Cause
Solution
References


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