Last updated on MAY 03, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms