My Oracle Support Banner

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.


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:

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

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.