ETL9.1: TIME ADMIN FAILS ON TL_TA001300.DA000.STEP010 (Doc ID 1354061.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

After applying the POC for Retro Approval fix, Bug 12402950 in DB2:

Time admin failed on step TL_TA001300.DA000.Step010 with the following error:

File: /view/scraju-pt85011-pbeach-POC-st-ibm22a/vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains
Failed SQL stmt:INSERT INTO PS_TL_TRDT_TAO4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, EARLIEST_CHGDT, END_DT, EXP_DT, DUR, HOLIDAY, TIME_RPTG_TYPE) SELECT B.PROCESS_INSTANCE, B.EMPLID, B.EMPL_RCD, DATE(DAYS(B.END_DT) + ( 1)), B.END_DT, '2222-12-31', DATE(DAYS(B.END_DT) + ( 1)), DATE(DAYS(B.END_DT) + ( 1)), WG.TIME_RPTG_TYPE FROM PS_TL_TA_BATCH4 B, PS_TL_WRKGRP_TBL WG WHERE B.PROCESS_INSTANCE =1225138 AND B.WORKGROUP = WG.WORKGROUP AND B.WRKGRP_EFFDT = WG.EFFDT AND B.END_DT = ( SELECT MAX(B2.END_DT) FROM PS_TL_TA_BATCH4 B2 WHERE B2.PROCESS_INSTANCE =1225138 AND B2.EMPLID = B.EMPLID AND B2.EMPL_RCD = B.EMPL_RCD )

Process 1225138 ABENDED at Step TL_TA001300.DA000.Step010 (SQL) -- RC = 805 (108,524)


This happened when the employee has no changes made to TL_EMPL_DATA and a new effective dated row is inserted.

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