My Oracle Support Banner

Applying HR 9.2 PUM 017-019; Duplicate Key Found Creating UNIQUE CLUSTERED INDEX PS_AUDIT_SCH_TBL (Doc ID 2241363.1)

Last updated on APRIL 02, 2019

Applies to:

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

Symptoms

When applying HR 9.2 PUM Image 019, getting duplicate key found creating UNIQUE CLUSTERED INDEX PS_AUDIT_SCH_TBL.
CREATE UNIQUE CLUSTERED INDEX PS_AUDIT_SCH_TBL ON PS_AUDIT_SCH_TBL
 (AUDIT_OPRID,
  AUDIT_STAMP,
  AUDIT_ACTN,
  EMPLID,
  EMPL_RCD,
  DUR,
  PUNCH_DTTM)


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.