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'"
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
Million Knowledge Articles and hundreds of Community platforms