ETL9.1: Time Admin Fails With Unique Constraint Error At TL_TRPROFILE.TRPROFIL.PAYGROUP After Bundle 13 (Doc ID 1623203.1)

Last updated on JANUARY 22, 2016

Applies to:

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


Time Admin failed on TL_TRPROFILE.TRPROFIL.PAYGRP2BS with unique constraint error , when EE is enrolled into North American Payroll And Absence Management Paygroup.

HRMS 9.1 Bundle 13


1) Enroll EE into North American Payroll?

2) Enroll EE into Absence Management as well, The AM paygroup on the Job data should be populated.

3) Since both Paygroup NA paygroup & GP_Paygroup is populated & GP_Paygroup is a part of a key time Admin failed after bundle 13.

This is a regression issue.

Unique Constraint Error At TL_TRPROFILE.TRPROFIL.PAYGRP2BS issue continues to occur for customers using TL/AM/NAP.

Time Admin failed with Unique Constraint error for the employees enrolled into North American Payroll as well as Absence Management when GP_PAYGROUP field is populated.
It errors out occasionally and only for a specific data scenario.

Unique Constraint error causes delay in payroll processing.


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