My Oracle Support Banner

PER_ASSIGNMENT_SUPERVISORS_F and PER_MANAGER_HRCHY_REPORTEES_DN are Not InSync (Doc ID 2515278.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.01.0 version,
Global Human Resources

ACTUAL BEHAVIOR
------------------------
PER_ASSIGNMENT_SUPERVISORS_F and PER_MANAGER_HRCHY_REPORTEES_DN are Not InSync

There is a manager with direct reports in the per_assignment_supervisors_f table, but these same reports don't show up in the per_manager_hrchy_reportees_dn table.


The active records in the assignment supervisors table all have an eff start of 2/18/19 and the last updated date is either 2/18 or 2/19.

In checking the hierarchy table, the most recent last updated date is 2/16/19, but the "Refresh Manager Hierarchy" scheduled process has executed successfully every night since 2/15.

EXPECTED BEHAVIOR
-----------------------
per_assignment_supervisors_f table and per_manager_hrchy_reportees_dn table should have the same data

Changes

 

Cause

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
Symptoms
Changes
Cause
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.