ETL9.2: TEMPLATE520 accumulator Unique Constraint On Split Position Time
Last updated on SEPTEMBER 13, 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.
On : 9.2 version, Time Administration
TEMPLATE520 Unique Constraint on Split Position time
Time Admin crashes with an error on a TEMPLATE520 rule when an employee splits their time between their two positions.
The situation that causes a crash is when an employee uses Family Sick TRC split 4/4 between their two half positions on the same day.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_WRK014) violated
Failed SQL stmt: INSERT INTO PS_TL_WRK014 (PROCESS_INSTANCE, EMPLID, DUR, SEQ_NBR) SELECT 259170, A.EMPLID, A.DUR, 1 From PS_TL_IPT24 A WHERE A.PROCESS_INSTANCE = :1 AND NOT EXISTS (SELECT 'X' FROM PS_TL_IPT1_CNT B WHERE A.EMPLID = B.EMPLID AND A.DUR = B.DUR AND B.PROCESS_INSTANCE = :2)
Process 259170 ABENDED at Step TL_TA_RULES.FAMSICKA.Step80 (SQL) -- RC = 805 (108,524)
The issue can be reproduced at will with the following steps:
The employee has two records: rcd 0 and 1. two half time positions in the same workgroup.
set up a template520 rule to accumulate a TRC, and then go to a timesheet for an employee with 2 jobs and put 4 hours on one job and 4 hours on an other on the same day, when time admin tries to process that time it will get a unique constraint
The issue has the following business impact:
Due to this issue, the user can not process time.
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