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

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.

Symptoms

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

Changes

 Applied maintenance patches through PUM 19.

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