ETL9.2: Mass Time Process Abends at Step TL_ST_LIB.MA000.STEP060

(Doc ID 2411038.1)

Last updated on JUNE 13, 2018

Applies to:

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

Symptoms

One instance of Mass Time process (TL_MASS_TIME) abends with unique constraint error when the employee submits multiple mass time requests

ERROR
-----------------------

File: e:\pt85514b-retail\peopletools\src\psappeng\aedebug.hSQL error.
Stmt #: 1723 Error Position: 0 Return: 805 - ORA- 00001: unique constraint (HRSYSADM.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_TMP11 A WHERE PROCESS_INSTANCE = 1173057

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

STEPS
-----------------------
1. Navigate to Self Service > Time Reporting > Report Time > Mass Time
2. Submit multiple mass time requests

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