Manager in Manager Self Service creating a new ePerformance Document encounters a SQL error in Sybase and SQL Server

(Doc ID 1646104.1)

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.

Symptoms

 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.

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