My Oracle Support Banner

Oracle Fusion Recruiting Cloud: Error Running ESS Job: "ORA-12899: value too large for column ???" (Doc ID 2676534.1)

Last updated on MARCH 29, 2021

Applies to:

Oracle Recruiting Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

Problem Description:

When running the following ESS Job, the job fails.

Failed message:

This Process ran but resulted in an error and will be retried.

The following error can be seen in the Error Log:

oracle.as.scheduler.ExecutionErrorException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-12899: value too large for column ??? (actual: 34, maximum: 32) ORA-06512: at "FUSION.IRC_LOAD_EMP_INTO_CAND_PKG", line 229 ORA-06512: at "FUSION.IRC_LOAD_EMP_INTO_CAND_PKG", line 304 ORA-06512: at "FUSION.IRC_LOAD_EMP_INTO_CAND_PKG", line 321 ORA-06512: at line 1 at oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(ExecWrapperBase.java:231)...

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.