Error Running Direct Reports Build HR_DRPT_BLD: "Cannot Insert Duplicate Key Row in Object 'dbo.PS_HR_DIRECT_REP_6' with Unique Index 'PS_HR_DIRECT_REP_6'"

(Doc ID 1535271.1)

Last updated on APRIL 21, 2016

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


When attempting to run 'Direct Reports Table Build' process the following error occurs.

Cannot insert duplicate key row in object 'dbo.PS_HR_DIRECT_REP_6' with unique index 'PS_HR_DIRECT_REP_6'
ABENDED at Step HR_DRPT_BLD.6ByPosMg.Step06b (SQL) -- RC = 805

The issue can be reproduced at will with the following steps:
1) Navigate to Main Menu -> Set Up HRMS -> Common Definition -> Direct Report For Manager -> Direct Reports Table Build
2) Run the Process with Build Mode as "Build Mode: Full - Complete Rebuild "
3) Process errors out


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms