My Oracle Support Banner

ETL9.2: Unique Constraint Error On Table PS_ESIGN_AG_DATA During PUM 33 Update (Doc ID 2650781.1)

Last updated on AUGUST 10, 2021

Applies to:

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

Symptoms

The issue was encountered during the PUM 33 apply.

It appears from the scripts a new table was created i.e. PS_ESIGN_AG_DATA.

That table was to be populated from an existing table PS_TL_TS_ESIGN_FL. Due to the unique index on the new table we received a Unique constraint error trying to populate the table.

Further investigation revealed the data in the source table (PS_TL_TS_ESIGN_FL) does have duplicates when using SQL and the fields from the unique index.

There are no steps in the application to reproduce this.  This was encountered during the PUM apply during the Data Conversion process.

REPLICATION STEPS
=================
Select from

PS_ESIGN_AG_DATA

PS_TL_TS_ESIGN_FL

to find duplicates


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.