My Oracle Support Banner

ETL9.1:Error In Running Selection Process For Table AUDIT_SCH_TBL. Returns SQL Error: Unique Constraint (Doc ID 2123662.1)

Last updated on JULY 22, 2020

Applies to:

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

Symptoms

22620253 - ETL9.1:PSARCHIVE ERRORS AT PSARCHIVE.SETBASED.STEP003

ETL9.1:PSARCHIVE Errors AT PSARCHIVE.SETBASED.Step003

1)Navigate to PeopleTools> Data Archive Manager> Archive Data To History

2)Select Following Parameters on the page
  Select Archive template -TL_SCADT,
  Process type - selection ,selective query -AUDT_SCH_TABLE, check the Audit
  row count box

3)Hit run and process fails with above erro

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.