Why Are There Duplicates In Hr.per_assignment_status_types table on 12.2.x?
Last updated on JANUARY 09, 2018
Applies to:Oracle Human Resources - Version 12.2 and later
Oracle Payroll - Version 12.2 HRMS RUP8 and later
Information in this document applies to any platform.
After 12.2 Patch application we see Duplicates in the tables. One row as SET1 and the duplicate row SET2 in the zd_edition_name column
For example: hr.per_assignment_status_types table in these 2 new columns
ZD_EDITION_NAME "SET1" and ZD_EDITION_NAME "SET2" and ZD_SYNC all rows are marked "SYNCD"
When we do a describe we see both rows. We have custom reports that are stopping because of this.
How do we get rid of these duplicates?
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