My Oracle Support Banner

ETL9.2: Time Admin - TEMPLATE250 STEP25 THROWS Unique Constraint Error For Different Time Zone (Doc ID 2468325.1)

Last updated on AUGUST 29, 2023

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

Time Admin - TEMPLATE250 STEP25 THROWS unique constraint error for different time zone

-- 14:12:44.194 Process 3621697 ABENDED at Step TL_TA_RULES.xxxxxxxxx.Step25 (Action SQL) -- RC = 805

SQL Error: ORA-0001: Unique constraint (EMDBO.PS_TL_IPT26) violated

The issue can be reproduced at will with the following steps:

Generate query offsets in 

PeopleTools-> Utilitiles -> International -> Time Zones

1-Create a rule that uses TEMPLATE250(make sure to compile the rule)

Template 250: Create an exception if a time reporter reports x minutes > 
threshold for specified PUNCH_TYPE.* 

2-Make sure the base time is CST and local timezone is PST (Employee has to be a punch time reporter and Time Zone for the employee is PST)

3-Report time for the employee multiple IN and OUT per day for at least two consecutive days

4-Run Time Admin


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

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