ETL9.2: Time Admin ABENDED AT STEP TL_TA000900.DG000.STEP020 (SQL) After PUM24.

(Doc ID 2321388.1)

Last updated on OCTOBER 25, 2017

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

On : 9.2 version, Time Administration

When attempting to process TimeAdmin,
the following error occurs.

ERROR
-----------------------
SQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_TL_ELP_TMP4) violated Failed SQL stmt: INSERT INTO PS_TL_ELP_TMP4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR, SEQ_NBR, TRC, TL_QUANTITY, COMP_TIME_PLAN, EFFDT_USED, CALC_EXP_DT, ACT_EXP_DT, CT_BALANCE) SELECT DISTINCT A.PRO CESS_INSTANCE, A.EMPLID, A.EMPL_RCD, A.DUR, A.SEQ_NBR, A.TRC, A.TL_QUANTITY, CASE WHEN (B.EFF_STATUS = 'A' AND C.EFF_STATUS = 'A') THEN B.COMP_TIME_PLAN ELSE ' ' END , TO_DATE('1900-01-01','YYYY-MM-DD ') , TO_DATE('1900-01-01','YYYY-MM-DD') , TO_DATE('1900-01-01','YYYY-MM-DD') , 0 FROM PS_TL_ELP_WRB4 A , PS_TL_EMPL_COMP B , PS_TL_COMP_TRC C WHERE A.PROCESS_INSTANCE=:1 AND A.EMPLID = B.EMPLID AND A. EMPL_RCD = B.EMPL_RCD AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_TL_EMPL_COMP B1 WHERE B1.EMPLID =

Process 198343 ABENDED at Step TL_TA000900.DG000.Step020 (SQL) -- RC = 805


STEPS
-----------------------

1. Employee’s Compensatory Time Off Plan enrollment - has change comp time plans on 10/1/17

1/1/16 in 'PLAN1' plan - Active
1/1/17 in 'PLAN1' plan - Active
10/1/17 in 'PLAN1' plan - Inactive
10/1/17 in 'PLAN2' plan - Active

2. 2 comp plans share the same TRCs.

3. Report regular and comp time from 10/3 thru 10/14/17

4. Timeadmin Abends with error:

Process 315778 ABENDED at Step TL_TA000900.DG000.Step020 (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