ETL9.1 PSARCHIVE Process Fails When Archive Template AUDT_TLR And TL_COMMT Is Used
(Doc ID 1538606.1)
Last updated on AUGUST 21, 2024
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
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)
Steps to Recreate:
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |