My Oracle Support Banner

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 NOVEMBER 23, 2020

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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.