My Oracle Support Banner

JBO-27122 and ORA-20103 Errors Undefined Entity "nbsp" When Trying to Register in iRecruitment without a Resume (Doc ID 943923.1)

Last updated on MAY 07, 2018

Applies to:

Oracle iRecruitment - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


Problem Statement:
When a user attempts to register in iRecruitment without a resume via the external
iRecruitment site, the following error occurs.

You have encountered an unexpected error. Please contact the System Administrator for

Exception details contains the following lines:

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.wrapperInvocationTargetException(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
## Detail 0 ##
java.sql.SQLException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00118: Warning: undefined entity "nbsp"
Error at line 9
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 414
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 428
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(
at oracle.jdbc.driver.DatabaseError.newSQLException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(

Steps To Reproduce:
1. Go to iRecruitment's External Visitor URL.
2. Click on the 'Register Today' button.
3. Enter the required details on each page and click the 'Next' button.
4. When asked about resume, choose 'No, I do not have a resume.'
5. Enter the required details on each page and click the 'Next' button.


To view full details, 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 a vibrant support community of peers and Oracle experts.