ETL9.2: Time Admin - TEMPLATE250 STEP25 THROWS Unique Constraint Error For Different Time Zone
(Doc ID 2468325.1)
Last updated on NOVEMBER 26, 2021
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