My Oracle Support Banner

Applied HCM 9.2 PUM 26 For Bug 27130433 -HR Direct Reports Build Incremental Run and It Causes Error-"File: e:\pt85608c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2] SQL0803N" (Doc ID 2464402.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

On : 9.2 version, Manager Dashboard/Talent Summary


HR direct reports build process in incremental mode is causing sql errors-

ERROR
-----------------------
File: e:\pt85608c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - [IBM][CLI Driver][DB2] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key , unique constraint or unique index identified by "PSRDRRRP" constrains Failed SQL stmt: UPDATE PS_DR_RPT_TO_TMP SET HR_DR_LEVEL=1,DRILL_DOWN_FLAG='N',REPORTS_TO = ( SELECT REPORTS_TO FROM PS_POSITION_DATA POS WHERE PS_DR_RPT_TO_TMP.REPORTS_TO = POS.POSITION_NBR AND POS.E FFDT=( SELECT MAX(POS2.EFFDT) FROM PS_POSITION_DATA POS2 WHERE POS.POSITION_NBR= POS2.POSITION_NBR A ND POS2.EFFDT <= CURRENT DATE ) AND POS.EFF_STATUS = 'A' AND POS.REPORTS_TO > ' ') WHERE EXISTS ( SE LECT 'X' FROM PS_POSITION_DATA POS3 WHERE PS_DR_RPT_TO_TMP.REPORTS_TO = POS3.POSITION_NBR AND POS3.E



The issue can be reproduced at will with the following steps:
1. Go to Setup HCM>Common Definitions>Direct reports for Manager> Direct Reports Build>Run the full build.
2. Move a team member from reporting position A to position B.
3. Run the direct reports build process in incremental mode.
4. Process fails with sql error in a particular step.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.