ETL9.1 PSARCHIVE Process Fails When Archive Template AUDT_TLR is Used, AUDIT_TLRPTTIME Has No Unique Index (142,173) (Doc ID 1565516.1)

Last updated on FEBRUARY 09, 2017

Applies to:

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

Symptoms

ISSUE STATEMENT
=================
PSARCHIVE process fails when Archive Template AUDT_TLR & TL_COMMT is used with error: Cannot archive since base record AUDIT_TLRPTTIME of base object AUDIT_TLRPTTIME has no unique index (142,173)

ENVIRONMENT
============
PeopleSoft HCM 9.1
PeopleTools 8.53

REPLICATION STEPS
=================
1) Navigate to Peopletools> Data Archive Manager> Archive Data to History
2) Select Archive Template AUDT_TLR
3) Selective Query : AUDIT_TLRPTDTIME
4) Enter values under Define Binds
5) Run Process PSARCHIVE
6) Process fails with following error:

ERROR
======
Cannot archive since base record AUDIT_TLRPTTIME of base object AUDIT_TLRPTTIME has no unique index (142,173)
Process 1360 ABENDED at Step PSARCHIVE.ARCHSQL.Step01 (PeopleCode) -- RC = 20 (108,524)

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