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 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.

Goal

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?

Solution

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
Goal
Solution
References


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