ETL9.2: TimeAdmin abended at Step TL_TRPROFILE.DA000.Step090 (SQL)

(Doc ID 2107701.1)

Last updated on APRIL 29, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

TimeAdmin ABENDED at Step TL_TRPROFILE.DA000.Step090 (SQL) when 2 Effseq entered on the Badge.

REPLICATION STEPS
-------------------
1. Enter 2 rows on same effective date with different eff sequence number.
2. Inactivate eff seq number 0 on the badge
3. Eff seq 1 is active on the badge
4. Enter Timesheet
5. Run Time Admin

ERROR
-----------------------
 File: e:\pt85418b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_TL_BADGE_WRK4) violated
Failed SQL stmt: INSERT INTO PS_TL_BADGE_WRK4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, BADGE_TYPE, EFFDT, BADGE_NBR) SELECT A.PROCESS_INSTANCE, B.EMPLID, B.EMPL_RCD, B.BADGE_TYPE, B.EFFDT, CASE WHEN B.EFF_STATUS='A' THEN B.BADGE_NBR ELSE ' ' END FROM PS_TL_PROF_LIST4 A, PS_BADGE_TBL B WHERE A.PROCESS_INSTANCE = :1 AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.BADGE_TYPE = 'CLK' AND (B.EFFDT BETWEEN TO_DATE(:2,'YYYY-MM-DD') AND TO_DATE(:3,'YYYY-MM-DD') OR B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_BADGE_TBL B1 WHERE B1.EMPLID = B.EMPLID AND B1.EMPL_RCD = B.EMPL_RCD AND B1.EFFDT < TO_DATE(:4,'YYYY-MM-DD')))

Process ABENDED at Step TL_TRPROFILE.DA000.Step090 (SQL) -- RC 805 (108,524)


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