Getting Error JBO-27122 with 'java.sql.SQLException: Missing IN or OUT parameter at index::1' While Viewing an Applicant Details

(Doc ID 1349228.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle iRecruitment - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2014***

Symptoms

On : 12.0.6 version, General iRecruitment

When attempting to view applicants data, the following error occurs.

ERROR
-----------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtExceptio: JBO-27122:SQL error during statement preparation.

## Details 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index::1

STEPS
-----------
The issue can be reproduced at will with the following steps:
1. Vacancy Tab > Active Applicants link > Jobs Applied For link > Application Details

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