Error (2,280) on Direct Reports Page when Expanding Employee Node to View Indirect Reports

(Doc ID 2343481.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

When using Position Management and trying to select an employee to Approve an Absence Request the following error is received:

A fatal PeopleCode error occurred. Please consult your system log for details.

SQL Error in Exec. (2,280) HR_DIRECT_REPORTS.DirectReports.OnExecute Name:HasDirectReports PCPC:132071 Statement:1844
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute Name:UpdateIndirectIndicator Statement:1221
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute Name:iDrillDown Statement:585
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute Name:iDrillDown Statement:215
Called from:HR_DIRECT_REPORTS.DirectReportsAPI.OnExecute Name:GetAllDirectAndIndirectReports Statement: 40
Called from:HR_DIRECT_REPORTS.Dire

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.


The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Manager Self-Service> Time Management> Approve Time and Exceptions> Absence Requests
2. On the Direct Reports page, click the '+' button to see Indirect Reports
3. Note the above error messages are displayed

Changes

 

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