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

Last updated on OCTOBER 27, 2016

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

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