Oracle Fusion Recruiting Cloud: Error Running ESS Job: "ORA-12899: value too large for column ???"
(Doc ID 2676534.1)
Last updated on JANUARY 26, 2023
Applies to:
Oracle Recruiting Cloud Service - Version 11.13.20.04.0 and laterInformation in this document applies to any platform.
Symptoms
Problem Description:
When running the following ESS Job, the job fails.
- Load Workers into the Candidate Table
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 |