My Oracle Support Banner

Accumulator Rule Template Unique Constraint Error on Step 85 (Doc ID 2428578.1)

Last updated on OCTOBER 02, 2018

Applies to:

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

Symptoms

On : 9.2 version, Time Administration

Time Admin is failing with a Unique Constraint error for Template 520 rules.


ERROR
-----------------------
File: e:\pt85608c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_TL_IPT1_CNT' with unique index 'PS_TL_IPT1_CNT'. The duplicate key value is (293956, 002110, 0, Mar 11 2018 12:00AM, 2).
Failed SQL stmt: INSERT INTO PS_TL_IPT1_CNT (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR, SEQ_NBR, PUNCH_TYPE, PUNCH_BEGIN, PUNCH_BEGIN_R, TIME_IN_MIN1, PUNCH_END, PUNCH_END_R, TIME_IN_MIN2, TIMEZONE, TIMEZONE2, TCD_ID, BADGE_ID, EST_GROSS, LBR_DIST_AMT, DILUTED_GROSS, CURRENCY_CD1, CURRENCY_CD2, RULE_ELEMENT_1, RULE_ELEMENT_2, RULE_ELEMENT_3, RULE_ELEMENT_4, RULE_ELEMENT_5, RULE_FLAG1, RULE_FLAG2, RULE_FLAG3, RULE_FLAG4, RULE_FLAG5, TASKGROUP, DFLT_TASKGROUP, TASK_PROFILE_ID, DFLT_TASK_PROF_ID, DFLT_TASKTMPL_ID, PERIOD_INSTANCE, PERIOD_SEQUENCE, PAYABLE_STATUS, IN_BATCH, OFFDAY_IND, TRC, TL_QUANTITY, CURRENCY_CD, COUNTRY, STATE, LOCALITY, COMP_RATECD, BILLABLE_IND, OVERRIDE_RATE, COMPANY, BUSINESS_UNIT, SETID_LOCATION, LOCATION, SETID_DEPT, DEPTID, SETID_JOBCODE, JOBCODE, POSITION_NBR, PRODUCT, CUSTOMER, ACCT_CD, BUSINESS_UNIT_PC, BUSINESS_UNIT_PF, PROJECT_ID, SETID_ACTIVITY, ACTIVITY_ID, RESOURCE_TYPE, SETID_RESOURCE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, TASK, USER_FIELD_1, USER_FIELD_2, USER_FIELD_3, USER_FIELD_4, USER_FIELD_5, TL_RULE_ID, ORIG_TRC, ORIG_TL_QTY, RT_SOURCE, PAY_SYSTEM_FLG, ORIG_SEQ_NBR, INITIAL_SEQ_NBR) SELECT A.PROCESS_INSTANCE, A.EMPLID, A.EMPL_RCD, A.DUR, A.SEQ_NBR + A.RULE_FLAG4, A.PUNCH_TYPE, A.PUNCH_BEGIN, A.PUNCH_BEGIN_R, A.TIME_IN_MIN1, A.PUNCH_END, A.PUNCH_END_R, A.TIME_IN_MIN2, A.TIMEZONE, A.TIMEZONE2, A.TCD_ID, A.BADGE_ID, A.EST_GROSS, A.LBR_DIST_AMT, A.DILUTED_GROSS, A.CURRENCY_CD1, A.CURRENCY_CD2, A.RULE_ELEMENT_1, A.RULE_ELEMENT_2, A.RULE_ELEMENT_3, A.RULE_ELEMENT_4, A.RULE_ELEMENT_5, A.RULE_FLAG1, A.RULE_FLAG2, A.RULE_FLAG3, A.RULE_FLAG4, A.RULE_FLAG5, A.TASKGROUP, A.DFLT_TASKGROUP, A.TASK_PROFILE_ID, A.DFLT_TASK_PROF_ID, A.DFLT_TASKTMPL_ID, A.PERIOD_INSTANCE, A.PERIOD_SEQUENCE, A.PAYABLE_STATUS, A.IN_BATCH, A.OFFDAY_IND, A.TRC, A.TL_QUANTITY, A.CURRENCY_CD, A.COUNTRY, A.STATE, A.LOCALITY, A.COMP_RATECD, A.BILLABLE_IND, A.OVERRIDE_RATE, A.COMPANY, A.BUSINESS_UNIT, A.SETID_LOCATION, A.LOCATION, A.SETID_DEPT, A.DEPTID, A.SETID_JOBCODE, A.JOBCODE, A.POSITION_NBR, A.PRODUCT, A.CUSTOMER, A.ACCT_CD, A.BUSINESS_UNIT_PC, A.BUSINESS_UNIT_PF, A.PROJECT_ID, A.SETID_ACTIVITY, A.ACTIVITY_ID, A.RESOURCE_TYPE, A.SETID_RESOURCE, A.RESOURCE_CATEGORY, A.RESOURCE_SUB_CAT, A.TASK, A.USER_FIELD_1, A.USER_FIELD_2, A.USER_FIELD_3, A.USER_FIELD_4, A.USER_FIELD_5, A.TL_RULE_ID, A.ORIG_TRC, A.ORIG_TL_QTY, A.RT_SOURCE, A.PAY_SYSTEM_FLG, A.ORIG_SEQ_NBR, A.INITIAL_SEQ_NBR FROM PS_TL_IPT21 A WHERE A.PROCESS_INSTANCE = :1

Process 293956 ABENDED at Step TL_TA_RULES.CSFSKHRS.Step85 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.