ETL9.2: TEMPLATE520 accumulator Unique Constraint On Split Position Time

(Doc ID 2307186.1)

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.

Symptoms

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.
 

ERROR
-----------------------
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)



STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the user can not process time.

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