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 MARCH 07, 2017

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

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