My Oracle Support Banner

Fatal PeopleCode SQL Error (2,280) when Requesting an Ad Hoc Salary Change (Doc ID 2242613.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 9.2 and later
Information in this document applies to any platform.


Getting a fatal PeopleCode SQL error when trying to Request Ad Hoc Salary Change:

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

SQL error in Exec. (2,280) HR_DIRECT_REPORTS.DirectReportsAPI.OnExecute Name:GetAllDirectReportsFromFlatTbls PCPC:17007 Statement:218
Called from:HR_DIRECT_REPORTS.DirectReportsAPI.OnExecute Name:GetAllDirectAndIndirectReports Statement:29
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute Name:GetAllDirectAndIndirectReports Statement:2062
Called from:HR_DIRECT_REPORTS.EmployeeSelectionAPI.OnExecute Name:LoadData Statement:65
Called from:HR_DIRECT_REPORTS.EmployeeSelection.OnExecute Name:LoadPageData Statement:103

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. Navigate to Main Menu > Manager Self Service > Compensation and Stock > Request Ad Hoc Salary Change
2. Note the above error is received


 Applied maintenance patches through PUM 19.


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

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