My Oracle Support Banner

Why Are There Duplicates In Hr.per_assignment_status_types table on 12.2.x? (Doc ID 2346969.1)

Last updated on DECEMBER 10, 2022

Applies to:

Oracle Human Resources - Version 12.2 and later
Oracle Payroll - Version 12.2 HRMS RUP8 and later
Oracle Application Object Library - Version 12.2.10 to 12.2.10 [Release 12.2]
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?



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.