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 JULY 12, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Candidate Self Service

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

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(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at ............................
.............................
## Detail 0 ## java.sql.SQLException: Missing IN or OUT parameter at index:: 1 at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1783) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at


STEPS
-----------------------
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



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