iRecruitment External Candidate Registration Without Resume Gives Error JBO-27122

(Doc ID 1334055.1)

Last updated on NOVEMBER 26, 2015

Applies to:

Oracle iRecruitment - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
***checked for relevance on 26-JUN-2014***


When attempting to register as a new external candidate, the following error occurs:

Exception Details.
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume,'Resume.htm' as FileName,:4 as RESUME_STYLE from dual
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 oracle.apps.irc.candidateSelfService.webui.AplRegCreateResumeCO.processRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest( at

The issue can be reproduced at will with the following steps:
1. New external user registers for the first time and does not upload a resume at the beginning of the registration process.


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