Error When Update Offer While Using iRecruitment Recruiter Responsibility “You Have Encountered an Unexpected Error” and “ JBO-27126: Long Running Query Has Been Cancelled” and “ORA-01013: User Requested Cancel of Current Operation”
(Doc ID 2925844.1)
Last updated on JULY 27, 2024
Applies to:
Oracle iRecruitment - Version 12.2 HRMS RUP16 and laterInformation in this document applies to any platform.
Symptoms
When attempting to update an offer while using iRecruitment Recruiter responsibility
the following error occurs.
ERROR
-----------------------
1. Error displayed on the user page as below:
You have encountered an unexpected error....
2. Error displayed on Java Error Stack log as below:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27126: Long running query has been cancelled. Statement: SELECT bg.NAME AS BUSINESS_GROUP,
bg.ORGANIZATION_ID AS ORGANIZATION_ID1,
org.NAME AS ORG_NAME,
org.ORGANIZATION_ID AS ORGANIZATION_ID2,
...................
## Detail 0 ##
java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:464)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1004)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:544)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:240)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) iRecruitment Recruiter responsibility -> Search for any Vacancy by Name.
2. Click on Find Applicant button - > Go to Offer tab.
3. Click on Update Offer -> Enter details for the offer -> Click on Continue -> Error is raised on page.
Changes
Database upgrade to 19C and application update to RUP16.
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 |
| Changes |
| Cause |
| Solution |
| References |