While Viewing The Page For Active Applicants an error occurs, "You have encountered an unexpected error. Please contact the System Administrator for assistance."
(Doc ID 2575618.1)
Last updated on MARCH 20, 2025
Applies to:
Oracle iRecruitment - Version 12.1 HRMS RUP11 to 12.2.9 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
Problem Statement:
When users click on “iRecruitment Home”, then they click on “ Active Applicants”, then clicks on an Applicant Name the user receives the following error message:
"You have encountered an unexpected error. Please contact the System Administrator for assistance."
Exception details:
## Detail 0 ##
java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table
Exception details:
## Detail 0 ##
java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Log into the Applications.
2. Click on the responsibility iRecruitment Recruiter.
3. Navigate to iRecruitment Home-> Vacancies.
4. Search for a vacancy.
5. Click on the Active Applicants link for the vacancy.
6. Click on an applicant.
Changes
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 |