Interview Schedule - Fatal SQL error occurred. (2,125) HRS_COMMON.COMMON.UTIL.Counter.OnExecute

(Doc ID 2330673.1)

Last updated on NOVEMBER 21, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 and later
Information 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 500284
3. Schedule Interview
4. Submit Interview


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Schedule Interview.

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