When Adding Potential Duplicate Applicants, Error: JBO-27022 Invalid Column Index

(Doc ID 2323985.1)

Last updated on NOVEMBER 06, 2017

Applies to:

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

Symptoms

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(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1183)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1457)
..
..
## Detail 0 ##
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:1042)
at oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1200)
at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634)
at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1073)
..
..
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)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. 'John%'.

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. 'John%'

8. Click the Go button.



Changes

 

Cause

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 hundreds of Community platforms