Manager in Manager Self Service creating a new ePerformance Document encounters a SQL error in Sybase and SQL Server
Last updated on FEBRUARY 01, 2016
Applies to:PeopleSoft Enterprise HRMS ePerformance - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When a Manager tries to create an ePerformance Document for one of their reportees the system issues a fatal SQL in Sybase
1. Log in as User PS/PS
2. Got to Manager Self Service>Performance Management>Performance Documents>Create Documents
3. Enter the Dates to and From, Select the Document Type and Template
4. Click the Create Buttom
5. Error Message:
A fatal SQL error occured Please consult your system log for details
Fatal SQL error occurred. (2,125) EP_FUNCTIONS.AppraisalCreation.OnExecute
Name:AddJobProfileItems PCPC:39107 Statement:766
Called from:EP_FUNCTIONS.AppraisalCreation.OnExecute Name:CreateAppraisal Statement:104
Called from:EP_CREATEAPPR_MGR.GBL.EP_BTN_LINK_WRK.EP_CREATE_PB.FieldChange @ Statement:27
A SQL error has occurred, review the SQL to determine the cause of the error.
@ Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.
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