Get JBO-27122 Error 'java.sql.SQLException: Missing IN or OUT parameter at index:: 1' when Creating Offer Letter to an Employee Candidate

(Doc ID 1285698.1)

Last updated on FEBRUARY 19, 2018

Applies to:

Oracle iRecruitment - Version 12.1.2 and later
Information in this document applies to any platform.


When attempting to create offer to an Employee Candidates, the following error occurs.

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pln.pl_id pl_id,
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(

Steps to Reproduce
     The issue can be reproduced at will with the following steps:
     1. Responsibility: iRecruitment Recruiter
     2. Navigation: Vacancies tab
     3. Search for vacancy
     4. Press View Applicants button
     5. Select applicant
     6. Create offer
     7. Get error message


This is not an issue with external candidates.


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