ETL9.1 PSARCHIVE Process Fails When Archive Template AUDT_TLR And TL_COMMT Is Used (Doc ID 1538606.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.

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)

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:
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

ENVIRONMENT INFORMATION
=======================
PeopleSoft HCM 9.1 bundle 11

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