Facing An Issue In Task 5 "creating Indexes Again" During The Upgrade From 9.1 To 9.2 HRMS
Last updated on MARCH 05, 2018
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms