ETL9.0: Time Admin Fails With A Unique Constraint Error When Two Partial Absences Are Reported (Doc ID 1097963.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

When two partial absences are reported on the same day,Time admin fails with a unique constraint error on TL_TA00700.ABSENCE.LOAD

Scenario:
------------
1: Report 4 hours of vacation take and 4 hours of Sick Take on the same day. 
2: Convert Absences.
3: Run Time Admin. It fails with a unique constraint error.

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