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

Symptoms

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

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException:
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(OAException.java:896)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762) at oracle.apps.irc.candidateSelfService.webui.AplRegCreateResumeCO.processRequest(AplRegCreateResumeCO.java:48)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596) at

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

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