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 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.

Symptoms


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

ERROR MESSAGE
-----------------------
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)

 

Cause

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