Direct Reports Table Build HR_RPT_BLD Process Fails On Incremental Runs: "ORA-00001: Unique Constraint (EMDBO.PS_HR_DIR_REP4_TMP) Violated "
Last updated on OCTOBER 03, 2017
Applies to:PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
Direct Reports Tables Build fails when Build Mode is Incremental
The Direct Reports Build process has been introduced in HRMS 9.1 Bundle #8. This process loads the new direct reports performance tables. The new direct reports tables have been designed to improve the performance of all direct reports processes. If the tables are not loaded the current direct reports pages will functions as they have in the past, but running this process will improve the performance of the existing pages. Running this process is required in order to implement the Organizational Chart Viewer. Again to use the Org Chart Viewer, People Tools is 8.52 and above is required.
STEPS TO REPLICATE
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 "Incremental - Current Date Upd"
3) Process errors out
ORA-00001: unique constraint (EMDBO.PS_HR_DIR_REP4_TMP) violated
Process 2334 ABENDED at Step HR_DRPT_BLD.4ByPosn.Step04 (SQL) -- RC = 805 (108,524)
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