Direct Reports Table Build HR_RPT_BLD Process Fails On Incremental Runs: "ORA-00001: Unique Constraint (EMDBO.PS_HR_DIR_REP4_TMP) Violated "
(Doc ID 1473279.1)
Last updated on SEPTEMBER 26, 2019
Applies to:PeopleSoft Enterprise HCM 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)
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