Error (2,280) on Direct Reports Page when Expanding Employee Node to View Indirect Reports
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.
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
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
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