My Oracle Support Banner

External User Unable to Apply For Vacancy, getting 'JBO-27122: SQL error during statement preparation' and 'java.sql.SQLException: Missing IN or OUT parameter at index' Error (Doc ID 1991188.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


On : 12.1.3 version, Candidate Self Service

When attempting to submit an application for a vacancy an external candidate
receives the following error

500 Internal Server Error
Exception Details
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT IRF.SOURCE_TYPE , IRF.SOURCE_NAME , IRF.SOURCE_CRITERIA1 , IRF.SOURCE_VALUE1 , IRF.SOURCE_CRITERIA2 , IRF.SOURCE_VALUE2 , IRF.SOURCE_CRITERIA3 , IRF.SOURCE_VALUE3 , IRF.SOURCE_CRITERIA4 , IRF.SOURCE_VALUE4 , IRF.SOURCE_CRITERIA5 , IRF.SOURCE_VALUE5 , IRF.SOURCE_PERSON_ID , IRF.CANDIDATE_COMMENT , IRF.EMPLOYEE_COMMENT , IRF.CREATED_BY , DECODE(IRF.SOURCE_TYPE,'ER',PPF.full_name, IRF.SOURCE_NAME) AS REFERRED_BY FROM IRC_REFERRAL_INFO IRF, per_all_people_f PPF WHERE SYSDATE BETWEEN IRF.START_DATE AND IRF.END_DATE-(1/86400) AND IRF.SOURCE_PERSON_ID = PPF.PERSON_ID(+) AND TRUNC(SYSDATE) BETWEEN NVL(PPF.EFFECTIVE_START_DATE, TRUNC(SYSDATE)) AND NVL(PPF.EFFECTIVE_END_DATE, TRUNC(SYSDATE)) AND IRF.OBJECT_ID = :1 AND IRF.OBJECT_TYPE = :2 at oracle.apps.fnd.framework.OAException.wrapperException( at oracle.apps.fnd.framework.OAException.wrapperException( at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException( at oracle.apps.fnd.framework.server.OAUtility.invokeMethod( at oracle.apps.fnd.framework.server.OAUtility.invokeMethod( at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod( at ............................
## Detail 0 ## java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow( at oracle.jdbc.driver.OraclePreparedStatement.executeInternal( at oracle.jdbc.driver.OraclePreparedStatement.executeQuery( at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery( at oracle.jbo.server.QueryCollection.buildResultSet( at oracle.jbo.server.QueryCollection.executeQuery( at

The issue can be reproduced at will with the following steps:
1. External Candidate searches for a vacancy
2. Finds vacancy and clicks 'Apply Now'
Error occurs




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.