Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

Getting Unique Constraint Error in TL_OUTTCD

edited Mar 30, 2022 1:44PM in Payroll for NA / Time and Labor - PSFT (MOSC) 1 commentAnswered

Good afternoon,

I'm getting a unique constraint error in TL_OUTTCD at step TL_OUTTCD.TEMPLANG.Step02 (Action SQL) when a record is inserted into PS_WRK_TKTMP_TAO6. This is a vanilla application. Here's the error from the log file:

File: e:\pt857p20b_2101061813-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_WRK_TKTMP_TAO6) violated 
Failed SQL stmt: INSERT INTO PS_WRK_TKTMP_TAO6 (PROCESS_INSTANCE, MSGNODENAME, TCD_ID, TASK_PRFL_TMPLT_ID, IN_PROCESS_FLG, AUDIT_ACTN, TCD_NETWORK_ID, TCD_NODE_ID, DESCR) SELECT  DISTINCT 8176727, B.MSGNODENAME, A.TCD_ID, D.TASK_PRFL_TMPLT_ID, 'N', 'A', B.TCD_NETWORK_ID, B.TCD_NODE_ID, D.DESCR FROM PS_TL_TSKPRF E , PS_TL_TSKPRF_TMPLT D , PS_TL_TASKGRP_TBL C , PS_TL_TCD_TASKGRP A , PS_TL_TCD_TBL B WHERE A.TCD_ID = B.TCD_ID AND A.TCD_ID = :1 AND A.TASKGROUP = C.TASKGROUP AND C.TASK_PRFL_TMPLT_ID = :2 AND C.TASK_PRFL_TMPLT_ID = D.TASK_PRFL_TMPLT_ID AND C.TASK_PRFL_TMPLT_ID = E.TASK_PRFL_TMPLT_ID AND C.TASK_PROFILE_ID = E.TASK_PROFILE_ID AND D.TASK_PRFL_TMPLT_ID NOT IN( SELECT F.TASK_PRFL_TMPLT_ID FROM PS_WRK_TKTMP_TAO6 F WHERE F.TCD_ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center