Facing An Issue In Task 5 "creating Indexes Again" During The Upgrade From 9.1 To 9.2 HRMS (Doc ID 2244252.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

Cannot create unique index,duplicate keys found. Unique index: PS_HR_LOC_TRANS.

Upon checking we have found that there are 3 duplicate values in the newly added field ACTION_DT_SS. We have found that the application engine UPG_HC91 populates PS_HR_LOC_TRANS from PS_HR_MGR_LOC_DAT based on the transaction number.

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