Interview Schedule - Fatal SQL error occurred. (2,125) HRS_COMMON.COMMON.UTIL.Counter.OnExecute
(Doc ID 2330673.1)
Last updated on NOVEMBER 14, 2019
Applies to:
PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.2 version, Manage Job Openings
Interview Schedule - Fatal SQL Error
When trying to Schedule Interview in delivered PI 24 the following error occurs:
ERROR
-----------------------
A SQL error occurred. Please contact your system log for details.
Fatal SQL error occurred. (2,125) HRS_COMMON.COMMON.UTIL.Counter.OnExecute Name:GetNextNumber PCPC:95 Statement:3
Called from:HRS_APPLICANT_TRACKING.HRS_INTERVIEWS.DATA.DBAccess.OnExecute Name:getIdNumber Statement:14
Called from:HRS_APPLICANT_TRACKING.HRS_INTERVIEWS.BUS.ScheduleInterview.OnExecute Name:assignIdNumber Statement:10
Called from:HRS_APPLICANT_TRACKING.HRS_INTERVIEWS.BUS.ScheduleController.OnExecute Name:doAction Statement:37
Called from:HRS_INT_SCHED.GBL.HRS_RCM_INT.SavePreChange Statement:10
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Recruiting > Search Applicant
2. Search Applicant XXXX
3. Schedule Interview
4. Submit Interview
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Schedule Interview.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |