My Oracle Support Banner

When Adding Potential Duplicate Applicants, Error: JBO-27022 Invalid Column Index (Doc ID 2323985.1)

Last updated on AUGUST 05, 2022

Applies to:

Oracle iRecruitment - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP10 version, Candidate Management

When attempting to add potential duplicate applicants, the following error occurs.

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Exception details:

oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException:
JBO-27022: Failed to load value at index 28 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getObject(
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(
at oracle.jbo.server.ViewRowImpl.populate( oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(
at$ com.evermind.util.ReleasableResourcePoo


Steps to Reproduce:

The issue can be reproduced at will with the following steps:

1. Log on to the Applications.

2. Choose the responsibility iRecruitment Recruiter.

3. Navigate to iRecruitment Home-> Candidates-> Applicants.

4. Search for applicants using a first name, e.g. 'First_Name%'.

5. Click the Find Duplicates link for one of the records in the search results which appear to have a duplicate.

6. Click on the Add Potential Duplicate button.

7. Search for applicants using the same name used in item 5 above, e.g. <First_Name%>

8. Click the Go button.


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

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