My Oracle Support Banner

The Direct Reports Tables Build Using Incremental - Current Date Update All Access Methods Errors: 805- ORA-0001: unique constraint (SYSADM.PS_HR_DIRECT_REP_4) violated failed SQL statement: INSERT INTO PS_HR_DIRECT_REP_4 (Doc ID 3027745.1)

Last updated on JUNE 10, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running the Direct Reports Tables Build using Incremental - current date update All Access Methods, it errors with:

Error:
805- ORA-0001: unique constraint (SYSADM.PS_HR_DIRECT_REP_4) violated failed SQL statement: INSERT INTO PS_HR_DIRECT_REP_4


The issue can be reproduced at will with the following steps:
1. As an Administrator, create a Job Action for PAY/OTH and submit for 11/16/2023 for an employee. Navigation: Workforce Administrator tile > Manage Human Resources tile > Manage Job tile.
2. Update the employee's position to change the reports to as of 11/16/2023. Navigation: Workforce Administrator tile > Position Managements > Manage Positions.
3. Run Direct Reports Tables Build using Incremental - current date upd/ All Access Methods. Navigation: Set Up HCM > Common Definitions > Direct Reports for Managers > Direct Reports Table Build > Direct Reports Tables Build.

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.